The FromClause property of the Level interface contains the SQL FROM clause for the level.
| 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 a level’s FROM clause:
' 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 display in the immediate window would show the following:
Level: Store_Name
From Clause: "store"
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |