다음을 통해 공유

  • 아티클

JoinClause (Dimension Interface)

[!참고]

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

The JoinClause property of the Dimension interface contains the SQL JOIN clause for the dimension.

Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Data Type

String

Access

Access depends on the value of the ClassType property of the object.

Class type

Access

clsDatabaseDimension

R/W*

clsCubeDimension

R

clsPartitionDimension

R

clsAggregationDimension

R/W

* Read-only for objects of ClassType clsDatabaseDimension that represent a virtual dimension created in Microsoft® SQL Server™ 7.0 OLAP Services.

주의

For objects of ClassType clsDatabaseDimension, if it represents a virtual dimension created in SQL Server 7.0 OLAP Services, the JoinClause property returns an empty string.

예

A database contains the following tables:

  • Sales_Facts

  • Customer

  • Product

  • Product_Class

  • Promotion

  • Store

  • Calendar

The following diagram illustrates the relationships of these tables.

Use the following code to return the JoinClause of the dimension object:

'Assume an object (dsoDim) of ClassType clsDimension exists
'and is associated with the Product dimension.
Dim strJoinClause As String
strJoinClause = dsoDim.JoinClause

'The immediate window displays the following: 
'"product"."SKU"="product_class"."SKU"
Debug.Print "  Join Clause: " & strJoinClause

참고 항목

참조

Dimension Interface