通过

JoinClause (Level Interface)

注意注意

  下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。

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

注释

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

示例

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"

请参阅

参考

Level Interface