The CLEARDATA command clears data values from the database and sets them to #MISSING.
CLEARDATA mbrName;
| mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
The CLEARDATA command clears a well-defined section of a
database's cells and changes the values of those cells to
#MISSING values. 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, select Database > Clear Data > ALL from the Application Manager main menu.
CLEARDATA Budget;
clears all Budget data.
CLEARDATA Budget->Colas;
clears only Budget data for the Colas product family.
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.
