Removing Data Sets

The Remove Only command works similarly to the Keep Only command except that it removes only selected members of a dimension and keeps all other data in your spreadsheet view.

To remove a set of data:

Select the range of data you want to remove (press Shift to select multiple adjacent set of cells).
Select Essbase, and then Remove Only.

Occasionally, data you want to remove does not lie in a continuous range of cells. In this case, press Ctrl while selecting the cells to remove nonadjacent cells.