Mindmajix

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

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

Screenshot_858

  • 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

Screenshot_859

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

DRILL THROUGH REPORT:

MASTER REPORT

drill through report

CHILD REPORT

Screenshot_861

Screenshot_862

Screenshot_863

Screenshot_864

Screenshot_865

Screenshot_866

Screenshot_867

Screenshot_868

Screenshot_869

Screenshot_870

Screenshot_871

CREATE A LIST REPORT WITH THE FOLLOWING QUERY ITEMS

Screenshot_872

Screenshot_873

Screenshot_874

Screenshot_875

Screenshot_876

Screenshot_877

Screenshot_878

Screenshot_879

Screenshot_880

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

       <  Screenshot_881Country Screenshot_882>                Bookmark

  • 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 )

Screenshot_883

 

 

  • 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 THROUH BOOKMARK REPORT

Screenshot_884

Screenshot_885

Screenshot_886

Screenshot_887

Screenshot_888

Screenshot_889

Screenshot_890

Screenshot_891

Screenshot_892

Screenshot_893

Screenshot_894

Screenshot_895

Screenshot_896

Screenshot_897

Screenshot_898

Screenshot_899

Screenshot_900

Screenshot_901

Screenshot_902

Screenshot_903

Screenshot_904

Screenshot_905

Screenshot_906

Screenshot_907

Screenshot_908

Screenshot_909

Screenshot_910

Screenshot_911

Screenshot_912

Screenshot_913

Screenshot_914

Screenshot_915


 

0 Responses on Drill Through Report in Cognos Studio"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.