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

Dimensional Data - Drill Down to all values

Started by okh310, 20 Nov 2017 09:29:57 AM

Previous topic - Next topic

okh310

I have dimensional Time data that I would like to drill down on.  The levels go from Year --> Quarters --> Month.

What is currently happening on Drill down:
Report displays Years 2015, 2016, 2017.  I click on let's say "2016" and the report shows the Quarters for 2016. 

What I want to happen on Drill down on any year:
I want it to show ALL lower level quarters.  So in this example if I click on 2016, show Q1 2015, Q2 2015, Q3 2015, Q4 2015,  Q1 2016, Q2 2016, Q3 2016, Q4 2016,  Q1 2017, Q2 2017, Q3 2017, Q4 2017. 

Is something like this possible?  TY in advance.

rockytopmark

Yes, is possible... you have to set advance drilling options.  I don't have a 10.x instance available to give you more details, sorry about that.

rockytopmark

By default, drilling down does a replace expression... in the Advanced Drill definition, change to Change Expression, and set it toa data item that returns the set of Quarters that you desire