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.