1. Analytical Application Infrastructure User Guide
  2. Unified Analytical Metadata
  3. References
  4. Business Hierarchy Types
  5. Regular Hierarchy
  6. Parent Child Hierarchy

Parent Child Hierarchy

When you have selected Regular - Parent Child Hierarchy option, do the following:

  1. Click the View Attributes button in the Entity field. The Entity and Attribute window is displayed.
    • You can either search for a specific Entity using the Search field or select the checkbox adjacent to the required Entity in the Available Entities list. The list of defined Attributes for the selected entity is displayed Available Attributes list.
    • You can either search for a specific Attribute using the Search field or select the checkbox adjacent to the required Attribute in the Available Attributes list.
    • Click Save. The selected Entity and Attribute is displayed in the Add Business Hierarchy window.

      Note:

      Ensure that the values present in Attribute column do not contain new line characters. Because the hierarchy node descriptions in the hierarchy browser are considered as text fields and do not permit new line characters.
  2. The Business Hierarchy section displays the pre-defined nodes such as Child code, Parent Code, Description, Storage Type, Consolidation Type, and Formula. You can modify the node values by doing the following:
    • Click the Edit button from the Business Hierarchy tool bar. The Edit Hierarchy Values window is displayed.
    • Click the View Attributes button adjacent to the required node field and define the expression in the Expression window. For more information, see Create Expression.
    • Click Save. The node details are displayed in Add Business Hierarchy window.
  3. Click Save in the Add Business Hierarchy window and save the details.

Note:

  • When the size of the hierarchy is large, Parent Child Hierarchy can be configured to be treated as a Business Intelligence enabled hierarchy for optimal performance. The hierarchy behaves like a non-Business Intelligence hierarchy till a limit of the number of nodes is reached. This limit (default value is 2048) which decides a hierarchy as BI or non-BI is configurable and can be given a value considering the system and JVM capabilities.
  • Creating Parent Child Hierarchy with Roll-up Option - It is possible to roll up the values of child nodes in Parent child hierarchy to the parent level. If the parent node itself has some value and the child nodes of it also have associated values, it is possible for the value of the parent node to be displayed as the sum of its value and child values.

    For using the Roll-up option, it is required to specify parameters in the Consolidation Type for the node field. Based on the column that is specified in the Consolidation Type field, the values of the child nodes will be rolled up i.e. added to the parent level. This can then be viewed using the OBIEE reporting server. However, when Consolidation type is not selected, then it is referred to as Parent Child Hierarchy with Rollup option.