Dashboard provides the Drill-Down feature, which allows end-users to change the detail level of data displayed in a dashboard item. The Drill-Down feature enables users to drill down to display detail data, or drill up to view more general information.
To learn how end-users can drill down using a particular dashboard item, see the Interactivity section for this item.
Drill-down requires that the data section contains several dimensions...
... or a hierarchy data item (in OLAP mode).
To enable drill-down, click the Drill-Down button in the Data Ribbon tab (or the button if you are using the toolbar menu).
To enable drill-down in code, use the DashboardItemInteractivityOptions.IsDrillDownEnabled property. To access the DashboardItemInteractivityOptions object, use the dashboard item's InteractivityOptions property.
If the selected dashboard item contains several types of elements that can be used for drill-down, the Ribbon or Toolbar will provide the appropriate buttons to switch between these types (e.g., Arguments and Series buttons in a Chart). For details, refer to the documentation for the individual dashboard items in the Designing Dashboard Items topic.
The following dashboard items support the Drill-Down feature.
The DashboardDesigner.GetAvailableDrillDownValues method allows you to obtain values that can be used to perform drill-down.
You can use the DrillActionEventArgs.DrillDownLevel event parameter to determine the current drill-down level.
The DrillActionEventArgs.Values property allows you to obtain values from the current drill-down hierarchy.
In OLAP mode, the DrillActionEventArgs.Values property returns unique names instead of values.