Cube calculation

The cube is aggregated. Aggregations can be predefined using aggregate views.

Members in the outline are consolidated/rolled up.

Batch calculations can be run; these are scripts written with Essbase calculation commands and functions

Hybrid mode is encouraged.

Formulas

Formulas are defined using MDX operators and functions. Note the following restrictions:

• Must be valid numeric value expressions written in MDX. Cannot contain the % operator—replace with expression: (value1 / value2) * 100.

• No support for Essbase calculation functions.

• On dynamic hierarchy members, formulas are allowed without further restrictions.

Formulas are defined using Essbase calculation functions.

Calculation scripts

Aggregation scripts define a selection of aggregate views to be materialized.

You can write Custom ASO calculations, if the cube needs calculation scripts to handle special calculations and data dependencies.

Stored/procedural calculation scripts are defined using Essbase calculator syntax.

Attribute calculations dimension

Attribute member combinations can be summed.

Attribute member combinations can be calculated using Sum, Count, Min, Max, or Average.

Calculation order

Member formula calculation order can be defined by using the solve order member property.

The calculation order is defined by the order of dimensions in the outline, or in a calculation script.

In hybrid mode, the order can be customized using the solve order member property.

Dynamic calculation

All parent members and members with formulas are dynamically calculated. There is no explicit Dynamic Calc setting for standard dimensions.

You can apply the Dynamic Calc property for select members in the cube, to improve performance of batch calculations.