GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Cognos
Go To First  |  Previous Question  |  Next Question 
 Cognos  |  Question 170 of 180    Print  
Drill through
By using one Drill through can we explore the four reports at a time ?


  
Total Answers and Comments: 3 Last Update: July 17, 2009     Asked by: dontisuresh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 13, 2008 01:12:04   #1  
ajayyenduri Member Since: August 2008   Contribution: 1    

RE: Drill through
We can create multiple drill throughs. in runtime if click the column it is asking for whick report you want to navigate.
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
September 02, 2008 05:19:08   #2  
angel987 Member Since: June 2008   Contribution: 16    

RE: Drill through
Its possible for eg: you click on any list column body and click on drill through.
Over there you can add multiple new drill throughs and each drill through can open a new report. So when you run this report and click on the query item on which we are drilling through it opens a page asking you to select drill through 1 drill through 2 etc.. so this way you can access multiple reports.

 
Is this answer useful? Yes | No
July 17, 2009 04:11:02   #3  
bvsr007 Member Since: July 2009   Contribution: 2    

RE: Drill through
1) Create Drill through report to link two reports contain related information
2) You can access related and more detailed information in one report by using to select a value in another report.

Steps:
Create child report:

Open the list report add data items to the list report and then create filter values like prompts. Save the report.

Create master report: open new list report add the data items to the list report. Add the filter values like act as parameters. Right click the column that would be act as drill through column click the new button.

1) Report—click the ellipse point and select child report.
2) Actions—click the run the report/view most recent report/ edit the report.
3) Format—select the format type like html PDF CSV excel.
4) If you want open a child report in new window—OPEN IN NEW WINDOW.
5) Parameters—click edit button
a. If the item parameters under method pass Parameter item value and select parameter for a value.
b. For the item parameter under method pass data item value and Select parameter for a value.

6) Run & save the report.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape