Mindmajix

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

Screenshot_282

Screenshot_283

Screenshot_284

Screenshot_285

  • 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

Screenshot_286

Screenshot_287

Screenshot_288

Screenshot_289

 

 

 

 

 


 

0 Responses on Report Studio"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.