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

Using results from 1 report to filter another report

Started by kwalter, 18 Jun 2010 03:15:46 PM

Previous topic - Next topic

kwalter

We are currently working through implementing SunGard's ODS / EDW and have adopted Cognos as our campus reporting tool.  Prior to this we were a Hyperion report campus.  Need to know if it is possible to run one report from package 1 and then use the results from that package as a filter for package 2 report.  Anyone have any experience with this?

rlp

Between packages, your best best is to add drill-through definitions that pass data item values in the source report as filter parameters to the target reports.  You will probably have to pass caption or business key values as parameters, since the MUN values are usually unique to package.

See also:

http://publib.boulder.ibm.com/infocenter/caapps/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cc.8.4.1.doc/ug_cc_i_CreateDrillThroughDefinitions.html