IsPrimary Property

The IsPrimary property sets or returns whether an object is the primary drill category.

Syntax

object .IsPrimary

Applies To

DateDrillDown Object

DrillDown Object

Category Object

Discussion

This property is True for the first drill-down path in a DrillDowns collection and False for any other. False indicates an alternate drill-down path. Alternate drill-down paths are created by using the CreateAlternateDrillDown method.

For example, two paths are available in the Channels dimension: the primary path is by Channel Type and the alternate path is by Region. If your drill-down path is the primary path, you drill from Channel Type to Customer. If your drill-down path is the alternate path, you drill from Region to Customer.

The IsPrimary property cannot be changed for a Category object. For a DateDrillDown and DrillDown object, it can be changed from False to True, but not True to False. When you set a drill-down path to True, it switches from an alternate drill-down path to a primary drill-down path, and the previous primary drill-down path becomes an alternate drill-down path.

In Transformer, allocations and partitioning are based on the primary drill-down path. In PowerPlay®, category rollup values summarize to the top level of the primary drill-down path.

A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.

Type

Boolean

Access

Read (Category)

Read/Write (DateDrillDown and DrillDown)

Examples

objLocationsDim = objModel.Dimensions("Sales regions")
objLevel = objLocationsDim.DrillDowns(1).Levels("Employee")objAltDrill
= objLevel.CreateAlternateDrillDownobjAltDrill.IsPrimary = True