Jaa


Properties, clsCubeLevel

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.

An object of ClassType clsCubeLevel implements the following properties of the Level interface.

Property Description

AreMemberKeysUnique

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

AreMemberNamesUnique

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

ClassType

Returns an enumeration constant identifying the specific object type which, in this case, is clsCubeLevel

ColumnSize

The size (in bytes) of the data in the MemberKeyColumn property of the level

ColumnType

The data type of the MemberKeyColumn property of the level

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 supplies cell properties for member-specific rollup instructions

Description

The description of the cube level

EnableAggregations

Specifies whether aggregations are to be enabled for the level object

EstimatedSize

The estimated number of rows of unique members in the level

FromClause

Contains the SQL FROM clause for the cube 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 cube level is disabled

IsValid

Indicates whether the structure of the cube level is valid

IsVisible

Indicates whether the level is visible to client applications

JoinClause

The SQL JOIN clause of the cube 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 that contains the member key of the cube level

MemberNameColumn

The name of the column that contains member names

Name

The name of the cube level

Ordering

Specifies the method to use when ordering the members of a level

OrderingMemberProperty

Specifies a member property used to determine the ordering of members

OrdinalPosition

Returns the ordinal position of the level in the parent object's Levels collection

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

SubClassType

Returns an enumeration constant that identifies the subclass type of the object

UnaryOperatorColumn

Contains the name of a column that stores mathematical operators serving as member-specific rollup instructions for the level

See Also

Reference

clsCubeLevel
Level Interface

Help and Information

Getting SQL Server 2005 Assistance