analytics: the record-currency refusal advises grouping a parent-path amount by '<parent>.<code>', which the same door then refuses again #33403

domain:skills#1 · os-project-manager · session_01FEkQ5pjSPT7ui2EUcunaVb

Filing gate: ① (named landing point, found by reading main during the contract review of PR #33394, card #32392, comment 6882437074, follow-up 1)

What is wrong. assertRecordCurrencyAggregatesGrouped in packages/services/service-analytics/src/cube-record-currency-door.ts (near L95–L121) refuses a sum/avg/min/max over a currencyMode: 'record' amount and offers, as one remedy, "add the dimension over '' to the query". For an amount whose currencyField is the two-segment parent path ('<master_detail field>.<parent code field>', e.g. invoice.currency_code), codeField is that dotted path, so the advice reads 'invoice.currency_code' (pinned by __tests__/home-amount-consolidated-measure.test.ts near L382). But the satisfied check compares d.column === codeField, and a dimension resolves to its last segment (currency_code), so the dotted code field never matches: following the advice is refused again. The engine door agrees no grouping is admitted for a parent-path amount (packages/objectql/src/record-currency-aggregate-door.ts, pinned by record-currency-guards.test.ts), so the second remedy should not be offered for this form at all.

Reach. Read in the code on main; not yet measured through /analytics. First step: run a cube query with sum over a parent-path amount, then again with the advised dimension, and confirm the second refusal.

Business reason. A dashboard author or agent following the refusal's own prescription loops: the platform tells them to add a grouping it then refuses. North star item 4 wants every refusal to carry a working prescription.

Reader who acts. The lane that owns service-analytics (triage routes): drop or replace the grouping remedy when codeField is a path, keep the homeAmount remedy, and pin both with a test.

Dedupe. repo:objectstack-ai/objectstack is:issue cube-record-currency-door: 42 hits, none open about this message (open hits are #32392 and seat posts). … currency_code dimension last segment: 3 hits, none open.

Suggested-grade: p3 (a refusal with a wrong second prescription; the first prescription works).

Generated by Claude Code