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

Store the values in COGNOS to use later

Started by ipmurali, 04 Jun 2014 02:58:47 AM

Previous topic - Next topic

ipmurali

Hi,
I need to make a summary sheet based on a detail report:
The detail report is generated by two different stored procedures:
for eg: detail report is giving two figures A and B
in summary sheet i have to show figure C which is the sum of A and B (C=A+B)
how can i accomplish this in COGNOS 8.2 version.

Is there a way to store the values in COGNOS to use later?






cognostechie

The way to do that is to make sure the filters in C are equivalent of A+B. Basically, make a copy of the detailed query, apply the totals, then hide everything else except the totals.

Without looking at your detailed queries and layout, I can only give you a guideline, not exact steps.