Dimension Data Files Created by the Plan Extract Process
The plan extract process generates one dimension data file for each dimension and contains all of the hierarchies in that dimension. Each dimension file contains information for all of the selected hierarchies.
For example, if the planner selects two product hierarchies, an item appears twice--once for each hierarchy.
|
Column name |
Content |
|---|---|
|
HIERARCHY_ID |
Internal hierarchy identifier |
|
[dimension]_LVL_MEMBER_ID |
ID of the lowest-level member. Each dimension file contains its own lowest level member. For example:
|
|
BASE_MBR_NAME |
Name of the lowest level member |
|
L2-MBR_ID |
Level 2 member ID |
|
L2_MBR_NAME |
Level 2 member name |
|
L3-MBR_ID |
Level 3 member ID |
|
L3_MBR_NAME |
Level 3 member name |
|
L4-MBR_ID |
Level 4 member ID |
|
L4_MBR_NAME |
Level 4 member name |
|
L5-MBR_ID |
Level 5 member ID |
|
L5_MBR_NAME |
Level 5 member name |
|
L6-MBR_ID |
Level 6 member ID |
|
L6_MBR_NAME |
Level 6 member name |
|
L7-MBR_ID |
Level 7 member ID |
|
L7_MBR_NAME |
Level 7 member name |
|
L8-MBR_ID |
Level 8 member ID |
|
L8_MBR_NAME |
Level 8 member name |
|
L9-MBR_ID |
Level 9 member ID |
|
L9_MBR_NAME |
Level 9 member name |
|
L10-MBR_ID |
Level 10 member ID |
|
L10_MBR_NAME |
Level 10 member name |
|
SR_BASE_MBR_ID |
Internal use only |