- Expand the schema on the Schema Tree View.
- Expand the Measure Groups folder on the Schema Tree View in the left pane.
- Select the measure group that is to be enabled for drill-through.
- The panel for Measure Groups will open in the Schema Element Properties View in the right pane. Select the Drill Through tab.
- Select the Enabled box to enable Drill-Through.
-
The list of columns to be returned to the BI client is listed. If the list is empty, click the Reset to Default button.
The default result set of a drill-through operation will include one column for each measure in the measure group, as well as one column for the lowest level of the default hierarchy of each dimension associated with the measure group.
At this point, drill-through is unmanaged.