Architecture
The Inventory cubes are based on relational data generated by the Inventory Control solution. These diagrams show the Landmark data sources and architecture of each of the Inventory cubes.
Inventory on hand cube
The Inventory on Hand cube offers a snapshot view into stock on hand, ordered, and backordered stock. The Inventory on Hand cube uses the Item Location business class as its source.
Inventory on hand measures
| Measure | Measure Source | Prefix | Cube Rule |
|---|---|---|---|
| StockOnHandQuantity | ItemLocation | ITL | |
| AverageCost | ItemLocation | ITL | |
| CurrentInventoryValue | ItemLocation | ITL | If InventoryCompanyRel.Costing Method = "STD" then ItemLocation.StockOnHandQuantity * ItemLocation.StandardCost If InventoryCompanyRel.Costing Method = "LIFO" then ItemLocation.StockOnHandQuantity * ItemLocation.LastReceiptCost if InventoryCompanyRel.Costing Method = "FIFO" then ItemLocation.StockOnHandQuantity * ItemLocation.LastIssueCost else ItemLocation.StockOnHandQuantity * AverageCost |
| BackorderedQuantity | ItemLocation | ITL | |
| Allocated Quantity | ItemLocation | ||
| In Process Quantity | ItemLocation | ||
| Inspection Hold Quantity | ItemLocation | ||
| In Transit Quantity | ItemLocation | ||
| Last Issue Cost | ItemLocation | ||
| Last Leadtime | ItemLocation | ||
| Last Receipt Cost | ItemLocation | ||
| Overhead Unit Cost | ItemLocation | ||
| Reorder Quantity | ItemLocation | ||
| Previous Leadtime | ItemLocation | ||
| Unallocated Quantity | ItemLocation | ||
| Leadtime Days | ItemLocation | ||
| Average Add On Cost | ItemLocation | ||
| BackorderedValue | ItemLocation | ITL | when Company.CostingMethod.Standard Costing then StandardCost * BackorderedQuantity else AverageCost * BackorderedQuantity |
| OnOrderQuantity | ItemLocation | ITL | |
| OnOrderValue | ItemLocation | ITL | when Company.CostingMethod.Standard Costing then StandardCost * OnOrderQuantity else AverageCost * OnOrderQuantity |
| Average SOH Quantity | ItemLocation |
| Related dimensions |
|---|
| Company |
| Item |
| Manufacturer |
| Item location |
Inventory transaction cube
The Inventory Transaction cube provides analysis of transactions by several dimensions including Calendar, Item, Inventory Location and Requesting Location. The Inventory Transaction cube uses the Inventory Transaction Line as its source.
Inventory transaction measures
| Measure | Measure Source | Cube Rule |
|---|---|---|
| Quantity | InventoryTransactionLine | |
| UnitCost | InventoryTransactionLine | |
| TransactionValue | InventoryTransactionLine | when TransactionSystemCode = "IC" and InventoryTransaction.InventoryDocumentType = "IR" THEN OpenQuantity * UnitCost ELSE Quantity * UnitCost |
| TransactionCount | InventoryTransactionLine | |
| Average Issue Value | Calculation |
| Related dimensions |
|---|
| Company |
| Accounting Unit |
| Calendar |
| Document Number |
| Location |
| Item |
| Requesting Location |
| Transaction System Code |
Inventory history cube
The Inventory History cube provides a rich variety of measures to evaluate the movement of items through inventory locations. The measures include Inventory Turn Rate, Average Inventory Value and Average Stock on Hand. The Inventory History cube uses the Inventory Usage History business class as its source with additional measures added as cube rules in OLAP Administration.
