JoinClause (Dimension Interface)
[!NOTA]
Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.
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.
Osservazioni
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.
Esempio
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