Pivots and measures API

Saved pivots

POST /pivots   { "name": "demand_by_family", "rows": "hier.product_planning@family", "columns": "cal.planning@month",
                 "measures": ["actual_qty", "plan_qty", "variance_pct"], "filters": {"plant": ["1210"]}, "hierarchy_version": "auto" }
GET  /pivots/demand_by_family?as_of=2026-09-30&transpose=false        -- rows as JSON or CSV

Calculated measures

measure variance_pct = (actual_qty - plan_qty) / nullif(plan_qty, 0)
measure invoiced_share = sap_revenue / nullif(sf_bookings, 0)      -- both resolved through xref

Data entry and disaggregation

POST /pivots/demand_by_family/entries
{ "version": "plan-2026-Q4", "node": "EMEA", "column": "2026-Q4", "measure": "plan_qty", "value": 12000,
  "method": "proportional", "weights": "actual_qty@2025-Q4", "locks": ["Nordics"] }
-- returns the split per child and month; writes governed values with the method and weights; ledger entries per cell