Blog

Drill Through Report in Cognos Studio

Drill Through Report

  • It is a process of navigating from one report to another report or navigating from summary to detail.
  • To perform drill through, at least two reports are required

Ex: Master/Child reports

  • Master report contains Summary data
  • Child report contains Detail data

Master Report:

  • Create a list report with the following items,

Country, Quantity and save the report Parent Report, Child Report:

  • Create a list report with
  • Country
  • Staff name
  • Order method
  • Quantity
  • Revenue
  • Group on country, staff name
  • Total on Quantity, revenue
Learn how to use Cognos, from beginner basics to advanced techniques. Enroll for Free Cognos Training Demo!

Create A Prompt On Country

  • From data menu– à Filter — à Add
  • Define the following expression
  • Double click on country=?COUNTRY?
  • Click on validate — à OK — à  ok
  • Save as CHILD REPORT
  • OPEN MASTER REPORT
  • Select country data item
  • From properties pane
  • Select drill through definition
  • Click on eclipse
  • Click on Add ( New Drill Through Definition )
  • Target report ( Name of the report)
  • Right side Report, click on eclipse
  • Select Child Report
  • Open
  • Click on edit button

  • From Method – Select ‘ Pass data item value’
  • From value – Select ‘Country’(Data item)
  • Click on OK — à  Click on OK
  • Save & Run the report

Create A List Report With The Following Query Items

  • Staff name
  • City
  • Fax
  • E-mail
  • Address
  • Create a prompt on staff name
  • Data menu– à  filter
  • — à Add Staff name — à  = ? Staff name ?
  • Save the report as CHILD1 REPORT
  • OPEN THE CHILD REPORT
  • Select staff name data item
  • Right click on staff name data item ( Not on column name )
  • Click on Drill Through Definitions
  • Add– à  From Report
  • Select CHILD1 REPORT — à  Open
  • Click on edit button

  • Method – Pass Data Item value
  • Value – Staff name
  • Click on OK — à  Click on OK
  • Save & Run the report

Drill Through Report:

Master Report

Child Report

Create A List Report With The following Query Items

Drill Through Bookmark

  • Navigating from one section to another section within the same report can be performed through bookmark

Procedure:

  • Create a blank report
  • From toolbox
  • Drag bookmark into the report page
  • Select bookmark property   Label
  • Source – Text   Label– à Click on Eclipse       Index– à Type
  • Click on OK
  • From the toolbox
  • Drag list on the report page
  • Insert country
  • From the menu bar
  • Click on report pages
  • Drag page and drop in report page
  • Double click on Page2
  • From the tool box
  • Drag the list on the report page
  • Insert the following query items
  • Country
  • Product name
  • Revenue
  • Group on Country
  • Total on Revenue
  • Select Country      ( Country column name)
  • From menu bar
  • Select structure tab
  • Click on set page break
  • Again from menu bar
  • Select structure tab
  • Click on section tab
  • From the menu bar, click on unlock symbol
  • From the tool box
  • Drag book mark beside country section
  • Select bookmark properties
  • Source type – Data item value
  • Data item value – Country
  • From menu bar
  • Select structure tab
  • ( Select the properties – Page body ) i.e. Cursor outside the report
  • Select Headers and Footers
  • Click on page header & footer
  • Select Footer
  • Click on OK
  • From the tool box
  • Drag text item and drop inside the footer
  • Type main page
  • And click on OK
  • Right click on MAINPAGE text item
  • Click on Drill Through Definition ( Properties Text Item )

Frequently Asked Cognos Interview Questions & Answers

  • Click on  symbol
  • Click on bookmark tab
  • From the source type list box
  • Select text
  • Select text eclipse
  • In text label
  • Type INDEX
  • Click on OK
  • Click on OK
  • Go to menu bar
  • Select view tab
  • Select report pages
  • Double click on page1
  • Lock the page object
  • Right click on Country List Column Body
  • Click on Drill Through Definition
  • Click on New
  • Select Bookmark Tab
  • Select source type – Data Item Value
  • Data item value – Country
  • Save the report
  • Run the report ( in PDF )

Drill Through Bookmark Report

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

RELATED COURSES

Get Updates on Tech posts, Interview & Certification questions and training schedules