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
Subscribe to our youtube channel to get new updates..!
-
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