2.How do you drill through report from Report Studio to Analysis
studio?
- 3 Answers
- 8199 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
What are the Macros?
in which scenario we go for views in cognos or oracle?
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
What are cognos connection initial page components?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
how u publish the packages in framework manager
4. How many dimensions did you use in your reports?
What is the use of Generated Prompt? Where is it used in realtime project?
What is content Manager?
Teradata 
