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.
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.
clears all Budget data.
clears only Budget data for the Colas product family.