The JoinClause property of the Dimension interface contains the SQL JOIN clause for the dimension.
| clsAggregationDimension | clsDatabaseDimension |
| clsCubeDimension | clsPartitionDimension |
String
The access type depends on the class of the dimension object.
| Class | Access |
|---|---|
| clsDatabaseDimension | R/W |
| clsCubeDimension | R |
| clsPartitionDimension | R |
| clsAggregationDimension | R/W |
A database contains the following tables:
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 will display
'"product"."SKU"="product_class"."SKU"
Debug.Print " Join Clause: " & strJoinClause
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |