Each data-bound dashboard item aggregates underlying data based on the provided dimensions.
Measure/delta values are calculated at the intersection of these dimensions. Thus, dashboard items visualize dimension values and corresponding measure/delta values.
You can access a hierarchical representation of this data using the DashboardViewer API.
The MultiDimensionalData object is used to hold hierarchical data displayed within the dashboard item in a unified way.
The dimension value corresponding to a specific hierarchy level is stored in the AxisPoint class, that defines a point in a multidimensional space.
Such points are placed on a specific data axis represented by the DataAxis class.
For instance, the pivot grid has the "Row" and "Column" axes, the chart has the "Argument" and "Series" axes, etc.
The DashboardDataAxisNames class provides access to names that allow you to identify various types of data axes.
The MultiDimensionalData object allows you to obtain settings of dimensions/measures that provide the displayed data. These settings include data member identifiers, formatting options, data item name, etc.
The MultiDimensionalData.GetSlice method returns the slice of the current MultiDimensionalData object by the specified axis point. For instance, the slice of multidimensional data by the axis point corresponding to "Product 3" allows you to obtain summary values for all date intervals (horizontal shaded area). The slice by the axis point corresponding to "May" contains summary values for all products (vertical shaded area). So, you need to sequentially call this method two times to obtain the slice at the intersection of the "Product 3" and "May" axis points.
The dashboard visualizes aggregated data from the underlying data source.
You can obtain underlying data for particular dashboard item using the DashboardViewer.GetUnderlyingData method. This method's overloads allow you to obtain underlying data related to the specified axis point.
The DashboardViewer also provides the events that allow you to obtain underlying data related to the clicked visual element. For instance, the grid in the image below displays underlying data related to the clicked pivot grid' cell.