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.
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" |
Cube Name |
MANUFACTURING |
PROCUREMENT |
SALES |
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 |