CUBE DIMENSION - INVENTORY VALUE

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.

ATTRIBUTES

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"

USED BY CUBE

Cube Name
INVENTORY

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_INVENTORY_VALUE_BI INVEFT On Line

Please refer to FACT_INVENTORY_VALUE