COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Universe09 on 27 Feb 2009 01:40:41 AM

Title: Help: How to Drill Down Data
Post by: Universe09 on 27 Feb 2009 01:40:41 AM
Hi,

Is it possible that when I click the data in cross table it will drill down to a more detailed table?

Thanks!
Title: Re: Help: How to Drill Down Data
Post by: Gollapudi on 27 Feb 2009 03:01:08 AM
Yes, you can drill down in Cross tab too.. but your package should be a dimentional package to have the facilities of drillup and drill down
Title: Re: Help: How to Drill Down Data
Post by: Universe09 on 28 Feb 2009 03:54:46 AM
Hi,

I Tried to use the Drill behavior since I'm using a dimensional package, but is it also possible that I can drill down by clicking the measures used in the table?

Thanks!
Title: Re: Help: How to Drill Down Data
Post by: Gollapudi on 02 Mar 2009 03:22:01 AM
Hi,

Even though its a dimentional package, you can not do Drill up and Drill down with the Fact cells, you can do only at either rows are columns, and you should make sure that you checked the check box "Allow drill-up and drill-down" at Drill behavior [which is in Data Tab from Tool bar]

Gollapudi.
Title: Re: Help: How to Drill Down Data
Post by: Universe09 on 08 Mar 2009 10:50:22 PM
Hi,

Is this limitation also apply in the cognos 8.3 version? or is there other way to make the measures act as a link that will jump to other pages once clicked?

Thank You for the response!
Title: Re: Help: How to Drill Down Data
Post by: Gollapudi on 08 Mar 2009 10:55:37 PM
Yeah, same in Cognos 8.3 too...