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

ヘルプおよび情報

SQL Server 2005 の参考資料の入手