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.