Report Studio

Creating List Report:

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.

• From insertable objects pane
• Expand Product Query subject
• Double click on following query items
• Product line
• Product type
• Expand Orders Query subject
• Double click on 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 cognos server
• The cognos server contains a component called QDE (Server component)
• QDE (Query Definition Engine) translates the business query into SQL Query

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 sub total.

Grand Total:

Overall summary for all groups is known as grand total/footer summary

• 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)

GROUPING

 

 

 

 

 

---