Cube Dimension - MPCCOM Transaction Code

This cube dimension represents MPCCOM Transaction Code and is based on the IFS Applications dimension DIM_MPCCOM_TRANSACTION_CODE. All cubes that refers to this dimension will have the attributes described below.

ATTRIBUTES

Attribute Hierarchy Description
MPCCOM Transaction NO Key. Built as CODE +'-'+ DESCRIPTION
MPCCOM Transaction Code NO The CODE of the dimensions, i.e. the MPCCOM Transaction identity
MPCCOM Transaction Direction NO The direction of the transaction. It describes whether the quantity in stock is decreased (-), increased (+), or unaffected (0) by the transaction.
MPCCOM Transaction Source NO Represents the source for the transaction
MPCCOM Transaction Source Application NO Represents the transaction application source
MPCCOM Transaction Source Application Description NO Represents the transaction application source description
MPCCOM Transaction Source Desc NO Represents the description of the source for the transaction
MPCCOM Transaction - Last Loaded NO Represents the last ETL process date.
Transaction NO Represents the description of the transaction type

USED BY CUBE

Cube Name
INVENTORY

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.107 Load IFSAppl_DIM_MPCCOM_TRANSACTION_CODE_BI.dtsx IFSAppl_DIM_MPCCOM_TRANSACTION_CODE_BI
T - DW 2.1.107 Load Dw_DIM_MPCCOM_TRANSACTION_CODE.dtsx Dw_DIM_MPCCOM_TRANSACTION_CODE
L - DM 3.1.107 Load Dm_DIM_MPCCOM_TRANSACTION_CODE.dtsx Dm_DIM_MPCCOM_TRANSACTION_CODE