Should this request become a metric, dimension, or filter?
Triage a BI request into the right layer: metric definition, semantic dimension, or dashboard filter.
The ask The stakeholder bundled calculation, segmentation, and dashboard state into one sentence. That is normal. Your job is to unbundle it before it becomes one opaque field. Wrong placement here creates duplicate metrics and brittle dashboards. Layer triage Metric layer defines the business math. Semantic model defines reusable sliceable attributes. Dashboard filters define the current view state for a user. Shortcut to avoid Do not treat the whole sentence as one new calculated field. One request becomes three manageable design choices. If changing the clause would change the KPI meaning, it belongs upstream. If it only changes the view…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in