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; or

  • Use Administration Services. See the Oracle Essbase Administration Services Online Help.

Syntax

CLEARDATA mbrName;
Parameter Description

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.

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;

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

See Also