COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Ann on 31 May 2013 04:17:12 AM

Title: drill down to show the child in next column
Post by: Ann on 31 May 2013 04:17:12 AM
I want to implement Drill down  on a particular hierarachy. Say Region. If I click region1, The districts of Region1 should appear as next column to Region1.

Any Clue how to implement this?
Title: Re: drill down to show the child in next column
Post by: RKMI on 31 May 2013 10:52:58 AM
Hi Ann,

I'm not sure if you can do it with drill down but you can do it by using a render variable with drill though to itself... where you create a hidden column and unhide when the region is click. I hope this makes sense.

I know it's also possible in an active report where you need to design use data decks to mimic a drill down... Drawback you can't export to excel, pdf...

Thanks,
RK