DrillDowns Collection

The DrillDowns collection contains either DrillDown objects or DateDrillDown objects, but not both.

Discussion

Use this collection to select or remove a DrillDown or DateDrillDown object.

Transformer automatically adds one DrillDown or DateDrillDown object to each DrillDowns collection when the parent dimension is created. This object represents the primary drill-down path and you cannot remove it. Any other DrillDown or DateDrillDown object in the collection represents an alternate drill-down path.

Use the CreateAlternateDrillDown method of the Level object to add DrillDown or DateDrillDown objects to the collection.

To return this collection, use the DrillDowns property.

Method	Description
Item Method	Selects a specific DrillDown or DateDrillDown object in the collection.
Remove Method	Removes a specific DrillDown or DateDrillDown object from the collection. Not applicable to the first object in the collection. If applied to the first object, an exception is thrown.

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

Examples

objDrill = objModel.Dimensions("Retailers").DrillDowns(2)