Measure Data Files Created by the Plan Extract Process

The plan extract process generates one measure data file for each set of measures that share the same dimensionality or granularity. Use the measure definition file to obtain more details about the measure, including its full name, description, aggregation methods, and so on.

The following table is an example measure data file for a specific dimensionality with a selected list of measures. The actual format depends on the dimensionality and the measures selected by users for extract.

Column name	Description
PLAN_ID	ID of the plan
PRD_LVL_MEMBER_ID	Product dimension lowest level member ID
ORG_LVL_MEMBER_ID	Organization dimension lowest level member ID
TIM_LVL_MEMBER_ID	Time dimension lowest level member ID
FACT_DATE	Date
AVG_DAILY_DMD	Value of this measure
GROSS_MARGIN_PCT	Value of this measure
IN_TRANSIT	Value of this measure
INV_TURNS	Value of this measure
ITEM_STD_COST	Value of this measure
ONHAND	Value of this measure
PAB	Value of this measure
PAB_VALUE	Value of this measure
PO_QTY	Value of this measure
PR_QTY	Value of this measure
PROJECTED_ONHAND	Value of this measure
SCHED_RCPT	Value of this measure
SS	Value of this measure
TF_QTY	Value of this measure
TOTAL_DEMAND	Value of this measure
TOTAL_DEMAND_VALUE	Value of this measure
TOTAL_SUPPLY	Value of this measure
TTL_END_ITEM_CST	Value of this measure
GROSS_MARGIN	Value of this measure

The extract process generates one measure data file for each set of measures that share the same dimensionality or granularity. The measure data files contain information for all measures that share that same dimensionality. A list of predefined dimensionality groups is listed in the Dimensionality Group Codes Used by the Plan Extract Process topic. The lowest level of each of these dimensions appears in each file. They will be different for each dimensionality, based on the dimensions that are part of that group. Each measure column name is a measure code from the measure definition file. Use the measure definition file to obtain more details about the measure, including its full name, description, aggregation, and so on.