Exclude

The Exclude option, followed by a list of excluded objects, restricts the scope of drill-through options so that only the non-excluded level(s) can serve as a starting point for drill-through operations. Use with the DrillThrough option to ensure that report users navigate directly to the relevant portion of the cube before they begin a drill-through operation.

For each or cube or measure for which you want to restrict drill-through by level, you must specify the relevant dimension and levels, and any drill-through targets to which the restriction applies.

You must use MDL if you want to exclude levels in a sub-dimension, because these are not displayed on the Dimension map of the Windows interface.

The syntax is as follows:

Exclude  [Dimension objDim]  [Drill objDrill]  Levels objLevel

where objDim, objLevels, and objDrill can be the unique object identifiers, names, or both.

Example

In this example, the State and Market levels in the Region and Sales dimensions are excluded for the specified cube drill-through operations:

DrillThrough True ... "C:\path_to_cube.mdc" "Description text" Exclude Dimension 
"Region" Exclude Levels 219 "State" Exclude Dimension "Sales" Exclude Levels 
"Market" EndExclude "C:\path_to_cube2.mdc" "Description text2" EndList