Essbase - Two-Pass Calculations

About

This label indicates that some member Essbase - Formulas must be calculated twice to produce the desired value.

The two-pass property works only :

  • on members of the dimension tagged as account
  • and on members tagged as Dynamic Calc and Dynamic Calc and Store.

Example

The following example illustrates why Profit % (based on the formula Profit % Sales) has a two-pass tag.

_

The tables have five columns (column headers are labeled left to right as Dimension, Jan, Feb, Mar, and Qtr1) and three rows (labeled as Profit, Sales, and Profit %). Jan, Feb, Mar, and Qtr1 are members of the Year dimension. Profit, Sales, and Profit % are members of the Measures (accounts) dimension.

Data Loaded into Essbase defines the initial data to load into Essbase.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100
Sales 1000 1000 1000
Profit %

First, Essbase calculates the Measures dimension.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100
Sales 1000 1000 1000
Profit % 10% 10% 10%

Next, Essbase calculates the Year dimension. The data rolls up across the dimension.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100 300
Sales 1000 1000 1000 3000
Profit % 10% 10% 10% 30%

The data values for Profit → Qtr1 (300) and Sales → Qtr1 (3000) are correct but the data value for Profit % → Qtr1 (30%) is incorrect because Profit % is tagged as a two-pass calculation.

Essbase then recalculates profit percentage at each occurrence of the member Profit %.

Dimension Jan Feb Mar Qtr1
Profit 100 100 100 300
Sales 1000 1000 1000 3000
Profit % 10% 10% 10% 10%

The data value for Profit % → Qtr1 (10%) is correct after the second pass.


Powered by ComboStrap