Properties, Level Interface
[!참고]
이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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.