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.