Building hierarchy data profiling scripts
Understanding data in hierarchies is essential to allowing users the capability to drill into the information. Profiling enables you to determine what type of hierarchies are available within the source systems. Hierarchies are generally of the following two types:
Balanced — The depth of the hierarchy is consistent across all the parents. Each child value has a single parent.
Ragged — The depth of the hierarchy varies depending on the parent.
Getting ready
Review your report mock ups and requirements from the Decomposing the reports and requirements recipe in Chapter 6, Analyzing the Requirements, and identify all the attributes which will be used in drill paths. Determine the source of record for this information using the Creating a source matrix recipe in Chapter 8, Analyzing the Sources.
For this recipe, there is a sample script which needs to be executed on a database. These scripts will outline the examples of a balanced and ragged hierarchy...
