Aggregate Function

Chaitanya

Hi ,

will the Presentation Server Aggregate functions over write BI Server Aggregate Functions? Can anybody please explain.

ex: If we apply aggregation on a measure column in RPD, At answers level, can we apply another aggregation on the same measure?

Help is appreciated.

Regards,

Chaitanya.P

FTisiot

Hi,

When you define a measure on the RPD you NEED to set an aggregation level. this usually can't be overwritten.

However e.g. if in your criteria tab you have year and month and a metric Qty aggregated by default as SUM. If you then apply a MAX function as aggregation in criteria tab then the result value for year will be the maximum of the months sum value or in formula

MAX(SUM(Qty by Month) by Year)

the default aggregation set in the RPD will work until the aggregation level shown in the criteria tab, the reaggregation visible in your analysis is then calculated with the custom formula you set in criteria.