Two-Pass Calc

Because of how Essbase stores the data and the order it is calculated, there is an occasional need for this cool function.

You see, sometimes, a data component in the calculation of one data value has not been calculated at the time the system needs it. This is because some component pieces of data are dependent on other data values being calculated prior to their use in another calculation. Essbase has recognized that the data may need to be calculated once to produce the correct values at one level, and then the component data is calculated again to produce the correct values at another level.

The option to set the Two-Pass attribute is only available on Outline members in the Accounts dimension that are tagged as Dynamic Calc

Get Oracle Essbase 9 Implementation Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.