COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kwalter on 18 Jun 2010 03:15:46 PM

Title: Using results from 1 report to filter another report
Post by: kwalter on 18 Jun 2010 03:15:46 PM
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?
Title: Re: Using results from 1 report to filter another report
Post by: rlp on 18 Jun 2010 06:02:03 PM
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