Cube Dimension - Inventory Part

This cube dimension represents the inventor part information and is based on the IFS Applications dimension DIM_INVENTORY_PART. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is contract (site), i.e. each contract (site) has its own set of inventory parts.

ATTRIBUTES

Attribute Hierarchy Description
Abc Class NO The ABC class (ABC_CLASS)
Inventory Part NO Key. Built as CONTRACT + ' - ' + CODE + ' - ' + PART_DESC
Inventory Part Code NO Product code. Refers to Inventory Part No in IFS Applications
Inventory Part Code Description NO The product code description
Inventory Part Cost Level NO The description of the inventory part cost level (INV_PART_COST_LEVEL_DESC)
Inventory Part Description NO The inventory part description (PART_DESC)
Inventory Part Valuation Method NO The valuation metod of the inventory part.
Invoice Consideration NO The description of invoice consideration value (INVOICE_CONSIDERATION_DESC) of the part.
Mrp Order Code NO The MRP order code (MRP_ORDER_CODE) of the part
Part Cost Group NO The identity of the part cost group
Part Status NO The part status value.
Prime Commodity NO The prime commodity value (PRIME_COMMODITY) of the part.
Product Code NO The product code for the part.
Product Family NO The description of the product family the part belongs to.
Second Commodity NO The second commodity value (SECOND_COMMODITY)
Site NO The natural key, site or contract. (CONTRACT)
Supply Chain Part Group NO The related supply chain part group (SUPPLY_CHAIN_PART_GROUP)
Type Code NO The description of the type code (TYPE_CODE_DESC)
Unit Meas NO Uppercase of unit measure.
Site ProductFamily Part Hierarchy YES Hierarchy built as "Site" -> "Inventory Part"

USED BY CUBE

Cube Name
MANUFACTURING
PROCUREMENT
SALES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.059 Load IFSAppl_DIM_INVENTORY_PART_BI.dtsx IFSAppl_DIM_INVENTORY_PART_BI
T - DW 2.1.059 Load Dw_DIM_INVENTORY_PART.dtsx Dw_DIM_INVENTORY_PART
L - DM 3.1.059 Load Dm_DIM_INVENTORY_PART.dtsx Dm_DIM_INVENTORY_PART