Semantic layer

Query governed metrics and dimensions. Access control reaches the semantic layer too: a measure whose source attribute is MNPI or PII simply cannot be computed by a role that lacks clearance.

Cube

Measure

Group by

Role

Trader — clearance up to confidential · PII ✗ · MNPI ✓ — Front office. Sees market-sensitive (MNPI) figures; no PII.

SELECT trade_date, sum(notional) FROM trade GROUP BY trade_date

2026-06-161,095,680
2026-06-15244,775
2026-06-17230,520
2026-06-1824,775

Computed over the synthetic sample · enforcement identical to the API and warehouse.