Hi,
Using Cognos 10.2 against TM1 cubes
This is a simple example of a problem that I keep having through many reports.
Here simply I have columns as quarters of the year and I make them drillable on
see attachment Unexpanded
I double click on the 3rd quarter , which opens correctly to reveal 3 separate months. However Quarters 1 , and 4 have now disappeared
see attachment Expanded
How can I keep all the Qtrs visable when I drill down on one
thanks for any help
Mike
Quote from: MikeG on 05 Jan 2015 06:08:25 AM
Hi,
Using Cognos 10.2 against TM1 cubes
This is a simple example of a problem that I keep having through many reports.
Here simply I have columns as quarters of the year and I make them drillable on
see attachment Unexpanded
I double click on the 3rd quarter , which opens correctly to reveal 3 separate months. However Quarters 1 , and 4 have now disappeared
see attachment Expanded
How can I keep all the Qtrs visable when I drill down on one
thanks for any help
Mike
Hi,
The behaviour you are describing is exactly the way drill-down is supposed to work. I think what you're looking for is the "Expand Member" option? If so, this is available in Cognos Workspace Advanced out-of-the-box:
(https://image.ibb.co/cCG4iQ/Expand1_zps482f7791.png)
(https://image.ibb.co/cfFmxk/Expand2_zpseefc4123.png)
Cheers!
MF.
Thanks for your help MF
The users have been asking for more and more analysis and I have been trying to do it all in Report Studio, I will look to start using Workspace Advanced for this
Again thanks
Mike
If you're willing to get your hands dirty with JavaScript, you could use an expand/collapse solution I wrote:
http://cognospaul.com/2014/09/29/expand-collapse-cognos/
Clicking on the plus will add the member to a hidden prompt and refresh the page. The members in the hidden prompt will have their children unioned to the set on the crosstab edge. The hierarchize function will put them back into their natural order. Level indentation will pad the descendants as expected.