Report Studio In Cognos

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

• 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