COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Bharath Reddy on 17 Jan 2018 12:13:57 PM

Title: Drill down and Drill Up
Post by: Bharath Reddy on 17 Jan 2018 12:13:57 PM
Hi,

In my project i need to get drill down in sales report

i have used a list with five columns
Group A, Group B, Group C, Revenue

when i click group  A , it should display group b as sub group and when i click group B it should display group c as sub group of group B

Thanks
Title: Re: Drill down and Drill Up
Post by: MFGF on 18 Jan 2018 02:08:55 AM
Quote from: Bharath Reddy on 17 Jan 2018 12:13:57 PM
Hi,

In my project i need to get drill down in sales report

i have used a list with five columns
Group A, Group B, Group C, Revenue

when i click group  A , it should display group b as sub group and when i click group B it should display group c as sub group of group B

Thanks

Hi,

Are you using a dimensional package? Drill down/up and expand/collapse are available out of the box with dimensional packages. If you are using 11.0.8 or later you can also get similar capabilities to drill down/up using navigation paths defined in a data module.

Cheers!

MF.