COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mindbender on 23 May 2007 06:24:36 AM

Title: Diff between Rollup Aggregate function and Aggregate Function
Post by: mindbender on 23 May 2007 06:24:36 AM
What is the difference between Rollup Aggregate function and Aggregate Function in Cognos 8

Can it be illustrated with an example.

Thank in Advance
Title: Re: Diff between Rollup Aggregate function and Aggregate Function
Post by: goose on 23 May 2007 10:46:16 AM
The "Aggregate Function" is used to rollup the values when "Auto Group & Summarize" is set to yes for the query, it applies some logic depending on the datatype. The "Rollup Aggregate Function" is used for summary values like totals in the report etc.