Lesson: Removing a Data Set

Remove Only enables you to remove selected member rows or columns and retain all other data in the worksheet view.

  To remove a data set from the current worksheet view:

  1. In cell B7, select Ratios.

  2. Press Ctrl, and, in cell B9, select Measures.

  3. Select Essbase, and then Remove Only.

    Essbase removes data for Ratios and Measures but retains data for Profit and Inventory:

    Result of removing a data set.

User Reference

Removing Data Sets