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 |
|---|---|
Indicates whether the members of a level are uniquely identified by their member key column |
|
Indicates whether the members of a level are uniquely identified by their member name column |
|
Returns an enumeration constant that identifies the specific object type |
|
The size (in bytes) of members in the level member key column |
|
The data type of the level member key column in an aggregation table |
|
Contains the name of the column that contains member-specific rollup instructions |
|
Contains a Multidimensional Expressions (MDX) expression used to override the default rollup mode |
|
Contains the name of the column that contains member-specific rollup properties |
|
The description of the level |
|
Determines whether aggregations can be created for a level in a dimension whose AggregationUsage property is set to dimAggUsageCustom |
|
The estimated number of members in the level |
|
The SQL FROM clause for a level |
|
Indicates the type of grouping used by the Analysis server |
|
Indicates whether a member should be hidden from client applications |
|
Indicates whether the level is disabled |
|
Indicates whether the level structure is valid |
|
Indicates whether the level is visible to client applications |
|
The SQL JOIN clause for the level |
|
Defines how levels in a parent-child hierarchy are named |
|
Returns an enumeration constant that identifies the specific type of level |
|
The name of the column or expression that contains member keys |
|
The name of the column or expression that contains member names |
|
The name of the level |
|
Specifies how the level should be ordered |
|
Specifies a member property used to determine the ordering of members |
|
Returns the ordinal position of the level in the collection of levels |
|
Returns a reference to the parent Dimension object |
|
Identifies the parent of a member in a parent-child hierarchy |
|
Determines how the root member or members of a parent-child hierarchy are identified |
|
Identifies the column that holds the number of empty levels between a member and its parent in a parent-child hierarchy |
|
The name of the level member used to define a partition slice |
|
Returns an enumeration constant identifying the subclass type of an object |
|
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 |
|---|---|---|---|---|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R/W |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
n/a |
R/W |
R |
n/a |
|
R/W |
R |
R |
R |
|
R |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
n/a |
R/W |
R |
R |
|
R |
R |
R |
R |
|
R/W |
R/W |
R |
R |
|
R |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R/W |
R/W |
R/W |
|
R/W |
R |
R |
R |
|
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) |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R |
R |
R |
R |
|
R |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
R/W |
R |
R |
R |
|
n/a |
n/a |
R/W |
n/a |
|
R |
R |
R |
R |
|
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.