COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Vish on 08 May 2011 11:45:57 PM

Title: Active report Drill down and Drill Up
Post by: Vish on 08 May 2011 11:45:57 PM
Drill Down and Drill Up is not working in Active reports.I am using dimensional package..If anyone having Idea for drill down please share with me.
Title: Re: Active report Drill down and Drill Up
Post by: lomo_ve on 10 May 2011 11:46:56 AM
I think drill up and drill down is not allowed for Active Reports
Title: Re: Active report Drill down and Drill Up
Post by: lindero on 31 May 2011 10:40:03 AM
Hi,

automatically there is no drill behavior. But you can implement it, by using multiple decks for each level. The decks will be hidden or displayed depending on a status of a variable.

I did it by myself. It works really fine. but there is a manual effort.

cheers.
Title: Re: Active report Drill down and Drill Up
Post by: Vish on 01 Jun 2011 03:30:18 AM
Thanks for idea.... :)
Title: Re: Active report Drill down and Drill Up
Post by: Vish on 17 Jun 2011 07:25:37 AM
Can you please send me steps ....
Title: Re: Active report Drill down and Drill Up
Post by: lindero on 01 Jul 2011 02:33:51 AM
Hi,

sorry for being late. I'm not here every day.

Well, here are some steps. You use 3 decks for an 3 level drill approach. The first deck ist static. It shows the highest data level in your hierarchie. All decks have an empty default card. It is a property of the deck object.

The next deck is data driven. The values of your first level must be placed there. The list shows your data of the second level. You have to link the list with the data deck as a master detail relationship. Now, you have to create a active report variable to set the interaction between these controls. When the variable is set, the second deck has to be displayed and the first one must disappear.

The last deck is data driven as well. Same as the second.

Hope, this helps.
Title: Re: Active report Drill down and Drill Up
Post by: nj.neha_jain on 21 Feb 2012 03:57:03 AM
Hi, 
I am new o active reports and trying to do drill up and drill down since 1 week. Can you please send the screenshots or video to do drill down in active reports.
MY email id has been removed by a funny-looking moderator with red spiky hair and a muppety appearance.
Thanks & Regards
Neha
Title: Re: Active report Drill down and Drill Up
Post by: Chowdary2009 on 30 Mar 2012 02:09:13 AM
Hi lindero,

       Thanks for your Answer. But i tried from my end, i did not get the drill behavior one. Could you please send me the detailed steps.

With Regards,
Aravind kellampalli.
Title: Re: Active report Drill down and Drill Up
Post by: MFGF on 30 Mar 2012 03:57:37 AM
What did you try, and what issues are you getting?
Title: Re: Active report Drill down and Drill Up
Post by: funkigreendog on 01 Apr 2012 11:32:55 PM
The attached sample demo's drill down behaviour and contains the report xml.
Title: Re: Active report Drill down and Drill Up
Post by: antih on 15 Apr 2012 05:56:23 AM
Another approch for drilldowns is to use normal Decks (each deck contains a specific level).
I used the example of funkigreendog and rearranged it a little bit for the deckdriven drillup/down.
Title: Re: Active report Drill down and Drill Up
Post by: reena on 15 Apr 2013 11:07:27 AM
somebody plz help me to make drill up drill down in active report, plz give me steps.
Title: Re: Active report Drill down and Drill Up
Post by: RKMI on 15 Apr 2013 11:16:58 AM
Hi,

This post has all the info from creation, to sample report spec and even a output of the result. What steps are you confused on?

Thanks,
RK