If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DMR drill through

Started by collierd, 12 May 2009 11:48:56 AM

Previous topic - Next topic

collierd

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.

david.stachon

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.