COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: srinu_anu2007 on 22 Jan 2014 05:58:52 AM

Title: Drill up and Down using DMR package in crosstab
Post by: srinu_anu2007 on 22 Jan 2014 05:58:52 AM
Hi,

Please find the attachement and give some ideas.

Thanks,
Title: Re: Drill up and Down using DMR package in crosstab
Post by: BigChris on 22 Jan 2014 06:14:49 AM
My idea is that that's a lovely attachment...
Title: Re: Drill up and Down using DMR package in crosstab
Post by: MFGF on 22 Jan 2014 06:19:15 AM
Hi,

You can do this out-of-the-box in Cognos Workspace Advanced

Right-click on Camping Equipment and choose Explore > Expand Member

(https://image.ibb.co/cCG4iQ/Expand1_zps482f7791.png)
(https://image.ibb.co/cfFmxk/Expand2_zpseefc4123.png)

Cheers!

MF.
Title: Re: Drill up and Down using DMR package in crosstab
Post by: srinu_anu2007 on 22 Jan 2014 06:38:29 AM
where is your attachement
Title: Re: Drill up and Down using DMR package in crosstab
Post by: MFGF on 22 Jan 2014 07:12:16 AM
Quote from: srinu_anu2007 on 22 Jan 2014 06:38:29 AM
where is your attachement

There are no attachments. I embedded IMG links to image files on imgbb.com. If you can't see them in the post, you could try the direct urls below:

https://image.ibb.co/cCG4iQ/Expand1_zps482f7791.png
https://image.ibb.co/cfFmxk/Expand2_zpseefc4123.png

Cheers!

MF.
Title: Re: Drill up and Down using DMR package in crosstab
Post by: srinu_anu2007 on 23 Jan 2014 01:52:56 AM
Hi MF,

Your idea is working in 'Workspace Advanced' but they want to see in report studio. If you have any java script to achieve this please share.

Hello any body worked on the same requirement please share your ideas.

Thanks,
Sri
Title: Re: Drill up and Down using DMR package in crosstab
Post by: MFGF on 23 Jan 2014 02:57:31 AM
Quote from: srinu_anu2007 on 23 Jan 2014 01:52:56 AM
Hi MF,

Your idea is working in 'Workspace Advanced' but they want to see in report studio. If you have any java script to achieve this please share.

Hello any body worked on the same requirement please share your ideas.

Thanks,
Sri

I'd honestly suggest you push back and tell them the functionality is available if they use the right tool. Doing it manually is ugly and a nightmare to maintain. If you're adamant that's what you want, take a look at these links:

http://www-01.ibm.com/support/docview.wss?uid=swg21377785

http://www.cognosonsteroids.com/2012/02/create-report-with-collapsible.html

MF.