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

Chart not working with prompt and drill thru

Started by cognos_sourabh, 11 Jul 2015 08:25:49 AM

Previous topic - Next topic

cognos_sourabh

Hi All,

Need help in implemention of a logic. I have a value prompt named P_FiscalYear. My report contains two charts - both of them are bar graphs. Now the 1st chart is having Fiscal Year in its X Axis running based on the default values or the values of P_FiscalYear. This chart is a drill through chart that runs the same report and filters out the data of itself and second chart.

The chart is working fine with the drill thru definition with the parameter (pYear) of the 1st chart. Issue here is that I am not able to filter the second chart based on the P_FiscalYear (the prompt). What is need here is when the user selects the prompt P_FiscalYear it should filter both the charts and when the drill thru is used in the first chart it should also filter out both the charts.

Any guidelines will be helpful.

Thanks