Enables you to define what level of data is the next level displayed when you drill down in an OLAPQuery. Available drill-down options include:
Drill to Next Level— Automatically displays data for the next level below the selected member. For example, in a dimension with levels of Year, Quarter, Month, and Date, double-clicking on a Year level member name automatically displays all the data for the Quarter level belonging to that year.
Drill to All Levels— Automatically displays all possible levels of data below the selected member. For example, in a dimension with levels of Year, Quarter, Month, and Date, double-clicking on a Year level member name automatically displays all the data for the Quarter, Month, and Date levels belonging to that year.
Drill to Lowest Level— Automatically displays data for only the lowest level belonging to the selected member (intermediate member levels are not shown). For example, in a dimension with levels of Year, Quarter, Month, and Date, double-clicking on a Year level member name automatically displays all the data for the Date level belonging to that year.
Read-write, BqDrillDownDisplay
The BqDrillDownDisplay constant group consists of these values:
This example writes the names of all the topics and topic items to the Console window:
ActiveDocument.Sections["OLAPQuery"].DrillDownDisplay = bqDrillDownDisplayAllLevels