1. Analytical Application Infrastructure User Guide
  2. Unified Analytical Metadata
  3. References
  4. Business Hierarchy Types
  5. Large Hierarchy Type

Large Hierarchy Type

A large hierarchy refers to a hierarchy having large number of leaf levels. In order to provide an efficient and optimized hierarchy handling, a hierarchy is defined as Large in Oracle Infrastructure. A default value is set to accommodate the number of hierarchy nodes that a hierarchy can contain, for example, 100. If a hierarchy exceeds the default value specified, then the system treats it as a large hierarchy.

Note:

  • The maximum hierarchy node limit can be configured to a higher number in the FIC_HOME / CONFIG file. However, the recommended, default value, is 100.
  • A large hierarchy is possible only when you are defining a Time or BI enabled hierarchy.
  • A large hierarchy cannot be user-defined it is handled automatically by the system.