Cube Dimension - Inventory Location

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

ATTRIBUTES

Attribute Hierarchy Description
Site - Location NO Key. Built as CONTRACT + ' - ' + CODE
Location Code NO Represents the CODE of the dimension. Refers to Location No in IFS Applications
Location Group YES Represents the inventory location group
Location Name NO Represents the Name of an inventory Location
Site YES Represents the Site Code
Warehouse Name NO Represents the WAREHOUSE

USED BY CUBE

Cube Name
PROCUREMENT

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.043 Load IFSAppl_DIM_INVENTORY_LOCATION_BI.dtsx IFSAppl_DIM_INVENTORY_LOCATION
T - DW 2.1.043 Load Dw_DIM_INVENTORY_LOCATION.dtsx Dw_DIM_INVENTORY_LOCATION
L - DM 3.1.043 Load Dm_DIM_INVENTORY_LOCATION.dtsx Dm_DIM_INVENTORY_LOCATION