CUBE DIMENSION - BUSINESS PLAN

This cube dimension represents sales person and is based on the IFS Applications dimension COUNTER PART ONE. The dimension is normally based on Code Part K.All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Company Code NO Represents the Company Code of the dimension.
Counter Part One NO Key. Built as COMPANY+' - 'CODE + ' - ' + DESCRIPTION
Counter Part  Code Desc NO Represents the CODE + Description of the dimension.
Counter Part One Code NO Represents the CODE of the dimension.
Counter Part One Desc NO Represents the Description of the dimension.
CounterPartOneHy YES Hierarchy consisting of levels
-Company Code
-Counter Part One Code Descr

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_COUNTER_PART_ONE_BI ACCRDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.160 Load IFSAppl_DIM_COUNTER_PART_ONE_BI.dtsx IFSAppl_DIM_COUNTER_PART_ONE_BI
T - DW 2.1.160 Load Dw_DIM_COUNTER_PART_ONE.dtsx Dw_DIM_COUNTER_PART_ONE
L - DM 3.1.160 Load Dm_DIM_COUNTER_PART_ONE.dtsx Dm_DIM_COUNTER_PART_ONE