CUBE DIMENSION - TRANSACTION TYPE

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

ATTRIBUTES

Attribute Hierarchy Description
Transaction Type NO Key. Built as CODE
Transaction Type Desc NO Represents the description of the Transaction Type

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_TRANSACTION_TYPE_BI WODI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.203 Load IFSAppl_DIM_TRANSACTION_TYPE_BI.dtsx IFSAppl_DIM_TRANSACTION_TYPE_BI
T - DW 2.1.203 Load Dw_DIM_TRANSACTION_TYPE.dtsx Dw_DIM_TRANSACTION_TYPE
L - DM 3.1.203 Load Dm_DIM_TRANSACTION_TYPE.dtsx Dm_DIM_TRANSACTION_TYPE