Blog

Query Studio – Cognos

Query Studio:
Query Studio is the reporting tool for creating simple queries and reports in IBM Cognos Business Intelligence.
In Query Studio, you can

  • View data

Connect to a data source to view data in a tree hierarchy. Expand the query subjects to see query item details.

  • Create reports

Use the data source to create reports, which you can save and reuse. You can also create a new report by opening an existing report, changing it, and saving it using another name.

  • Change the appearance of reports

Improve the layout of your report. For example, you can create a chart, add a title, specify text and border styles, or reorder columns for easy comparison.

  • Work with data in a report

Use filters, summaries, and calculations to compare and analyze data. Drill up and drill down to view related information.

Learn how to use Cognos, from beginner basics to advanced techniques. Enroll for Free Cognos Training Demo!

To use Query Studio effectively, you should be familiar with your organization’s business and its data. You may also need to be familiar with other components of IBM Cognos Business Intelligence.

  • Designed for end users
  • Use query studio for creating simple ad-hoc reports and self service reports
  • To open the query studio
  • From Cognos home page,
  • Click on query my data
  • Click on Go Sales and Retailers

This tutorial demonstrates how you can create a list report, a pivot, and a template along with conditional formatting in Query Studio.

Create a list report:

  • Click on insert data menu
  • Drag the product line, product type, product name, quantity, revenue and drop on work area/report page
  • Select the product line
  • From change layout menu,
  • Click on group (Group eliminates the duplicates, automatically calculates sub totals, grand total)
  • Ungroup (Restores the duplicates)
  • Collapse Group – To suppress the detail data
  • Expand Group – To restore the detail data
  • Select the product line data item
  • From change layout menu,
  • Click on create sections
  • Page breaks  (By default 20 rows/page)

List Report

Pivot (Crosstab):

  • Create a list report with the following query items
  • Product line
  • Order method
  • Quantity
  • Select the product line
  • Click on group icon
  • Select any item in the report
  • From change layout menu,
  • Click on pivot
  • Swap rows & columns

                                                Frequently Asked Cognos Interview Questions & Answers

Crosstab Report

Conditional Formatting:

  • Create a list report with the following query items
  • Product line
  • Product type
  • Quantity
  • Select Quantity
  • Define conditional styles from change layout
  • New value — à  100000
  • Click on insert — à  50000
  • Click on OK

Template:

Studio has predefined report templates that you select from, when you create a new report.

You can create your own custom report templates and make them available too.

  • Pre defined structure which can be reused/applied for multiple reports
  • Open the report studio,
  • Select report template
  • Click on OK
  • From page explorer,
  • Click on classes
  • From global class extensions
  • Select list column body cell
  • Select font property
  • Apply the properties
  • Select a list column title
  • Apply the properties
  • Click on save
  • Name the template (TCS)

Create a list report in query studio

  • From change layout menu
  • Click on apply template
  • Select the radio button, apply the template
  • Click on select a template
  • Select TCS template
  • Click on OK
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