Measure Definition Files Created by the Plan Extract Process
The measure definition file contains information for all of the measures specified in the measure catalog for extract. The plan extract process creates only one file per extract.
Column name |
Description |
---|---|
GRANULARITY_ID |
Dimensionality group ID |
POSITION |
Internal use only |
MEASURE_CODE |
Used as the column name in measure data files |
MEASURE_ID |
ID that uniquely identifies a measure |
NAME |
Name of the measure |
DESCRIPTION |
Brief description of the measure |
DATA_TYPE |
Data type |
EXPRESSION |
Internal use only |
AGGR_ORDER |
Aggregation rule: 1 = Calculate, then aggregate 2 = Aggregate, then calculate |
AGGR_METHOD_OTHER |
Aggregation method on dimensions other than the Time dimension |
AGGR_METHOD_TIME |
Aggregation method on the Time dimension |
WEIGHTED_BY |
ID of the measure to be used when aggregation method is WAVG (weighted average) |
The MEASURE_CODE column in this file contains all the measure codes for all measures. The actual measure data files use this measure code as data column name. Using this code, you can look up additional information about the measure in the definition file. Note that the expression indicated is only for internal use and is already evaluated before the extract. Aggregation methods (Sum, Latest, Average, Weighted Average, and so on) can be used to configure your analytics to aggregate these measures across various dimensions.