If you are unable to create a new account, please email support@bspsoftware.com

 

Filter and download multiple specific reports using an "Master report"

Started by PaulM100, 11 Jan 2024 02:36:08 AM

Previous topic - Next topic

PaulM100

Hello,

Is it possible to filter and download multiple reports from various locations and also different connections from a single report, something like a Master report?

The idea is that we have multiple reports filtered by date, 20+, and sometimes we need to go back and extract them for a specific date or interval which is manually done and time consuming. Normally, these reports are sent via email with an already specified interval parameter.

Thanks

cognostechie

Technically, every report is a separate object but you can combine them. Report allows multiple Tabs (pages) so you can put those 20+ reports together in one report (one report on each tab) which would then work with the same date parameter. Cognos allows to copy the entire page from one report to another and when you do that, it will bring in the queries too so it's doable.

dougp

QuoteCognos allows to copy the entire page from one report to another and when you do that, it will bring in the queries too so it's doable.

But if many of these reports use the same queries, you'll get a lot of MyCustomQuery1, MyCustomQuery2, etc. making maintaining that a nightmare.  Touching each visualization and changing the query to the base query, then deleting all of the now-unnecessary queries will make report maintenance easier, but requires some work up front.

Assuming the original reports are emailed to various recipients or groups of recipients on a schedule, this solution can work by creating bursting based on page name or some equivalent data item.  It may be tricky, but it's doable with a little imagination.

cognostechie

Quote from: dougp on 16 Feb 2024 12:28:10 PMBut if many of these reports use the same queries, you'll get a lot of MyCustomQuery1, MyCustomQuery2, etc. making maintaining that a nightmare.  Touching each visualization and changing the query to the base query, then deleting all of the now-unnecessary queries will make report maintenance easier, but requires some work up front.

Of course, you have to rename the queries after they are copied.


Quote from: dougp on 16 Feb 2024 12:28:10 PMAssuming the original reports are emailed to various recipients or groups of recipients on a schedule, this solution can work by creating bursting based on page name or some equivalent data item.  It may be tricky, but it's doable with a little imagination.

The OP's question is different than what you think. He wants to provide the parameter values only once and all reports should filter the data with that.

dougp

QuoteHe wants to provide the parameter values only once and all reports should filter the data with that.

I get that.  But where I do that, typically report 1 goes to recipient list A, report 2 goes to recipient list B, etc., on a schedule.  While the question was clear about the parameter issue, there is still vagueness regarding the details of the output and delivery.  I was trying to fill in those gaps with likely circumstances based on my own experience.

cognostechie

Output and delivery don't matter in this case because the OP didn't mention anything about that so we have to presume that there are no exceptions/complicacies there. Moreover, output can be defined differently during interactive run or schedules.