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

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

1854


What are the message flows?

704


What junk dimension contains?

728


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6313


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?

4382






what is log in cognos?

816


What DB View and Bus View?

1713


What are the advantages of cognos?

694


how to perform single sign in cognos by using url?

717


Diff b/w Crossproduct and Outerjoin?

1988


Please explain the different stages in creating a report in cognos report net?

722


What is main advantage datawarehousing over oracle?

707


how you create security to reports?

760


Can you define cube?

750


----------------Describe DWH Architecture?

1794