If you are unable to create a new account, please email support@bspsoftware.com

 

Relative drill up /drill down in Cognos Work space

Started by tushar gaurav, 13 Jan 2015 04:23:15 AM

Previous topic - Next topic

tushar gaurav

There are three charts coming from three different reports.
Chart 1 have quantity,year and order method.
Chart 2 have revenue ,product line and order method.
Chart 3 have gross profit,Product brand and order method.
We have imported these 3 charts in Work Space now the requirement is that ,when we apply drill down in chart 1 the data in other two chart should also be affected and viceversa.
How can we achieve this scenario.
I am using dimensional modelling.

MFGF

Quote from: tushar gaurav on 13 Jan 2015 04:23:15 AM
There are three charts coming from three different reports.
Chart 1 have quantity,year and order method.
Chart 2 have revenue ,product line and order method.
Chart 3 have gross profit,Product brand and order method.
We have imported these 3 charts in Work Space now the requirement is that ,when we apply drill down in chart 1 the data in other two chart should also be affected and viceversa.
How can we achieve this scenario.
I am using dimensional modelling.

As far as I'm aware the only way to do this is to have all three charts based on the same query in the same report.

MF.
Meep!

cognos810

Hello tushar gaurav,
In Cognos 10.2.1 workspaces I have noticed that, as long as the source for the dimension is the same in terms of the dimensional query subject being used, the drill up/down happens on all containers(charts in your case) by default. If its not happening for you, then please make sure that "Drill" is selected under "Listen for Widget Events" for each widget and that each widget is listening for the other two widget drill events.

-Cognos810