Dimension Compatibility
Not Every Dimension Can Safely Slice Every Metric
A Dimension Lock Wall for Customer Revenue. Region, Plan, and Industry are keys that fit the lock. User Role does not — inserting it changes base grain and duplicates rows. The wall refuses to open and names the Bridge Model or pre-aggregation required.
Metric lock · Customer Revenue
Wall surveyed — Open Compatibility Reason on User Role for the bridge model fix.
- Test A Dimension — check if a key can safely slice this metric
- Open Compatibility Reason — see exactly why a dimension fails
- Add Bridge Model — resolve a many-to-one relationship safely
- Restrict Unsafe Slice — block a dimension from a metric in BI tools
- Save Compatibility Rules — persist the wall for this metric
A Correct Query Can Still Produce The Wrong Metric.
Illuminate The True Grain Of Every Metric.
GrainLux is the AI Semantic Data Reliability Layer between your warehouse and every model, metric, and dashboard built on top of it — grain-aware, metric-native, explainable, and deterministic.