Query Studio – Cognos

 

Cognos Query Studio is the reporting tool for creating simple queries and reports in IBM Cognos Business Intelligence.
In Cognos 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 in Free Cognos Online Course!

To use Cognos 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.

 MindMajix YouTube Channel

Create a list report in - Cognos Query Studio

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

List Report

list reportcognos query studio

Pivot (Crosstab)

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

[Related Article: Cognos Interview Questions and Answers]

  

Crosstab Report

Crosstab Reportcognos query studio 1

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

[Related Article: IBM Cognos Vs Tableau]

Template:

The 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.

  • The pre-defined structure 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)

[Related Article: IBM Cognos Tutorial]

Create a list report 

  • From change layout menu
  • Click on an 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!

Create a list report in - Cognos Query Studio

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
IBM Cognos TrainingNov 12 to Nov 27View Details
IBM Cognos TrainingNov 16 to Dec 01View Details
IBM Cognos TrainingNov 19 to Dec 04View Details
IBM Cognos TrainingNov 23 to Dec 08View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less