Hi All -
I cannot seem to find a straight forward answer to this question. I am using a cube/Tm1 with a crosstab report. I have a Time Dimension consisting of Year --> QTR --> Month.
In this particular report, I want to display the Year in the crosstab and when the user drills down, skip the QTR level and show all of the Months in that particular year. I have tried all of the combinations of the advanced drill down behavior and nothing is working. I tried to do a change expression and point to descendants(Year, 2) and that basically shows ALL months instead of just the months in that particular year I'm clicking on.
Does anyone know how to do this or if it is even possible in a drill down?
Thanks in advance!
Hi,
How many reports you have that has same requirement? if there are lot of reports with the same requirement then ask the TM1 guys to create a level with Years and months(If it is possible). The immediate solution is, If it is only couple of reports create another page on the same report for mth's and pass the year as a parameter and get the descendants 2 and use it in the report. There can be other solutions too but this is the solution I would try depending on the time constraint.
Good luck
New guy