This cube dimension represents inventory value and is based on the IFS Applications fact view FACT_INVENTORY_VALUE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Configuration ID | NO | This number is automatically assigned to identify a specific part configuration specification which is a unique combination of characteristics and options that is used in conjunction with a Configurable part. |
Inventory Value | NO | Key. Built as CONTRACT_KEY+'-'+STAT_YEAR_NO_KEY+'-'+STAT_PERIOD_NO_KEY+'-'+PART_NO_KEY+'-'+CONFIGURATION_ID_KEY+'-'+LOT_BATCH_NO_KEY+'-'+SERIAL_NO_KEY+'-'+CONDITION_CODE_KEY. |
Last Loaded | NO | Identifies the last time the fact table was loaded. |
Lot Batch No | NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
Rep Curr Unit Cost | NO | The unit cost for a reporting currency. |
Serial No | NO | The serial number of the part if there is one. |
Stat Period No | NO | Identifies statistic month of year. |
Stat Year No | NO | The statistic year number. |
Unit cost | NO | This is the unit cost for the part. |
StatPeriodHy | YES | Hierarchy defined as "Stat Year No" -> "Stat Period No" |
Cube Name |
INVENTORY |
BI Access View | BI Component | Recommended Source Type |
FACT_INVENTORY_VALUE_BI | INVEFT | On Line |
Please refer to FACT_INVENTORY_VALUE