Skip to end of metadata
Go to start of metadata

Use the MEASURES registry table to specify the columns in a fact table that are to be treated as measures.

Table Definition

Column NameData TypeSizePrimary KeySpecifies...

COLUMNNAME

string

128

YES

The name of a column to be set as a measure.

TABLENAME

string

128

YES

The name of the fact table that this column belongs to.

Example

SuperCHANNEL automatically recognises these fact table columns as measures:

Fact table columns that are not listed in the MEASURES table (and are not classifications) are automatically treated as plain columns.

  • No labels