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, 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.
- 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.
- 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 to see the actions you can perform on hierarchies.
- Click on the filter icon in the rows to filter string-type elements.
- Click on the row headers to see the actions that you can perform on row headers.
- Click on the column headers 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.