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.
Any valid single member name or member combination, or a function that returns a single member or member combination.
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.
clears all Budget data.
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).