다음을 통해 공유


Properties, Dimension Interface

[!참고]

  이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.

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.

참고 항목

참조