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.

CLEARDATA does not clear blocks, even if all data values in a block are #MISSING. Use CLEARBLOCK if you wish to clear blocks from the database, which can improve performance.

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.

Example

CLEARDATA Budget;

clears all Budget data.

 
CLEARDATA Budget->Colas;

clears only Budget data for the Colas product family.