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 | Apr 01 to Apr 16 | |
IBM Cognos Training | Apr 04 to Apr 19 | |
IBM Cognos Training | Apr 08 to Apr 23 | |
IBM Cognos Training | Apr 11 to Apr 26 |
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