JoinClause (Level 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 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
Osservazioni
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
Esempio
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"