Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rprameshwor on 11 Jun 2013 10:58:59 PM

Title: Multiple column drill down at single click
Post by: rprameshwor on 11 Jun 2013 10:58:59 PM
Hello All ,

Is  there someway i can drill down in multiple columns by clicking on a single column. ?

eg :-
I have 3 columns

Item , time [ Year -> Month ] , Org [ Region -> Location ]

Item | Time | Org
-----------------------
Itm1 | Year | Reg1

n when i click on Itm1 , then time and Org hierarchies should be drilled down to make the report

Item | Time | Org
-----------------------
Itm1 | Mnth1 | Loc1
Itm1 | Mnth1 | Loc2
Itm1 | Mnth2 | Loc1
Itm1 | Mnth2 | Loc2

Drill through might be a solution , but going with the drill through requires a lot of reports to be created in our case . So , anyways around this ?

Thanks in Advance ,

Title: Re: Multiple column drill down at single click
Post by: Satheesh on 12 Jun 2013 01:01:13 AM
Hi,
Is This DMR Model or Relational Model...??
If you go through the DMR Models it is easy... It will com automatically....There you can use Tree prompt..
Title: Re: Multiple column drill down at single click
Post by: rprameshwor on 12 Jun 2013 02:44:55 AM
Sorry , I forgot to mention in my Original Post . Yes, its a DMR Model.  And its a List Report with above mentioned columns.

and I dont understand , how it comes automatically.
Text only | Text with Images