Cube Dimension - Order Delivery Term

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

ATTRIBUTES

Attribute Hierarchy Description
Order Delivery Term NO Key. Built as CODE + ' - ' + DESCRIPTION
Order Delivery Term Code NO Represents the CODE of the dimension, i.e. the order delivery term.
Order Delivery Term Description NO Represents the DESCRIPTION of an order delivery term.

USED BY CUBE

Cube Name
PROCUREMENT
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_ORDER_DELIVERY_TERM_BI MPCCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.048 Load IFSAppl_DIM_ORDER_DELIVERY_TERM_BI.dtsx IFSAppl_DIM_ORDER_DELIVERY_TERM
T - DW 2.1.048 Load Dw_DIM_ORDER_DELIVERY_TERM.dtsx Dw_DIM_ORDER_DELIVERY_TERM
L - DM 3.1.048 Load Dm_DIM_ORDER_DELIVERY_TERM.dtsx Dm_DIM_ORDER_DELIVERY_TERM