OBIEE - Server Complex Aggregate rule

Bi Server Architecture With Client


This aggregate rule applies the aggregation rule that is determined by the Oracle BI Server (such as the rule that is defined in the Oracle BI repository). The aggregation rule is determined and calculated by the bi server.

Can not be used for calculated items.

This rule changes the report_sum function by the aggregate by function in the logical SQL.

This aggregate rule will also apply the (fraction|average) aggregation ie:

  • a sum for the numerator
  • a sum for the denominator
  • and getting the end result dividing one into the other.

Documentation / Reference

Discover More
Obiee 10g Aggregation Rule
OBIEE - 10G/11G - OBIPS - Aggregation Rule

Aggregation rule. The aggregation rules apply to all aggregate function used in SQL statements : The 'aggregation rule' setting in Answer is applied to sub-totals and grand totals within the Answers...

Share this page:
Follow us:
Task Runner