Data Governance

58  •  Michael Schrader

• Hierarchy Validation Data Proling: Hierarchy validation data pro-

ling validates the hierarchies for aggregations. Hierarchy dimen-

sions dene the relationships between attributes. For example,

geography has a hierarchy. In the geography dimension, we will nd

country, state, county, and city. A city will be located in a county, a

county within a state, and a state will be in a country. Oen dierent

groups want to see dierent hierarchies. For example, they might

want to see total sales being aggregated or rolled up dierently.

e organization might have had a major acquisition. e dierent

groups might want to hav ...