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 a Generalized Summary Report

Started by dangerous_mind, 18 Apr 2014 03:22:14 PM

Previous topic - Next topic

dangerous_mind

I have a requirement which goes like this :
I have a dashboard in which there are around 25 metrics. On clicking each metric a summary report opens up. So in all there are 25 summary reports. Now the user wants a single generalized summary report meaning on clicko of any metric this single generalized report should open. This report  has the following prompts :
Date
Region
Name of the metric

One possiblity of achieving this is by using conditional blocks. But the only problem is the design would be a big mess and the report would run for ages..
Can anyone suggest any other alternative

navissar

You could use a token macro prompt for the metric column.
You get your metrics prompt so that use value is [package]. [namespace]. [query subject]. [metric] and the display value is the name of the metric. Then, your metric column should be
#prompt('metric parameter name', 'token', 'default metric') #.