COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: collierd on 12 May 2009 11:48:56 AM

Title: DMR drill through
Post by: collierd on 12 May 2009 11:48:56 AM
Hello

I am using Cognos 8.2

I have created a report using DMR that has a column available for drill up/down
What I want to do is drill through from that column to another report

Problem is, if I enable drill through, it works at every level
Drill through should only be available at the mowest level as this is the level with the relevant item value for the opposing report

Does anybody know if this is possible

Thanks

Damian.
Title: Re: DMR drill through
Post by: david.stachon on 13 May 2009 02:09:51 AM
As opposed to creating drill through in your report, you'll need to build a drill-through definition in Cognos Connection....then, set the "Scope" to the particular level you want to allow drill through on.

(this will make "Available Links" populate a drill through target only when a user attempts to drill through on that level)

...the huge drag about 8.2 is you have no configurability over what you can pass through to the target report. I actually found 8.2 to be a nightmare in this respect.

If you could get to 8.4, they made unbelievable improvements on this functionality.....including this awesome little feature called "Dynamic Drill Through" (which prevents the need to painstakingly map every parameter.)   ...and if you want, you can configure what you want to pass through (i.e. MUN, business key, description, level number, etc...) ....it's just fantastic.