This cube dimension represents the Planning STructure based on Planning Units and is based on the IFS Applications dimension DIM_PLANNING_STRUCTURE_ITEM. A planning unit structure is defined in order to monitor and review the approval process of planning units. It can also be used to aggregate the numbers in a hierarchy according to the structure.All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is master company and Business Plan, i.e. each master company has its own set of structure values based on Business Plans.
Attribute | Hierarchy | Description |
Business Plan ID | NO | Business Plan ID |
Company ID | NO | Company Code |
Planning Structure | NO | Key. Built as COMPANY + ' - ' + BUSINESS PLAN + ' - ' + STRUCTURE_ITEM |
PlanStructHy | YES | Parent-Child hierarchy used for drilldown in the planning structure |
Structure Item | NO | Represents the CODE of the dimension, i.e. Structure Item value |
Structure Item Type | NO | Represents the type of the item. I.e. Node or Planning Unit |
Structure Node Status | NO | Status of the Structure Node |
Cube Name |
GENERAL LEDGER |
BI Access View | BI Component | Recommended Source Type |
DIM_CONSOL_STRUCTURE_BI | BUSPDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.198 Load IFSAppl_DIM_PLANNING_STRUCTURE_ITEM_BIA.dtsx | IFSAppl_DIM_PLANNING_STRUCTURE_ITEM_BIA |
T - DW | 2.1.198 Load Dw_DIM_PLANNING_STRUCTURE_ITEM.dtsx | Dw_DIM_PLANNING_STRUCTURE_ITEM |
L - DM | 3.1.198 Load Dm_DIM_PLANNING_STRUCTURE_ITEM.dtsx | Dm_DIM_PLANNING_STRUCTURE_ITEM |