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.
See Also