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.
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.
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