OBIEE - "Server Complex Aggregate" rule

1 - About

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.

3 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap