Aggregate Properties

[barrysaab]

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

[CognosProfessional]

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

[bvk.cognoise]

Hi,
you can find additional information in the following link

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


thanks
bvk

[barrysaab]

Thanks,BVK.