SET CREATENONMISSINGBLK

Controls whether or not potential blocks are created in memory for calculation purposes and whether or not #MISSING blocks are stored.

Syntax

SET CREATENONMISSINGBLK ON|OFF;

ON Calculations are performed on potential blocks as well as existing blocks. If the result of the calculation is not #MISSING, the block is stored. The Create Blocks on Equations setting is ignored.
OFF Calculations are performed only on existing blocks. This is the default setting.

Description

The SET CREATENONMISSINGBLK command affects the results of calculations on both sparse and dense dimensions.

By default, Analytic Services applies dense-member formulas only to existing data blocks. The SET CREATENONMISSINGBLK ON command enables Analytic Services to create potential blocks in memory where the dense-member formulas are performed. Of these potential blocks, Analytic Services writes to the database only blocks that contain actual values; blocks resulting in only #MISSING values are not written to the database.

The creation of #MISSING blocks resulting from sparse-member formulas is governed by the Create Block on Equations setting. (See SET CREATEBLOCKONEQ.) The SET CREATENONMISSINGBLK ON command ensures that only non-empty blocks are created, regardless of the Create Block on Equations setting.

In order to create new blocks, setting SET CREATENONMISSINGBLK to ON requires Analytic Services to anticipate the blocks that will be created. Working with potential blocks can affect calculation performance. Consider the following situations carefully:

Notes

Example

The following example is based on a variation of the Sample Basic database. Assume that the Scenario dimension, of which Actual is a member, is sparse. "Jan Rolling YTD Est" is a member of the dense time dimension, Year.

FIX (Budget)
  SET MSG DETAIL;
  SET CREATENONMISSINGBLK ON;
  "Jan Rolling YTD Est"= (Jan->Actual+Feb+Mar+Apr+May+Jun+Jul+Aug+Sep+Oct+Nov+Dec);
ENDFIX

See Also

Database Administration Guide
SET CREATEBLOCKONEQ

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com