Keep Only, Remove Only & Get Data

Keep Only

The Keep Only feature helps you to retain specific data within view. This action works the opposite of Remove Only.

1. Select a cell containing members from a dimension you want to retain and click Keep Only.
   
2. All other dimension members are removed, and only the data and metadata within the selected intersection are displayed.
   

Remove Only

The Remove Only feature helps you to remove the data and metadata for the selected member(s) from a view. 

1. Select the required cell and click Remove Only.
   
2. The selected cells are removed.

Get Data

This action updates data in the spreadsheet after selections are made.

1. Select any view.
2. Click the Get Data icon to update or refresh the selected view.
   

In Practice: To Display the Hierarchical Order by Updating the dimension members of a view

1. Select any dimension member or view, and click Update Selection.
   
2. The selected dimension member of view is displayed on the sidebar in hierarchical order.
   
   Note:

   In the above instance, we have selected Design Marketing Report as a view.

   
3. Likewise, select any dimension member from the sidebar, and click Apply.
4. The selected dimension member is displayed on the screen.
   
   Note:

   In the below instance, we have selected Net Income as a dimension.
   
   Notes:

   If you want to update dimension members for any other dimension in the view, follow the same steps again.

   1. Select the dimension, and click Update Selection on the sidebar.
   2. Select the member and click Apply.
   3. Select the POV members by clicking the Update Selection option in ESM views.

   Otherwise, you can also update members using the drop-down list for each dimension.