Share via


Properties, Level Interface

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The Level interface supports the following properties.

Property

Description

AreMemberKeysUnique

Indicates whether the members of a level are uniquely identified by their member key column

AreMemberNamesUnique

Indicates whether the members of a level are uniquely identified by their member name column

ClassType

Returns an enumeration constant that identifies the specific object type

ColumnSize

The size (in bytes) of members in the level member key column

ColumnType

The data type of the level member key column in an aggregation table

CustomRollUpColumn

Contains the name of the column that contains member-specific rollup instructions

CustomRollUpExpression

Contains a Multidimensional Expressions (MDX) expression used to override the default rollup mode

CustomRollUpPropertiesColumn

Contains the name of the column that contains member-specific rollup properties

Description

The description of the level

EnableAggregations

Determines whether aggregations can be created for a level in a dimension whose AggregationUsage property is set to dimAggUsageCustom

EstimatedSize

The estimated number of members in the level

FromClause

The SQL FROM clause for a level

Grouping

Indicates the type of grouping used by the Analysis server

HideMemberIf

Indicates whether a member should be hidden from client applications

IsDisabled

Indicates whether the level is disabled

IsValid

Indicates whether the level structure is valid

IsVisible

Indicates whether the level is visible to client applications

JoinClause

The SQL JOIN clause for the level

LevelNamingTemplate

Defines how levels in a parent-child hierarchy are named

LevelType

Returns an enumeration constant that identifies the specific type of level

MemberKeyColumn

The name of the column or expression that contains member keys

MemberNameColumn

The name of the column or expression that contains member names

Name

The name of the level

Ordering

Specifies how the level should be ordered

OrderingMemberProperty

Specifies a member property used to determine the ordering of members

OrdinalPosition

Returns the ordinal position of the level in the collection of levels

Parent

Returns a reference to the parent Dimension object

ParentKeyColumn

Identifies the parent of a member in a parent-child hierarchy

RootMemberIf

Determines how the root member or members of a parent-child hierarchy are identified

SkippedLevelsColumn

Identifies the column that holds the number of empty levels between a member and its parent in a parent-child hierarchy

SliceValue

The name of the level member used to define a partition slice

SubClassType

Returns an enumeration constant identifying the subclass type of an object

UnaryOperatorColumn

The name of the column that contains member-specific rollup instructions in the form of mathematical operators

Access Cross-Reference

The following table shows whether the property is read/write (R/W), read-only (R), or not applicable (n/a) for different objects.

Property

clsDatabase

Level

clsCube

Level

clsPartition

Level

clsAggregation

Level

AreMemberKeysUnique

R/W

R

R

R

AreMemberNamesUnique

R/W

R

R

R

ClassType

R

R

R

R

ColumnSize

R/W

R

R

R

ColumnType

R/W

R

R

R

CustomRollUpColumn

R/W

R

R

R

CustomRollUpExpression

R/W

R/W

R

R

CustomRollUpPropertiesColumn

R/W

R

R

R

Description

R/W

R

R

R

EnableAggregations

n/a

R/W

R

n/a

EstimatedSize

R/W

R

R

R

FromClause

R

R

R

R

Grouping

R/W

R

R

R

HideMemberIf**

R/W

R

R

R

IsDisabled

n/a

R/W

R

R

IsValid

R

R

R

R

IsVisible

R/W

R/W

R

R

JoinClause

R

R

R

R

LevelNaming Template

R/W

R

R

R

LevelType

R/W

R

R

R

MemberKey Column

R/W

R/W

R/W

R/W

MemberName Column

R/W

R

R

R

Name

R/W (R after the object has been named)

R/W (R after the object has been named)

R/W (R after the object has been named)

R/W (R after the object has been named)

Ordering

R/W

R

R

R

OrderingMemberProperty

R/W

R

R

R

OrdinalPosition

R

R

R

R

Parent

R

R

R

R

ParentKeyColumn

R/W

R

R

R

RootMemberIf

R/W

R

R

R

SkippedLevelsColumn

R/W

R

R

R

SliceValue

n/a

n/a

R/W

n/a

SubClassType

R

R

R

R

UnaryOperatorColumn

R/W

R

R

R

** This property does not apply to levels of SubClassType sbclsParentChild or sbclsMining. This property applies only to levels of SubClassType sbclsParentChild or sbclsMining.