Notes

inventory_dataset

Denormalized inventory dataset joining snapshots to products and warehouses for reporting. · from inventory_snapshots
Columns
ColumnLabelType
snapshot_date Snapshot Date temporal
category Product Category dimension
warehouse_name Warehouse dimension
product_name Product dimension
stock_status Stock Status dimension
Metrics
MetricLabelExpressionFormat
total_units_on_hand Units On Hand SUM(quantity_on_hand) number
total_reserved_units Units Reserved SUM(quantity_reserved) number
inventory_value Inventory Value SUM(quantity_on_hand * unit_cost) currency
sku_count SKU Count COUNT(DISTINCT product_id) number