The JoinClause property of the Level interface contains a reference to a set of tables in a fashion similar to the FromClause property. JoinClause, however, shows how the tables are linked.
| clsAggregationLevel | clsDatabaseLevel |
| clsCubeLevel | clsPartitionLevel |
String
Read-only
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 level object:
' Assume an object (dsoLevel) of ClassType clsLevel
' and is associated with the Product dimension and
' SKU level
Debug.Print " Level: " & dsoLevel.Name
Debug.Print " Join Clause: " & dsoLevel.JoinClause
The display in the immediate window would show the following:
Level: SKU
Join Clause: "product"."SKU"="product_class"."SKU"
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |