JoinClause (Level Interface)
[!NOTA]
Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.
The JoinClause property of the Level interface describes how related tables that define the parent Dimension object are linked and takes the form of a SQL JOIN clause.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
String
Access
Read-only
Notas
The JoinClause property of a level returns a nonempty string only when multiple dimension tables are used to define the parent Dimension object of the level. This type of definition results from the snowflake schema
Ejemplo
A database contains the following tables:
Sales_Facts
Customer
Product
Product_Class
Promotion
Store
Calendar
This 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"