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
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What are the message flows?
What junk dimension contains?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
what is log in cognos?
What DB View and Bus View?
What are the advantages of cognos?
how to perform single sign in cognos by using url?
Diff b/w Crossproduct and Outerjoin?
Please explain the different stages in creating a report in cognos report net?
What is main advantage datawarehousing over oracle?
how you create security to reports?
Can you define cube?
----------------Describe DWH Architecture?