Print Page - Aggregate Properties

Title: Aggregate Properties
Post by: barrysaab on 12 Jun 2011 12:15:51 PM

Could some please explain when and in what scenerios aggregate and rollup aggregate functions like calculated,total ,average should be used.It is bit confusing.Thanks

Title: Re: Aggregate Properties
Post by: CognosProfessional on 13 Jun 2011 09:02:35 PM

Aggregate: Specifies the type of aggregation to apply. The Automatic setting means that the application groups or aggregates based on the data type. The Aggregate setting means that any setting found in the model will be used to determine the type of aggregation.

Rollup Aggregate: Specifies the type of aggregation to apply to summarized values. These values appear at the higher levels of lists and crosstabs

Notice from the above definitions, the rollup aggregate would only apply to summaries. That is the major difference. You would aggregate in a list report for example. You would rollup aggregate in a crosstab or cube type report.
:D

Title: Re: Aggregate Properties
Post by: bvk.cognoise on 14 Jun 2011 12:18:25 AM

Hi,
you can find additional information in the following link

http://www.cognoise.com/community/index.php?topic=10208.0

thanks
bvk

Title: Re: Aggregate Properties
Post by: barrysaab on 14 Jun 2011 08:08:04 AM

Thanks,BVK.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 12 Jun 2011 12:15:51 PM