Cube Dimension - Sales Charge Group

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

ATTRIBUTES

Attribute Hierarchy Description
Sales Charge Group NO Key. Built as CODE + ' - ' + CHARGE_GROUP_DESC
Sales Charge Group Code NO The dimension CODE, i.e. sales charge group
Sales Charge Group Descr NO The description of the sales charge group (CHARGE_GROUP_DESC)

USED BY CUBE

Cube Name
SALES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.082 Load IFSAppl_DIM_SALES_CHARGE_GROUP_BI.dtsx IFSAppl_DIM_SALES_CHARGE_GROUP_BI
T - DW 2.1.082 Load Dw_DIM_SALES_CHARGE_GROUP.dtsx Dw_DIM_SALES_CHARGE_GROUP
L - DM 3.1.082 Load Dm_DIM_SALES_CHARGE_GROUP.dtsx Dm_DIM_SALES_CHARGE_GROUP