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.
Articles Related
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.