CUBE DIMENSION - PLANNING UNIT

This cube dimension represents sales person and is based on the IFS Applications dimension PLANNING UNIT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Business Plan ID NO Represents the ID of the correspondning Business Plan.
Company Code NO Represents the Company Code of the dimension.
Planning Step Desc NO Description of corresponding Planning Step
Planning Unit - Code NO Represents the CODE of the dimension.
Planning Unit - Code Desc NO Combination of CODE + ' - ' + DESCRIPTION
Planning Unit - Company Plan Code Desc NO Key. Represented as of COMPANY +' - ' + BUSINESS_PLAN_ID + ' - ' + CODE + ' - ' + DESCRIPTION
Planning Unit  - Desc   Represents the Description of the Planning Unit
Planing Unit  - Plan Code Desc NO Represented as BUSINESS_PLAN_ID + ' - ' + CODE + ' - ' + DESCRIPTION
Planning Unit Group Desc NO Represents the description of the Planning Unit Group.

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PLANNING_UNIT_BI BUSPDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.163 Load IFSAppl_DIM_PLANNING_UNIT_BI.dtsx IFSAppl_DIM_PLANNING_UNIT_BI
T - DW 2.1.163 Load Dw_DIM_PLANNING_UNIT.dtsx Dw_DIM_PLANNING_UNIT
L - DM 3.1.165 Load Dm_DIM_PLANNING_UNIT.dtsx Dm_DIM_PLANNING_UNIT