2.How do you drill through report from Report Studio to Analysis
studio?
Answers were Sorted based on User's Feedback
Answer / krishna
We have option Launch option we have Drill thru defination
there we have to give the link to Analysis studio to Report studio
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kk
we have option like Analysis studito to report studio.
In Analysis studio right click goto Related link one new
window will come .there u have to select Reportstudio Report.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
How to create Events?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
What is stitched Query?
Can you define framework manager?
Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?
difference between stored procedure and function?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
can you apply grouping on crosstab?
Why cognos scenario is used?
plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?
Can you define cognos powerplay?