# Essbase - Two-Pass Calculations

### Table of Contents

## 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.