Clearing Blocks of Data From Block Storage Applications

To clear blocks of data from a block storage application:

1. In System View, click .
2. In Enterprise View in the Database Properties tab, expand a block storage application.
3. Right-click a BSO cube, then select Clear, and then select an option:

   • All Data—Clears all data from the database.

   • Upper level blocks—Clears only upper-level data blocks. The data values for upper-level blocks are set to #Missing. Upper-level blocks are created for sparse member combinations of which at least one sparse member is a parent member.

   • Non-input blocks—Clears only data blocks that contain values that are derived from calculations (non-input blocks). When you clear non-input blocks, data values for non-input (calculated) cells are set to #Missing.

   • Dynamic blocks—Clears only data blocks that are dynamically calculated and stored (Dynamic Calc and Store members).

   • Empty blocks—Clears only empty blocks of data (blocks where all of the values are #Missing).

Note:

You can only clear data from databases for which you have permissions.