COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Vick on 03 Mar 2009 01:54:09 PM

Title: Drill thru
Post by: Vick on 03 Mar 2009 01:54:09 PM
Hello,
        Does anybody know how can I setup a drill thru from my Analysist Studio to Reportstudio. I am using version 8.3


Thanks in advance.

Vick
Title: Re: Drill thru
Post by: kathirsivan on 04 Mar 2009 04:02:56 AM
create drill through definitions in the cognos connection you can drill analaysis studio report to report studio..
Title: Re: Drill thru
Post by: Gollapudi on 04 Mar 2009 05:35:08 AM
Hi,

What kathirsivan said is correct, I just want to give some breif idea about Drillthrough definition.

1. You will have to define a Drillthrough definition in your cognos connection to use it any any [RS, QS, AS] of the studio's.
2. To create a Drillthrough Definition you should have a Target report first.
3. Then you will come to Cognos Connection and click on Drill through definition and Select a package
4. Then Click on "New Drillthrough Definition" icon and specify a unique name for that.
5. Then say next and Set the Scope of you definition
[Note: Scope is to restrict the link up to a perticular level like Package, Query Subject or Data Item]
6. Then Link the target report and pass the parameter values.
7. Finish it and go to your Analysis Studio and click on a perticular column for which you set the drillthrough definition
8. Then if you see in "Go to" Links you will see your target report
9. As soon as you click on that link, the target report will run and give you the output just like your Report Studio Drillthrough.

Hope I didnt confuse you.

Thanks,
Gollapudi.
Title: Re: Drill thru
Post by: Vick on 04 Mar 2009 10:13:44 AM
Thank you very much for such precise and detailed response. Appreciate it.

Thanks,
Vick.
Title: Re: Drill thru
Post by: Gollapudi on 04 Mar 2009 11:44:24 AM
Your most Welcome Vick, its my job... coz I expect the same from others...