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 generalized field |
|
… |
There can be multiple generalized fields |
Example:
|
1 |
list table,dim,type of Orders.CustomerID |
List the table, dimension and data type the generalized field Orders.CustomerID belongs to |
|
2 |
list dim,type of Orders.ShipDate#year |
List the dimension and data type for the level function year in the generalized 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 |