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
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
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
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
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
IBM Cognos Training | Sep 30 to Oct 15 | View Details |
IBM Cognos Training | Oct 03 to Oct 18 | View Details |
IBM Cognos Training | Oct 07 to Oct 22 | View Details |
IBM Cognos Training | Oct 10 to Oct 25 | View Details |
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.
1 / 15
Copyright © 2013 - 2023 MindMajix Technologies