Home  >  Blog  >   IBM Cognos

Report Studio In Cognos

Rating: 5
  
 
4488

A list report shows data in rows and columns. You can apply a filter, summary, or calculation to manipulate the data that appears in the report.

 

Enroll for Instructor Led Live Cognos Online Certification Training

 

Creating List Report

  • From insertable objects pane
  • Expand Product Query subject

  • Double click on the following query items

  • Product line

  • Product type

  • Expand Orders Query subject

  • Double click on the following query items

  • Quantity, Revenue

  • From Run menu–  Click on Run report

 Run report
 Run report_2
 Run report_3
 Run report_4

  • Tools menu — Select generated SQL/MDX

  • QDE – Query Definition Engine

  • The business query is translated into a SQL query by the Cognos server

  • The Cognos server contains a component called QDE (Server component)

  • QDE (Query Definition Engine) translates the business query into SQL Query

[Related Article: Cognos Interview Questions And Answers]

Group:

Groups and roles represent collections of users that perform similar functions or have a similar status in an organization. Members of groups can be users and other groups.

A group can eliminate duplicates within the column and display the data item value at the beginning of the control break

 MindMajix YouTube Channel

Sub Total:

Defining the total for each group is known as a subtotal.

Grand Total:

  • Select the Product line data cell

  • From structure menu

  • Click on Group

  • Select the Quantity and Revenue data cells

  • From Data menu

  • Select Aggregate

  • Click on Total

(Toggle – Group/Ungroup)

[Related Article: Cognos tutorial for beginners ppt ]

Grouping

Grouping
Grouping_2
Grouping_3
Grouping_4

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

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 TrainingSep 30 to Oct 15View Details
IBM Cognos TrainingOct 03 to Oct 18View Details
IBM Cognos TrainingOct 07 to Oct 22View Details
IBM Cognos TrainingOct 10 to Oct 25View Details
Last updated: 27 September 2023
About Author

Ravindra Savaram is a Content 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

Try NOW: One-Access by MindMajix