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.