Explore your data
The 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.
Note: The format used to display measure
values is defined in the source database.
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.
- 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.
- Click on the row headers to see the actions that you can perform on row headers.
- Click on the column headers that have gray background to see the corresponding actions.
- Click on the data cell that typically displays the values to select from the list of action on data cells.