Clearing Data

Table 85 lists the commands that clear data:

Table 85. List of Commands for Clearing Data

Command

Calculation

CLEARDATA

Change the values of the cells you specify to #MISSING; the data blocks are not removed.

Use the FIX command with the CLEARDATA command to clear a subset of a database.

CLEARBLOCK

Remove the entire contents of a block, including all the dense dimension members.

Essbase removes the entire block, unless CLEARBLOCK is inside a FIX command on members within the block.

CLEARBLOCK UPPER

Remove consolidated level blocks.

CLEARBLOCK NONINPUT

Remove blocks containing derived values. Applies to blocks that are completely created by a calculation operation, not to blocks into which any values were loaded.

CLEARBLOCK DYNAMIC

Remove blocks for Dynamic Calc and Store member combinations.

See Dynamically Calculating Data Values.

CLEARBLOCK EMPTY

Remove empty blocks.

The following calculation script command yields different results depending on whether the Scenario dimension is dense or sparse:

FIX(Actual)
   CLEARBLOCK NONINPUT;
ENDFIX

Sparse: The command removes only the blocks whose Scenario dimension member is Actual.

The following formula clears all the Actual data values for Colas:

CLEARDATA Actual -> Colas;

To clear an entire database, see “Clearing Data” in the Oracle Essbase Administration Services Online Help.