Use the MEASURES registry table to specify the columns in a fact table that are to be treated as measures.
Table Definition
|
Column Name |
Data Type |
Size |
Primary Key |
Specifies... |
|---|---|---|---|---|
|
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.
