CUBE DIMENSION - PURCHASE CHARGE TYPE

This cube dimension represents condition codes and is based on the IFS Applications dimension DIM_PURCHASE_CHARGE_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

ATTRIBUTES

Attribute Hierarchy Description
Purchase Charge Type YES Key. Built as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION
Purchase Charge Code NO Represents the CODE of the dimension, i.e. the charge type code.
Purchase Charge Descr NO Represents the DESCRIPTION of a charge type.
Purchase Charge Distributed by NO The method of distributing the charge, i.e. per amount, per weight etc. Underlying column DISTRIBUTE_CHARGE_BY_DESC.
Purchase Charge Group YES Represents the charge group.
Purchase Charge Site NO The code of the site being charged.

USED BY CUBE

Cube Name
PROCUREMENT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PURCHASE_CHARGE_TYPE_BI PURCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.050 Load IFSAppl_DIM_PURCHASE_CHARGE_TYPE_BI.dtsx IFSAppl_DIM_PURCHASE_CHARGE_TYPE
T - DW 2.1.050 Load Dw_DIM_PURCHASE_CHARGE_TYPE.dtsx Dw_DIM_PURCHASE_CHARGE_TYPE
L - DM 3.1.050 Load Dm_DIM_PURCHASE_CHARGE_TYPE.dtsx Dm_DIM_PURCHASE_CHARGE_TYPE