I am trying to get a drill through work from Analysis Studio to Report Studio. My Report Studio has a filter : [Date] in_range ?DD?.
In congos connection, I went to drill through Definitions and defined the correct target report and defiine the prompt value to the appropriate Date level.
I can run my report studio report and it works fine. But when I go to analysis studio and open the cube and select the year cell and try to drill through to the report, it does not pass the value. Report runs but getting blank report. Anyone has any idea? I checked the view source value from the related link window and it has 20050101-20051231. Parameter mapping: shows DD but nothing in DISPLAY VALUE or USE VALUE. I would appreciate if anyone could help.
guys..for some reason,don't know why it was giving trouble, but it's working perfectly now...thanks...
hi,
Can u please give me the step by step description of drill through from analysis studio to report studio??
I tried creating a report studio report and I couldnt pass the parameter from the analysis studio report to the report studio report.
Hi,
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 hre you will see an option to 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.
Thanks,
Gollapudi.
Hi,
How to do drill through on Quarter from analysis studio to report Studio