What is a governed dimension?
A governed dimension is a master data list that has one owner, explicit access rules, and a recorded history of every change. Region, Product, Department, Cost Centre. Any list your organisation uses across more than one system becomes a governed dimension when one approved copy owns the values and every other system reads from it.
Most teams keep these lists in spreadsheets. A governed dimension moves the list somewhere with rules around it, so the values stay the same everywhere they appear.
Start free and govern your first dimension.
What makes a dimension governed
Three things separate a governed dimension from a list in a spreadsheet.
- One list owns the values, so there is no second copy to drift.
- Access is explicit. Viewers read the list, contributors propose changes, and admins approve them.
- Every change leaves a trail. You can see what changed, who approved it, and when.
A spreadsheet gives you none of these. Anyone with the link can edit it, two people can keep different copies, and no one can tell you why a value changed last March.
Why a governed dimension matters for reporting
Ungoverned lists drift, and drifting lists break reports. One system spells it "EMEA". Another keeps "Emea". A report joins on the value and silently drops the rows that do not match. The analyst spends the morning of the close lining up four versions of Region by hand.
A governed dimension removes the drift at the source. Every report, dashboard, and pipeline reads the same approved values, so the numbers reconcile the first time.
See how governance works in Wusool.
A governed dimension in practice
Picture the Region list. You create the approved values once, by import or by hand. You set who can edit it and who signs off on changes. You lock it when the reporting period opens so nothing moves mid-quarter. Every downstream report points at that list.
When a new market opens, one person adds it once and it shows up everywhere the next time reports run. When someone asks why a number moved, the change history answers in seconds.
The list under your reports stays still while you work, and you can trust it.
Govern your first dimension
Wusool gives BI and data teams one governed home for the lists their reports depend on. Define your dimensions once, govern who can change them, and keep every report aligned.
Get started free. For the wider picture, read how BI teams replace dimension spreadsheets with governed master data.