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
Name | Dates | |
---|---|---|
IBM Cognos Training | Oct 15 to Oct 30 | View Details |
IBM Cognos Training | Oct 19 to Nov 03 | View Details |
IBM Cognos Training | Oct 22 to Nov 06 | View Details |
IBM Cognos Training | Oct 26 to Nov 10 | View Details |
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.