Retaining Data Sets

The Keep Only command retains only selected members of a dimension and removes all other data from your spreadsheet view. This command provides a powerful way to remove dimensional slices without having to delete individual cells.

To retain a set of data:

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

If data you want to retain does not lie in a continuous range of cells, press Ctrl while selecting the cells to keep nonadjacent cells.