 Remove Data process

The Remove Data process deletes data from all or part of the cube. Typically, this process is used for the deletion of incorrect or unnecessary data and to reduce the size of the database.

  Example:  Removing unnecessary zero values can speed up queries.

Often, the Remove Data process is performed prior to importing data or running an allocation process.

  Caution:   The Remove Data process permanently deletes the specified data in the selected members; the data cannot be restored.

Parameters

This process has the following parameters:

• Description: Optional. Up to 250 characters.

• Connection: Select the connection. (Only available if more than one connection is defined.)

• Cube: Select the cube (depends on your selection in Connection).

• Remove data values from cube: To delete the data belonging to the member combinations you select below.

• Remove zero values only: Select to delete only zero-value data from the member selection.

• Remove cell comments: Select to delete cell comments from the member selection.

• Remove line item details: Select to delete line item schedules from the member selection.

• Member Selection: Define the dimensions and members whose data is to be removed.

  Note:  After running the Remove process, you must run Update Cube.