DrillThroughTargets Collection

The DrillThroughTargets collection groups related DrillThroughTarget objects.

Discussion

Use this collection to add, select or remove a DrillThroughTarget object.

In previous releases, the documentation stated that the DrillThroughTarget object represents a drill-through object, such as an Impromptu report (.imr), Impromptu query definition file (.iqd), PowerPlay® report (.ppr), PowerCube (.mdc), or macro script file (.mac). However, for certain operations, such as retrieving counts or other information about drill-through target objects, you must use MDL scripting.

To return the DrillThroughTargets collection for a Measure, Cube, or CubeGroup object, use the DrillThroughTargets property. When you add a DrillThroughTarget object to the DrillThroughTargets collection of a Measure, you restrict the drill-through functionality to that measure alone. When you add a DrillThroughTarget object to the DrillThroughTargets collection of a Cube or CubeGroup object, the drill-through functionality is available at any point in the cube or child cubes.

For models that use Impromptu query definition files (.iqd) as the data source, Transformer automatically adds the corresponding Impromptu report (.imr) to the DrillThroughTargets collection for each measure.

You must set the AllowDrillThrough property to True before drill-through capability is available.

Method	Description
Add Method (DrillThroughTargets)	Adds a DrillThroughTarget object to the collection.
Item Method	Selects a specific DrillThroughTarget object in the collection.
Remove Method	Removes a specific DrillThroughTarget object from the collection.

Property	Description
Application Property	Returns the Transformer Application object.
Count Property	Returns the number of Report objects in the collection.
Parent Property	Returns the parent object.

Examples

objReport = objMeasure.DrillThroughTargets.Add(strReportPath,
"Default Report")