|Oracle financial Analyzer User's Guide
Part No. A87522-01
Hierarchies, 3 of 4
A typical hierarchy is organized in a tree-like structure with one value at the top of the tree and multiple values branching out from the top.
The following illustration shows a typical hierarchy.
The relationships between the various values are referred to as though they were part of a family tree. Each dimension value in a hierarchy (except the top-most value) has a parent value, which is the value directly above it in the structure. The dimension values directly below a parent are called its children.
Each parent value can have any number of children. Dimension values that have the same parent are called siblings.
The following illustration shows siblings in a hierarchy.
Each child value can also have children of its own, and so on. Multiple levels of dimension values that roll up to a common value are called descendants of that value, and the value itself is known as the ancestor of the descendent values.
In a hierarchy, any dimension value that has no children is called a leaf dimension value.
Leaf dimension values are the only dimension values for which you can input data for a hierarchy. The data for each non-leaf dimension value is consolidated from its children.
This example illustrates a sample hierarchy for the Organization dimension for a fictitious company, US Global Computers. In this diagram:
The following diagram illustrates a sample hierarchy that is based on the Organization dimension.
Financial Analyzer supports multiple hierarchies. This means that you can specify any number of hierarchies for rolling up data. For example, you might want to define separate hierarchies for examining management and functional data.
In most hierarchies, any dimension value that is not the top-most can have only one parent. However, if that dimension value belongs to more than one hierarchy, it can have a different parent in each hierarchy.
In this example, there are two hierarchies, each representing a different type of computer system.
In the Selector, these would appear as separate product hierarchies that you can choose from to use in a report or worksheet:
You can create a hierarchy that has more than one top-level parent. Specifying a hierarchy with more than one top-level value can be useful when working with time-related dimensions.
In this example, 1999 and 2000 are top level parents in the Application Time hierarchy.
In the Selector, 1999 and 2000 appear as top level parents in the Application Time hierarchy. Notice that these values are siblings, and there are no higher level values in the hierarchy.