Lesson: Retaining a Data Subset

The Keep Only command retains only selected member rows or columns and removes all other data from the worksheet view.

  To keep only Actual and Budget data in the current worksheet:

  1. In cell C2, select Actual, and in cell C3, select Budget:

    Selecting members for the Keep Only command.

  2. Select Essbase, and then Keep Only.

    Essbase removes the Variance, Variance%, and Scenario rows from the worksheet and retains only Actual and Budget data:

    Result of retaining a data subset (adjacent cells).

  To select and retain nonadjacent cells:

  1. Press Alt, and, in cell D1, zoom in (double-click) on Year.

  2. Select Qtr2 in cell E2.

  3. Press Ctrl and select Qtr4 in cell G2:

    Selecting nonadjacent members for the Keep Only command.

  4. Select Essbase, and then Keep Only.

    Essbase retains only Qtr2 and Qtr4 data and deletes the other Year members:

    Result of retaining a data subset (nonadjacent cells).

User Reference

Retaining Data Sets