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

Run the same report with different parameters

Started by mshparber, 20 May 2015 06:19:22 AM

Previous topic - Next topic

mshparber

Hello friends,

I've build a report that compares this week debts status with previous week debts status.

I want to give my users 3 option - 1. see last week changes (as described), 2. see changes over two weeks. 3. see changes over a month
I cannot do it all in one report without having to duplicate my queries
So I can make a parameter "NumberOfDaysParam" that my query will use when running

How do I schedule this one report so it saves 3 different results (reports) by changing the parameter, so that my users can instantly access the snapshot without having to run the report with different parameter value?

Thank you
Michael

Michael75

#1
It's not quite clear from your post, but I'm assuming that your parameter "NumberOfDaysParam" is working to your satisfaction.

There are two ways that I know about of satisfying your requirement.

1. Start with the New Job Wizard (click on the New Job icon), and on the second screen, add your report three times. Then, click on the pencil under Options and prompt values, and set the Prompt Values for each occurrence.

2. First create three Report Views of your report, preferably giving them names which indicate the time period covered. Then modify each, by specifying the Prompt Values. Next, proceed as above, adding each view once instead of adding the report three times.

In both cases, under Select Default Options, you can specify Report Options, such as Save as PDF / Excel / whatever

Also, in both cases, the New Job dialogue will lead to the Select an action - job screen, where you probably want to choose Save and Schedule. Create a schedule with the frequency that suits you.

I gather that you would like the results for the three versions to be instantly available within Cognos Connection, so in fact my option 1 above is not suitable. You need three objects within Cognos Connection so that your users are able to go directly to the pre-run output. (Option 1 would be viable if you were bursting or emailing the output to recipients)/

So try my option 2, and post back if you have problems :)

EDIT: Just realised that you posted this in the Active Reports board, whereas my advice is based on working with "classic reports"  :-\
If you are working with Active Reports, then I'm not sure how applicable my reply is to your requirement...

mshparber

Hi Michael,

Yes, the 3 ReportViews do the trick!
Each View runs with its own parameter and saves the output separately from the others!
Problem solved!

Thank you very much!
Michael