This is the documentation for SuperSTAR 9.8

SuperSTAR 9.9 is now available.
View this page in the SuperSTAR 9.9 documentation or visit the SuperSTAR 9.9 documentation home.

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