Analysis Services Programming
Properties, Dimension Interface
The Dimension interface supports the following properties.
| Property | Description |
|---|---|
| AggregationUsage | Specifies how aggregations are to be designed for a dimension. |
| AllowSiblingsWithSameName | Indicates whether two or more children of the same parent member can have the same name. |
| AreMemberKeysUnique | Indicates whether member keys are unique for all members in the dimension. |
| AreMemberNamesUnique | Indicates whether member names are unique for all members in the dimension. |
| ClassType | Returns an enumeration constant that identifies the specific object type. |
| DataMemberCaption Template |
Contains a template string that is used to generate captions for system-generated data members. |
| DataSource | The data source object of a dimension object. |
| DefaultMember | Defines the default member of the dimension. |
| DependsOnDimension | Names a dimension to which the current dimension is related. |
| Description | The description of a dimension. |
| DimensionType | Returns an enumeration constant identifying the specific type of dimension. |
| EnableRealTimeUpdates | Indicates whether or not the dimension supports real-time updates. |
| FromClause | The SQL FROM clause for a dimension. |
| IsChanging | Indicates whether members and/or levels are expected to change on a regular basis. |
| IsReadWrite | Indicates whether dimension writebacks are available to client applications that have appropriate permissions. |
| 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. |
| IsVirtual | Indicates whether a dimension is virtual. |
| IsVisible | Indicates whether the dimension is visible to clients. |
| JoinClause | The SQL JOIN clause for a dimension. |
| LastProcessed | The date and time when a dimension was last processed. |
| LastUpdated | A user-specified date. It is not used by Microsoft® SQL Server™ 2000 Analysis Services. |
| MembersWithData | Determines which members in a dimension can have associated data in the fact table. |
| Name | The dimension name. |
| OrdinalPosition | Returns the ordinal position of the dimension object in the Dimensions collection of its parent object. |
| Parent | Returns a reference to the parent MDStore object. |
| SourceTable | Returns the name of the source table for the dimension. |
| SourceTableAlias | Returns the alias of the source table for the dimension. |
| SourceTableFilter | Restricts members included in a dimension. |
| State | Returns an enumeration constant that indicates the difference between the dimension object referenced by the client application and the corresponding dimension on the Analysis server. |
| StorageMode | Determines the method of storing dimension contents. |
| SubClassType | Returns an enumeration constant that identifies the subclass type of the object. |
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 dimension |
clsCube dimension |
clsPartition dimension |
clsAggregation dimension |
|---|---|---|---|---|
| AggregationUsage | n/a | R/W | R | n/a |
| AllowSiblingsWithSameName | R/W | R | R | R |
| AreMemberKeysUnique | R/W | R | R | R |
| AreMemberNamesUnique | R/W | R | R | R |
| ClassType | R | R | R | R |
| DataMemberCaptionTemplate | R/W* | R | R | R |
| DataSource | R/W | R | R | R |
| DefaultMember | R/W | R | R | R |
| DependsOnDimension | R/W | R | R | R |
| Description | R/W | R | R/W | n/a |
| DimensionType | R/W | R | R | R |
| EnableRealTimeUpdates | R/W | R | R | R |
| FromClause | R/W | R | R | R/W |
| IsChanging | R/W | R | R | R |
| IsReadWrite | R/W | R | R | R |
| IsShared | R | R | R | R |
| IsTemporary | R | R | R | R |
| IsValid | R | R | R | R |
| IsVirtual | R/W | R | R | R |
| IsVisible | n/a | R/W | R | R |
| JoinClause | R/W | R | R | R/W |
| LastProcessed** | R | R | R | R |
| LastUpdated | R/W | R | R | R |
| MembersWithData | 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) |
| OrdinalPosition | R | R | R | R |
| Parent | R | R | R | R |
| SourceTable | R | R | R | n/a |
| SourceTableAlias | R | R | R | n/a |
| SourceTableFilter | R/W | R | R | R |
| State | R | n/a | n/a | R |
| StorageMode | R/W | R | R | R |
| SubClassType | R | R | R | R |
* This property is read/write only for objects of SubClassType sbclsParentChild.
** The LastProcessed property of objects that implement the Dimension interface are not initialized until the dimension is processed for the first time. An error is raised if LastProcessed is accessed when the State property of the dimension object equals olapStateNeverProcessed.