Jaa


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