Dimension Definition Files Created by the Plan Extract Process

The dimension definition file contains information for all of the dimensions and hierarchies specified in the dimension catalog for extract. The plan extract process creates only one file per extract.

Column name	Description
DIMENSION_ID	Unique ID of the dimension
HIERARCHY_ID	Unique ID of the hierarchy
BASE_LEVEL_ID	Lowest level (Level 1) ID
LEVEL_2_ID	Level 2 ID
LEVEL_3_ID	Level 3 ID
LEVEL_4_ID	Level 4 ID
LEVEL_5_ID	Level 5 ID
LEVEL_6_ID	Level 6 ID
LEVEL_7_ID	Level 7 ID
LEVEL_8_ID	Level 8 ID
LEVEL_9_ID	Level 9 ID
LEVEL_10_ID	Level 10 ID
DIMENSION_CODE	Unique code for the dimension
DIMENSION_NAME	Dimension name
HIERARCHY_NAME	Hierarchy name
BASE_LEVEL_NAME	Base level name
LEVEL_2_NAME	Level 2 name
LEVEL_3_NAME	Level 3 name
LEVEL_4_NAME	Level 4 name
LEVEL_5_NAME	Level 5 name
LEVEL_6_NAME	Level 6 name
LEVEL_7_NAME	Level 7 name
LEVEL_8_NAME	Level 8 name
LEVEL_9_NAME	Level 9 name
LEVEL_10_NAME	Level 10 name