Business Analytics Business Intelligence Cognos Report Studio

Result set changes when Auto Group and Summarize Property

summarize
Jason Clements
Written by Jason Clements

Set the Auto Group & Summarize Property

Set the Auto Group & Summarize query property to specify whether IBM Cognos Report Studio should group non-fact data items (identifiers and attributes) and apply aggregate functions to aggregate fact data items in lists.

If you are using an OLAP data source, data is always summarized regardless of how this property is set. Unless to change the global setting. See more on that here. Or contact BlueNet to help you change this settings.

Auto Group & Summarize looks at the level of detail in your query (ie: the nominated data items) and then groups the records by the qualitative values and summarized the quantitative values to the level of detail defined by your qualitative values.

Procedure

  1. Pause the pointer over the query explorer button queries explorer icon and click a query.
  2. In the Properties pane, set the Auto Group & Summarize property:
    • To group non-aggregate fact data items and apply aggregate functions to aggregate fact data items in lists, set this property to Yes.
    • To render detail rows, set this property to No.unnamed

For example:

If Auto group and Summarize= NO, the report or query output would be something like this:

Auto group and Summarize= YES, the report or query output would be something like this:

About the author

Jason Clements

Jason Clements

Who is Jason Clements? Good question. He is a husband, father, BI consultant, and database administrator, He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. Jason is employed with BlueNET Technologies as Senior Business Analytics Consultant.

As an active member of the community, Jason has spoken at regional and local venues including the vendor based trade shows and various user groups & webcasts. He is an active group member and speaker at the North Georgia SQL Server User Group in the ATL area.

Leave a Comment