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).