OBIEE - “Server Complex Aggregate” rule


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

Powered by ComboStrap