1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. FORCEALLDENSECALCON2PASSACCOUNTS

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. If you set the FORCEALLDENSECALCON2PASSACCOUNTS configuration setting to false, Essbase prevents the second pass for all other than the cells for the member tagged as two-pass.

Syntax

FORCEALLDENSECALCON2PASSACCOUNTS TRUE | FALSE

  • TRUE—When a two-pass member of a dense accounts dimension is calculated, the second calculation pass calculates all dense cells of the data block. This is the default.

  • 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

FORCEALLDENSECALCON2PASSACCOUNTS 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 cube 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