CLEARDATA

Clears data values from the database and sets them to #MISSING.

This command is useful when you need to clear existing data values before loading new values into a database. CLEARDATA can only clear a section of a database. It cannot clear the entire database. To clear the entire database, use the following MaxL statement:

alter database <dbs-name> reset;

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 does not work if placed in an IF statement.
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.

Example

CLEARDATA Budget;

Clears all Budget data.

 
CLEARDATA Budget->Colas;

Clears only Budget data for the Colas product family.


FIX("Actual")
  CLEARDATA "200-10";
ENDFIX;

Caution:

Clears data from the 200-10 block, but does not remove the block, as this is not a whole-block fix (a dense dimension is selected in the FIX).