DBSchema columns

This table describes the supported column names:

Column name Description
TABLE_CATALOG
TABLE_NAME All permitted dimensions and cubes that have a measure dimension.

If a dimension name collides with a cube name, the prefix DIM_ is used.

COLUMN_NAME If TABLE_NAME is a cube:
  • The dimension prefix is only added to a level, an attribute or a property.
  • The measure dimension is not listed.

If TABLE_NAME is a dimension:

  • Column name 'ID' is used for the dimension.
  • No dimension prefix is added to a level, an attribute or a property.

If there is a naming collision, only the necessary column names have the prefix DIM_, LVL_, ATTx_ or PROP_

IS_NULLABLE False or True. Only dimensions are not nullable
DATA_TYPE Supported data types: string, numeric, logical, date
CHARACTER_SET_NAME
COLUMN_OLAP_TYPE Supported types: MEASURE, DIMENSION, LEVEL, ATTRIBUTE, and PROPERTY