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

Skipping a level in a drill down

Started by okh310, 03 May 2017 11:12:54 AM

Previous topic - Next topic

okh310

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!

New_Guy

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