JoinClause (Dimension Interface)
.gif "Hinweis") Hinweis |
|---|
Diese Funktion wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie so bald wie möglich das Ändern von Anwendungen, in denen es zurzeit verwendet wird. |
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.
Hinweise
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.
Beispiel
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