Home  >  Blog  >   IBM Cognos

Query Studio – Cognos

Rating: 5
  
 
6836

 

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 report
cognos 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 Report
cognos 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

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingMar 30 to Apr 14View Details
IBM Cognos TrainingApr 02 to Apr 17View Details
IBM Cognos TrainingApr 06 to Apr 21View Details
IBM Cognos TrainingApr 09 to Apr 24View 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 more
Recommended Courses

1 / 15