Apex Property

The Apex property sets or returns the Category object that is the root for a dimension view.

Syntax

View .Apex

Applies To

View Object

Discussion

Use this property to limit the categories a user can view in PowerPlay® to just the subset they need.

You can create a dimension view and apply the Apex property to a specified category. After you create a cube, it contains only the apex category and the immediate descendants. The ancestors, siblings, and descendants of these siblings are all omitted from the view.

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

Type

Object

Access

Read/Write

Examples

objProductsDim = objModel.Dimensions.Item("Products")objViewItem.Apex
= objProductsDim.Drilldowns(1).Categories(1)