CLEARDATA

The CLEARDATA calculation command clears data values from slices of the Essbase cube, setting the cleared values to #MISSING.

This command is useful when you need to clear existing data values before loading new values into a block storage database.

Syntax

CLEARDATA mbrName;

Parameters

mbrName: Any valid single member name or member combination, or a function that returns a single member or member combination.

Notes

CLEARDATA can only clear a section of a database. It cannot clear the entire database. To clear the entire database, use the alter database MaxL statement with the reset keyword.
CLEARDATA does not work if placed in an IF statement.
Generally, use CLEARBLOCK instead of CLEARDATA if you wish to remove blocks from the database, which can improve performance.
To use this command with parallel calculation, use FIXPARALLEL...ENDFIXPARALLEL instead of SET CALCPARALLEL.
Using CLEARDATA in a FIX statement on a sparse dimension clears the data and removes the blocks, to improve performance. Blocks are cleared only if the entire CLEARDATA block is selected by the FIX (no dense dimensions in the FIX), and the block is update-able (it is not a replicated-partition target region). If you wish to retain empty blocks, then in the FIX statement, set the blocks to #MISSING, instead of using CLEARDATA.

For example, the following command block clears New York data and removes the block (because Market is sparse):
```
FIX("East")
    CLEARDATA "New York";
ENDFIX
```
The following command block sets New York data values to #MISSING without removing the blocks:
```
FIX("East")
    "New York" = #Missing;
ENDFIX
```

Example

CLEARDATA Budget;

Clears all Budget data.

 
CLEARDATA Budget->Colas;

Clears only Budget data for the Colas product family.