Scenario Usage of Cognos Properties

[koolbachi]

Hi,

1. Could you please clarify when we use the combination of properties like  Aggregated Function and Rollup Aggregation Function.
2. When the Combination of Total and Calculation /Aotumatic is used.

Basically it is used in Crosstab.


Thanks in Advance!!

Regards

[Arsenal]

basically, aggregate in FM/RS is used to determine how the source values from DB are rolled up within the report to show the detail rows in the report. Rollup aggregate is used to  display the summaries of these detail rows. Rollup aggregate is a report function, typically.

total is used when you want the grand total of the measure(s) that resides on the DB. You would use a calculated expression when for example, you have some filters on the report and you want the total of only those measures that meet the filter criteria and so are displayed in the report. Something like (total(Measure) for report)