COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: ratikant on 30 Sep 2005 12:15:01 AM

Title: Drillthrough - How to decide the target based on the data
Post by: ratikant on 30 Sep 2005 12:15:01 AM
Hi Gurus,
I have a requirement like this.

Parent report has a drillthrough on one column. At run time when we click on different link, it should execute different target reports.

Ex.Ã,  Level
Ã,  Ã,  Ã,  Ã, ------------
Ã,  Ã,  Ã,  Ã, Level1Ã,  Ã,  Ã, ---->Ã,  Level11
Ã,  Ã,  Ã,  Ã, Level2Ã,  Ã,  Ã, ---->Ã,  Level12
Ã,  Ã,  Ã,  Ã, Level3Ã,  Ã,  Ã, ---->Ã,  Level13

So when we click on Level1 it should execute Level11 child report
Ã,  Ã,  Ã, when we click on Level2 it should execute Level12 child report
Ã,  Ã,  Ã, when we click on Level3 it should execute Level13 child report

Please provide any solution for this kind of requirement. Its very urgent.

Thanx
Title: Re: Drillthrough - How to decide the target based on the data
Post by: ratikant on 01 Oct 2005 01:06:44 AM
Hi,
I think, I didn't explain my problem/requirement properly. Below is the details.

There are different channels which will be shown in our parent report. Each channel has different levels of hierarchy. Based on the selected channel, we need to navigate to different hierarchies.
Ex.
   Channel                   Level1      Level2      Level3
   Ch01      L001      L002      L003
   Ch02      L001      L002      Null
   Ch03      L001      Null      L003
   
In this above example Ch01 has all three levels data but not for Ch02 and Ch03. In case of Ch03 Level2 data are not available and for CH02, L003 data not available.
1. So how can we directly show the Level3 data when we drillthrough from Channel Ch03.
2. Can we jump to Level3 directly from Ch03?
3. Based on the the Channel values can we target to different child reports at runtime?

Its urgent. I need your help.
Thanks