IBM Cognos Query Studio | Report Tutorial

IBM Cognos Query Studio | Tutorial

Query Studio

Query Studio is the reporting tool for creating simple queries and reports.In Query Studio, we can

• view the data
• create reports
• change the appearance of reports
• work with data in a report

Creating a Report

• When a report is created in query studio, Query definition is created which is used to extract data
• Package should be available in framework manager and the same should be published to Cognos connection for creating reports.
• There is need of the Create capability to create reports and the Advanced capability to use advanced authoring features, such as creating complex filters.

Creating a report involves the following tasks:

• Create the report
• Add data to the report
• Save the report
• Run the report

How to Create a Report ?

• Report can be created from scratch i.e., by inserting the items from the data source.
• Creation of new report can be done by opening an existing report, and editing it and saving it using a different name.
• Report layout can be changed and also can with the data that appears in the report.

Steps to create a report

• Select the package
• click the Query Studio link from the Launch menu.

Steps to open an Existing Report

• Locate and click the report that needs to be opened in cognos connection.
• The report gets opened in query studio.

Add data to report

A new report contains no data.

• Package contains
• Query subjects
• Query items
• Dimensions
• Dimensions can be relational or hierarchical.
• Report items are the items which are added to the report from the package.
• Report items appear as columns in list reports.
• Report items appear as rows and columns in crosstab reports.
• Report items appear as data markers and axis labels in charts.

Steps:

• Open a report in Query Studio.
• Click the Insert Data.
• Double-click the items you want to add in the left pane

Save the report

• To preserve any changes save the report.
• Query definition is saved, which is a specific set of instructions for extracting particular data.

Steps:

• On toolbar click save
• Specify the location to save the report and give a file name.
• Type the information you want to add in the Description box.
• Click OK.

Run a Report

• Run the report to view the recent data
• A Query Studio report runs when opened, or any changes made.
• The report can be viewed in different options:
  • Run with All Data
  • Preview Reports with No Data
  • Preview Reports with Limited Data
  • View a Report in PDF Format
  • View a Report in CSV Format
  • View a Report in XML Format