Explore your data

The Explore Your Data widget provides data browsing, data exploration, and advanced data analysis capabilities for ad-hoc analysis.

You can drag and drop hierarchies between filters, and rows and columns axes to enable Slice and Dice functionality to examine different viewpoints of your data.

The Explore Your Data widget consists of these sections:

• Ad-hoc analysis toolbar: The Ad-hoc analysis toolbar is located below the analysis title.

  See Ad-hoc analysis toolbar.

• Filters: Below the Ad-hoc analysis toolbar, expand the filter menu to select hierarchies with their selected elements. For example: Product: All Tires, Region: All Regions.

  See Actions on filters.

• Data Table: The data table represents the main area of your ad-hoc analysis. The table shows data values for the selected columns, rows, and filters. Elements from the vertical and horizontal hierarchies form the row and column headers.

  You can perform these actions on rows, columns, and cells:

  • Click on the hierarchies that are highlighted in blue to see the actions on hierarchies.

    See Actions on axis hierarchies.

  • Click on the row headers to see the actions that you can perform on row headers.

    See Actions on row headers.

  • Click on the column headers that have gray background to see the corresponding actions.

    See Actions on column headers.

  • Click on the data cell that typically displays the values to select from the list of action on data cells.

    See Actions on data cells.