Understanding Two-Pass Calculations on Attribute Dimensions

The following example, based on the Product dimension in the Sample.Basic database, illustrates how two-pass calculations work on attribute dimensions. Assume member “400–30” is tagged as two-pass.

If member “400-30” has the following member formula:

=”400–10”;

Essbase executes the formula when performing a retrieve on “400-30.”

If “400-30” has the following member formula:

=@CURRMBR("Market");

Essbase skips the calculation because the formula includes the @CURRMBR runtime function, which is not allowed, and issues the following error message:

Two-pass calc skipped on member [400-30] in attribute calc”

If “400-30” does not have a member formula, the same error message is generated because a member tagged as two-pass must have a formula.