Clearing all data from an Exploration View or list view

You can clear all data from a specific Exploration View or list view.

About this task

Use the Task Pane to clear all data (including from the rows, columns, and context drop zones), in a specific Exploration View or list view.

Note:

  • Clearing an Exploration View or list view does not break the link to the datasource. When you clear data in an Exploration View or list view, the button to open the MDX editor is temporarily disabled. This feature prevents other users from viewing the worksheet's MDX expression, which may contain information about the datasource.

  • The button to open the MDX editor is enabled again if the Exploration View or list view is refreshed by the user that initially cleared the data. When the view is refreshed, the context dimensions will query for the first available member for each subset and update the selections and the MDX expression is updated.

  • Clearing an Exploration View or list view discards any set element selections.
  • After an Exploration View or list view is cleared, set expressions are reevaluated and the set element selection is defaulted to the first entry upon refresh. Do not clear an Exploration View or list view if the set element selection state is intended to be preserved.
  • Ensure that the first entry is desired as the default set element selection. If not, structure the set in such a way that the first entry is desirable as the default set element selection, for example, the first leaf entry vs the first total.

Procedure

  1. In the Task Pane source tree, expand Current Explorations.
  2. Right-click the Exploration View or list view that you want to clear all data from.
  3. Click Clear Data.