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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating many instances of a report w/ different variables

Started by mmckeen1, 01 Mar 2010 10:59:02 AM

Previous topic - Next topic

mmckeen1

I have created a report that needs to be run once a week using a combination of variables.  I'd like to keep this as scalable as possible, and my challenge is to come up with a solution as there are 330 combinations that I need to account for.  This represents running the report using one selection for 'Filter A' and 'Filter B.'  In addition, there are 8 different data sources.  I'm running 8.4 using a relational package.  Any ideas would be greatly appreciated!

kattaviz

Hi,

If you want to run the report with different prompts then the bet way is to create a report view and define the prompt values. Is this what you are looking for?

HTH

Satish
thanks & regards
Satish Katta

mmckeen1

I have the report set up to use the prompts, but my problems are that there are 330 combinations of Filter A and Filter B.  I need the report to run every week, and I don't want to create multiple instances of the report.  I've thought of using Event Studio, but I would have to set up 330 events to get the desired results.  I just wondered if there was a way to do this so to keep it scalable.  For example, if the report spec changes, I only want to have to change it in one place.  If the desired delivery day changes, then I want to be able to update that in the fewest places.  I have a feeling this project is going to grow even larger, so my goal is to make it as managable as possible.

CognosPaul

I would try using the burst functionality in order to achieve this. Have a table that includes each possible combination. Stick that table in a page set, with your reports inside that using master/detail, and burst on that table. This should generate an individual report for each row in that table, and if the master/details are set correctly it should be exactly what you need.