CUBE DIMENSION - SALES CHARGE TYPE

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

Natural parent is contract (site).

ATTRIBUTES

Attribute Hierarchy Description
Sales Charge Type NO Key. Built as CONTRACT + ' - ' + CODE + ' - ' + CHARGE_TYPE_DESC
Sales Charge Type Code NO The dimension CODE, i.e. sales charge type
Sales Charge Type Contract NO The natural parent CONTRACT (site)
Sales Charge Type Descr NO The description of the sales charge type (CHARGE_TYPE_DESC)

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SALES_CHARGE_TYPE_BI ORDEDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.026 Load IFSAppl_DIM_SALES_CHARGE_TYPE_BI.dtsx IFSAppl_DIM_SALES_CHARGE_TYPE_BI
T - DW 2.1.026 Load Dw_DIM_SALES_CHARGE_TYPE.dtsx Dw_DIM_SALES_CHARGE_TYPE
L - DM 3.1.026 Load Dm_DIM_SALES_CHARGE_TYPE.dtsx Dm_DIM_SALES_CHARGE_TYPE