Export (0) Print
Expand All

Define Cube Hierarchy Properties

Cube hierarchy properties enable you to specify unique settings for user-defined hierarchies in cube dimensions based on the same database dimension. The following table describes the properties of a cube hierarchy.

Property

Description

Enabled

Determines whether the hierarchy is enabled for the cube dimension.

HierarchyID

Contains the unique identifier (ID) of the hierarchy.

OptimizedState

Determines the level of optimization that is applied to the hierarchy. This property can have the following values:

Value

Description

FullyOptimized

The instance builds indexes for the hierarchy to improve query performance. This is the default value.

NotOptimized

The instance does not build additional indexes.

Visible

Determines the visibility of the cube hierarchy. The default value is True.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft