The Level interface supports the following properties.
| Property | Description |
|---|---|
| ClassType | Returns an enumeration constant identifying the specific object type. |
| ColumnSize | Size of the level aggregation column in an aggregation table. |
| ColumnType | Data type of the level aggregation column in an aggregation table. |
| Description | Description of the level. |
| EnableAggregations | Determines if aggregations will be created for a level in a dimension whose AggregationUsage property is set to dimAggUsageCustom. |
| EstimatedSize | Estimated number of members in the level. |
| FromClause | SQL FROM clause for a level. |
| IsDisabled | Indicates whether a level is disabled. |
| IsUnique | Indicates whether all members for a level are uniquely identified by the member key column alone. |
| IsValid | Indicates whether a level structure is valid. |
| JoinClause | SQL JOIN clause for a level. |
| LevelType | Returns an enumeration constant identifying the specific type of level. |
| MemberKeyColumn | Name of the column or expression that contains member keys. |
| MemberNameColumn | Name of the column or expression that contains member names. |
| Name | Name of a level. |
| Ordering | Specifies how a level should be ordered. |
| OrdinalPosition | Returns the ordinal position of a level in the collection of levels. |
| Parent | Returns a reference to the parent Dimension object. |
| SliceValue | Name of the level member used to define a partition slice. |
| SubClassType | Returns an enumeration constant identifying the subclass type of an object. |
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 |
|---|---|---|---|---|
| ClassType | R | R | R | R |
| ColumnSize | R/W | R | R | R |
| ColumnType | R/W | R | R | R |
| Description | R/W | R | R | R/W |
| EnableAggregations | n/a | R/W | R | n/a |
| EstimatedSize | R/W | R | R | R |
| FromClause | R | R | R | R |
| IsDisabled | n/a | R/W* | R | R |
| IsUnique | R/W | R | R | R |
| IsValid | R | R | R | R |
| JoinClause | R | 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 |
| OrdinalPosition | R | R | R | R |
| Parent | R | R | R | R |
| SliceValue | n/a | n/a | R/W | n/a |
| SubClassType | R | R | R | R |
| * This property is read-only (R) for virtual cubes (that is, those of SubClassType sbclsVirtual). | ||||