My first Publication Agile-Data-Warehouse-Design-eBook | Page 211

Dimensional Design Patterns for People and Organizations, Products and Services
records. Hierarchy maps always contain more records for the lowest levels because
they are repeated for all the parent levels above them. But in the case of Bond the
number is inflated by his dual roles. The easiest way to understand why this occurs
is to imagine that there are two Bonds, one directly under each of his managers.
This gives you an idea of how the hierarchy map for a large organization with
highly interconnected staff and a deep reporting structure can grow (especially if
you were to track its history).
191
A multi-valued
hierarchy map
(MV, HM) is used to
represent a multi-
parent hierarchy
MV: Multi-Valued dimension or multi-valued hierarchy map (when used in con-
junction with HM). Typically contains a weighting factor.
Figure 6-21
HR hierarchy map
Additional Multi-Valued Hierarchy Map Attributes
REPORTING STRUCTURE contains two additional attributes to cope with the
dotted-line HR relationships:
MV hierarchy maps
contain additional
rows to represent
Role Type allows the HR map to record whether a manager-to-employee relation-
ship is permanent line management (solid line) or temporary project management
(dotted line).
the multiple parent
relationships and
additional columns
to describe their
Weighting Factor allows queries to allocate an employee’s activity to his multiple
managers based on the FTE of his role. For example, a weighted revenue measure
would be defined as: Sum(Revenue × Weighting_Factor) .
Multi-parent who hierarchies are by no means limited to HR. The earlier customer
relationship hierarchy would also be multi-parent if it had to support fractional
company ownership or joint ventures. Family trees are multi-parent hierarchies!
type and value