Drill-through to Detail
- To Drill-through to cube details select
a cell and click the drillthrough icon. The cube must be drillthrough
enabled in order to use this feature.
Analysis Services 2005 and up provides a
way to select specific measures and levels for Drillthrough.
The following dialog will appear when a cell is double-clicked.
- Maximum Drillthrough Rows - provides a way to limit number of rows returned to improve performance.
- Measure Group - provides a way to limit measures
- Measure - Hold Ctrl button to select multiple measures
- Dimension - provides a way to limit levels
- Level - Hold Ctrl button to select multiple levels