CUBE DIMENSION - SOURCE CONNECTION

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

ATTRIBUTES

Attribute Hierarchy Description
Source Connection NO Key. Built as CODE+ ' - ' + SOURCE_CONNECTION_LU_NAME
Source Connection Code NO Represents the code of Source Connection
Source Connection Name NO Represents the description of the Source Connection

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.189 Load IFSAppl_DIM_JT_CONNECTED_OBJECT_BI.dtsx IFSAppl_DIM_JT_CONNECTED_OBJECT_BI
T - DW 2.1.189 Load Dw_DIM_JT_CONNECTED_OBJECT.dtsx Dw_DIM_JT_CONNECTED_OBJECT
L - DM 3.1.189 Load Dm_DIM_JT_CONNECTED_OBJECT.dtsx Dm_DIM_JT_CONNECTED_OBJECT