Inventory Start qty
No. of units in stock of a certain product or group of products at the start of the selected time frame.
Cube Key: Inventory.inventoryStartQty
Inventory End qty
No. of units in stock of a certain product or group of products at the end of the selected time frame.
Cube Key: Inventory.inventoryEndQty
Inventory IN quantity
Number of units added to the inventory during the selected time frame.
No. of units that were added to the inventory.
Cube Key: Inventory.inventoryInQty
Inventory OUT quantity
Number of units subtracted from the inventory (during the selected time frame).
No. of units that were subtracted from the inventory.
Cube Key: Inventory.inventoryOutQty
Inventory Start Amount (COGS)
Amount of inventory value (calculated using cost of goods sold) at the start of the selected time frame.
COGS of units in stock of a certain product or group of products at the start of the selected time frame.
Cube Key: Inventory.inventoryStartCOGS
Inventory End Amount (COGS)
Inventory Value, in monetary units (using cost of goods sold), at the end of the time frame.
COGS of units in stock of a certain product or group of products at the end of the selected time frame.
Cube Key: Inventory.inventoryEndCOGS
Inventory In Amount (COGS)
Inventory Value, in monetary units (using cost of goods sold), added/bought in the selected time frame.
COGS of units that were added to the inventory.
Cube Key: Inventory.inventoryInAmount
Inventory Out Amount (COGS)
Amount of inventory value (using cost of goods sold) subtracted from inventory in the selected time frame.
COGS of units that were subtracted from the inventory.
Cube Key: Inventory.inventoryOutAmount
Inventory Average inventory (by qty)
The mean value of inventory over the defined time frame.
Average inventory using quantity
Cube Key: Inventory.averageInventoryQty
Inventory Inventory Turnover (by qty)
Inventory turnover using quantity
Cube Key: Inventory.inventoryTurnoverQty
Inventory Inventory Age (by qty)
Amount of days it takes for the product’s inventory to be sold.
Inventory age using quantity
Cube Key: Inventory.inventoryAgeQty
Inventory Average Inventory (by COGS amount)
Average amount of inventory value, using the cost of goods sold.
Average inventory using amount
Cube Key: Inventory.averageInventoryCOGS
Inventory Inventory Turnover (by COGS amount)
The amount of times the product’s inventory was replaced in the specified time frame.
Inventory turnover using cost of goods
Cube Key: Inventory.inventoryTurnoverCOGS
Inventory Inventory Age (by COGS amount)
Amount of days it takes for the product’s inventory to be sold.
Inventory Age using amount
Cube Key: Inventory.inventoryAgeCOGS
Inventory Percent of SKU's with cost from inventory
Percent of Variants with inventory cost associated.
Cube Key: Inventory.coverageCOGS
Inventory Sell through rate
Percentage of products sold, out of the starting inventory, in the selected time frame.
Percent of quantity that left the warehouse from the inventory quantity at the beginning of the date range. Formula: OUT quantity / Start quantity * 100
Cube Key: Inventory.sellThroughRate