MEASURES - Registry Table
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 a fact table that contains the column. |
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.
