Cube Dimension - Internal Destination

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

ATTRIBUTES

Attribute Hierarchy Description
Internal Destination NO Key. Built as CODE + ' - ' + DESCRIPTION
Internal Destination Code NO Represents the CODE of the dimension, i.e. the internal destination.
Internal Destination Description NO Represents the Description of an internal destination.

USED BY CUBE

Cube Name
PROCUREMENT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_INTERNAL_DESTINATION_BI INVEDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.035 Load IFSAppl_DIM_INTERNAL_DESTINATION_BI.dtsx IFSAppl_DIM_INTERNAL_DESTINATION
T - DW 2.1.035 Load Dw_DIM_INTERNAL_DESTINATION.dtsx Dw_DIM_INTERNAL_DESTINATION
L - DM 3.1.035 Load Dm_DIM_INTERNAL_DESTINATION.dtsx Dm_DIM_INTERNAL_DESTINATION