The requested page is not available for the requested platform. You are viewing the content for Default platform.

Drill-Down

  • 2 min read

The built-in drill-down capability allows end-users to change the detail level of data displayed in dashboard items on the fly. To learn more, see Drill-Down.

The Grid dashboard item supports drill-down for rows.

When drill-down is enabled, an end-user can click a grid row to view the details.

Anim_Grid_DrillDown

Drill-down requires that the Columns section contains several dimensions at the top, from the least detailed to the most detailed dimension.

Grid_Interactivity_DrillDown_DataItems

If a column sequence starts with several Measure columns followed by Dimension columns, the dimensions participate in drill-down. However, columns that follow the Dimension(s) - Measure(s) combination, do not take part in drill-down.

In the picture above, the columns CategoryName and ProductName can be combined for drill-down, while the SalesPerson column (and subsequent columns) cannot.

Note

In OLAP mode, you can perform drill-down for either a hierarchy data item or several dimension attributes.

To enable drill-down, click the Drill Down button in the Interactivity group on the Data Ribbon tab of the Grid Tools contextual tab set (or the DataShaping_Interactivity_DrillDown_Toolbar button if you are using the toolbar menu).

DataShaping_Interactivity_DrillDown_Ribbon

To return to the previous detail level (drill up), use the DrillDown_DrillUpArrow button within the Grid caption, or the Drill Up command in the context menu.

In code, use the GridDashboardItem.InteractivityOptions property to access interactivity settings. This property returns the DashboardItemInteractivityOptions object.

To enable drill-down, set the DashboardItemInteractivityOptions.IsDrillDownEnabled property to true.

See Also