2.How do you drill through report from Report Studio to Analysis
studio?

Answer Posted / adnan

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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

1874


What is a Framework manager?

561


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2148


write a query to display the departments with no employee?

1549


Explain the characteristics of cognos?

607






How do we convert from Numeric to be Words?

2504


What is cognos connection?

587


What is the difference between drill through, drill across?

573


What are products of cognos?

556


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2797


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

1564


What is the difference between regular dimension and derminant?

1685


Explain the difference between powerplay transformer and power play reports?

596


What are the types of catalogs in cognos?

675


Explain what is the difference between microstrategy and cognos reporting tool?

541