Drill down and peers disappear

[MikeG]

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 

[MFGF]

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:




Cheers!

MF.

[MikeG]

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

[CognosPaul]

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.