The Dimension interface supports the following properties.
| Property | Description |
|---|---|
| AggregationUsage | Specifies how aggregations are to be designed for a dimension. |
| ClassType | Returns an enumeration constant identifying the specific object type. |
| DataSource | The data source object of a dimension object. |
| Description | Description of a dimension. |
| DimensionType | Returns an enumeration constant identifying the specific type of dimension. |
| FromClause | SQL FROM clause for a dimension. |
| IsShared | Indicates whether a dimension can be shared among cubes. |
| IsTemporary | Indicates whether an object is temporary. |
| IsValid | Indicates whether a dimension structure is valid. |
| JoinClause | SQL JOIN clause for a dimension. |
| LastProcessed | Date and time when a dimension was last processed. |
| LastUpdated | User-specified date. Not used by OLAP Services. |
| Name | Dimension name. |
| OrdinalPosition | Returns the ordinal position of the dimension object within its parent object’s Dimensions collection. |
| Parent | Returns a reference to the parent MDStore object. |
| SourceTable | Returns the name of the source table for the dimension. |
| State | Returns an enumeration constant indicating the difference between the dimension object referenced by the client application and the corresponding dimension on the OLAP server. |
| SubClassType | Returns an enumeration constant identifying the subclass type of the 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 Dimension |
clsCube Dimension |
clsPartition Dimension |
clsAggregation Dimension |
|---|---|---|---|---|
| AggregationUsage | n/a | R/W | R | n/a |
| ClassType | R | R | R | R |
| DataSource | R/W* | R* | R* | R |
| Description | R/W | R | R/W | n/a |
| Dimension Type |
R/W | R | R | R |
| FromClause | R/W | R | R | R/W |
| IsShared | R | R | R | R |
| IsTemporary | R | R | R | R |
| IsValid | R | R | R | R |
| JoinClause | R/W | R | R | R/W |
| Last Processed |
R | R | R | R |
| Last Updated |
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) |
| Ordinal Position |
R | R | R | R |
| Parent | R | R | R | R |
| SourceTable | R | R | R | n/a |
| State | R | n/a | n/a | R |
| SubClassType | R | R | R | R |
* This property is not applicable (n/a) for virtual objects (that is, those of SubClassType sbclsVirtual).
Note The LastProcessed property of objects that implement the Dimension interface are not initialized until the dimension is processed for the first time. An error will be raised if LastProcessed is accessed when the State property of the dimension object equals olapStateNeverProcessed.