Cube Dimension - Structure

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.

ATTRIBUTES

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

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

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