Functionality:
List the table, dimension and data type the generalized field belongs to; return null for a measure’s dimension.
Syntax:
list table,dim,type of GF,…
Parameter:
|
GF |
A general field |
|
… |
There can be multiple general fields |
Example:
|
1 |
list table,dim,type of Orders.CustomerID |
List the table, dimension and data type the general field Orders.CustomerID belongs to |
|
2 |
list dim,type of Orders.ShipDate#year |
List the dimension and data type for the level functionyear in the general field Orders.ShipDate |
|
3 |
list dim,type of OrderDetail.UnitPrice |
List the dimension and data type for UnitPrice field; since it is a measure in metadata, return null for its dimension |