COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 31 Jan 2011 10:38:51 AM

Title: how to define drill throguh for one measure
Post by: jd on 31 Jan 2011 10:38:51 AM
Hi I have a crosstab with multiple measures.

Measures are rows like row1 row2 etc.. Region is crosstab colummn.

I have to define the drill through on only one measure, so I did unlock page objects and tried to define the drill through on only one measure but drill through is applying for all the measure cells.

Is there any way to apply drill through for only one measure??

Thanks
Title: Re: how to define drill throguh for one measure
Post by: CognosPaul on 31 Jan 2011 11:52:45 AM
First unlock the report.

Click on the intersection of the containing the measure, set Define Contents to Yes, drag in a new text item and set the source type to Cell Value.

Now you can make a drill through for that intersection, without affecting the other intersections.
Title: Re: how to define drill throguh for one measure
Post by: jd on 31 Jan 2011 12:28:55 PM
Thanks PaulM,

it is working perfectly how I wanted.

Thanks again