Several BI teams rebuild their own versions of Date and Geography dimensions with conflicting hierarchies. What modeling-plus-metadata practice should the enterprise adopt?
Select an answer to reveal the explanation.
Short Explanation
Conformed dimensions are the shared Legos everyone builds reports from—same Date, same Geography, same rules. Document them as governed semantic assets so teams stop carving private clones. Conflicting hierarchies make enterprise totals disagree.
Full Explanation
Conformed dimensions are shared semantic assets that align analytics across BI teams. Documenting them in governed metadata—definitions, hierarchies, and owners—bridges data modeling and analytic semantics. Private clones create incompatible rollups; hiding definitions or banning dimensional modeling does not solve reuse. Cataloged conformed dimensions are the standard remedy.