SetDefaultCategory Method

The SetDefaultCategory method specifies a new default category for a dimension, other than the root or parent of a group of scenario categories. There can only be one default category for each dimension.

Syntax

Dimension .SetDefaultCategory

Applies To

Discussion

We recommend that you use this method together with the HideValue property of the root or parent Category object to create a scenario dimension.

By setting a default level for opening the cube, you ensure that cubes containing budget values or other scenario-like data do not display zeros, non-applicable numbers, or meaningless numbers, when opened by report authors or consumers.

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

Return Type

None.

Parameter

Description

Category

Required. In the given dimension, specifies a valid Category object.

Type: Object-Category