FromClause (Level Interface)
[!참고] 이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
The FromClause property of the Level interface contains the SQL FROM clause for the level.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
String
Access
Read-only
주의
This property returns a table name that is the same value as the SourceTable property of the parent dimension object.
예
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 print the FROM clause for a level object:
' Assume an object (dsoLevel) of ClassType clsLevel
' and is associated with the Store dimension and
' Store_Name level
Debug.Print " Level: " & dsoLevel.Name
Debug.Print " From Clause: " & dsoLevel.FromClause
The immediate window displays the following:
Level: Store_Name
From Clause: "store"