3.13.1.2.3.3 Hierarchy Match

Similar to Static Table Drivers, Lookup Table Drivers allow you to match leaf values from a Source instrument table with any leaf member that belongs to a hierarchical rollup point of that leaf.

For example, you might have sets of driver statistics that vary by region where regions are defined as rollup points in an Organizational Unit hierarchy.

If you had North, South, East, and West regions, you could store your lookup data in four regional sets. If there were 300 cost centers in the West region, by using Hierarchy Match functionality, you avoid the repetition of 299 sets of otherwise identical driver data for the West region. Hierarchy matching supports only Key Processing dimensions.