Essbase FORCEALLDENSECALCON2PASSACCOUNTS

Normally, a two-pass tagged member of a dense accounts dimension triggers
a second calculation pass on all dense cells of the data block. The false
parameter value for this setting blocks the second pass for all other than
the cells for the member tagged as two-pass.

Syntax

FORCEALLDENSECALCON2PASSACCOUNTS TRUE¦FALSE
  • TRUE—(Default value) When a two-pass member of a dense
    accounts dimension is calculated, the second calculation pass calculates all
    dense cells of the data block.
  • FALSE—In the same situation, the FALSE setting blocks
    the second calculation pass for all dense cells except those affiliated with
    the two-pass member.

Description

This setting addresses the situation where a two-pass member of a dense
accounts dimension links through @XREF to a two-pass member of a dense accounts
dimension in another database outline, and that two-pass member links back
to the original outline. The additional calculations in the second calculation
pass can result in an infinite loop. The FALSE parameter value blocks the
additional calculations. If you are very cautious about data correctness,
check calculation results.

Example

FORCEALLDENSECALCON2PASSACCOUNTS FALSE