Properties, Dimension 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 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.

See Also

Reference

Dimension Interface

Help and Information

Getting SQL Server 2005 Assistance