Properties, clsCubeDimension

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.

An object of ClassType clsCubeDimension implements the following properties of the Dimension interface.

Property	Description
AggregationUsage	Specifies how aggregations are to be designed for the dimension.
AllowSiblingsWithSameName	Indicates whether a parent-child dimension can contain members with identical names.
AreMemberKeysUnique	Indicates whether member keys are unique for the dimension.
AreMemberNamesUnique	Indicates whether member names are unique for the dimension.
ClassType	Returns an enumeration constant that identifies the specific object type, which in this case is clsCubeDimension.
DataMemberCaptionTemplate	Contains a template string that is used to create captions for system-generated data members.
DataSource	A reference to the data source object used by the cube dimension.
DefaultMember	Defines the default member of the dimension.
DependsOnDimension	Names a dimension to which the current dimension is related.
Description	The description of the cube dimension.
DimensionType	Returns an enumeration constant that identifies the specific type of dimension.
EnableRealTimeUpdates	Indicates whether real-time updates are enabled for the dimension.
FromClause	The SQL FROM clause for the cube dimension.
IsChanging	Indicates whether members and/or levels are expected to change on a regular basis.
IsReadWrite	Indicates whether dimension writebacks are available to clients with appropriate permissions.
IsShared	Indicates whether the cube dimension is shared.
IsTemporary	Indicates whether the cube dimension is temporary.
IsValid	Indicates whether the structure of the cube dimension is valid.
IsVirtual	Indicates whether a dimension is virtual.
IsVisible	Indicates whether the dimension is visible to the client.
JoinClause	The SQL JOIN clause for a cube dimension.
LastProcessed	The date and time when the cube dimension was last processed.
LastUpdated	User-specified date. This 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 name of the cube dimension.
OrdinalPosition	Returns the ordinal position of the dimension object within the Dimensions collection of its parent object.
Parent	Returns a reference to the parent MDStore object.
SourceTable	The name of the cube dimension's primary data source table.
SourceTableAlias	Returns the alias of the source table for the dimension.
SourceTableFilter	Restricts members included in a dimension.
StorageMode	Determines the method for storing dimension contents.
SubClassType	Returns an enumeration constant that identifies the subclass type of the object.

See Also

Reference

clsCubeDimension
Dimension Interface

Help and Information

Getting SQL Server 2005 Assistance