2.1.6 Adding Business Attribute & Hierarchy Setup

The Business Attribute & Hierarchy Setup enables users to create, manage, and browse hierarchical structures such as Business Intelligence or Parent Child hierarchies within the STSA workspace.

Hierarchies define relationships among business entities and are essential when creating portfolios or configuring analytical rules. The integrated Business Attribute Configuration browser provides a visual interface to explore, search, and select hierarchies, ensuring consistency across Portfolio, Scenario, and Variable modules.

To create Business Attribute and Hierarchy:

  1. Login to STSA.
    The Workspace Summary page is displayed.
  2. In the Workspace Summary page, click the Sandbox tab, launch the required workspace.
  3. Click the Context Menu representing the user name and then click Configuration Manager.
  4. Click Configure in the Business Attribute Configuration section.
    The Business Attribute Configuration page is displayed.
  5. Click Configure in the Business Attribute & Hierarchy Setup section.

    The Business Attribute & Hierarchy Setup Summary page is displayed.

    Note:

    • This page displays business attributes and hierarchies created through the Create New option and the hierarchies created in the OFSAA Setup.
    • For hierarchies created through OFSAA Setup, you can only view them; you cannot copy, edit, or delete these hierarchies.
  6. Click Create New.
  7. In the Hierarchy Details page that opens, do the following:
    1. In the Name field, enter a clear and descriptive name for the hierarchy.
    2. In the Description field, enter a brief summary describing the purpose or use of the hierarchy.
    3. In the Hierarchy Type field, select one of the following options from the drop-down list:
      • Business Intelligence
      • Parent-child
    4. In the Attribute Table Name field, select the required table from the drop-down list.
  8. If you select type as Business Intelligence, do the following
    1. In the Business Hierarchy Nodes field, click Add.
    2. In the page that opens, For each hierarchy level, provide the following details:
      1. In the Hierarchy Level field, enter the unique identifier for the level.
      2. In the Level Name field, enter the display name for a given hierarchy level.
      3. In the Level Code field, do either of the following:
        • Enter the a value that determines how the system identifies members of this level.
        • Click the Open Expression Editor icon and do the following:

          When the Expression Editor is opened, the system displays the selected Attribute Table Name by default along with all columns available in that table.

          1. In the Expression Input field, enter an expression that determines the Level Code.

            Expressions to define the column name should be represented in <table_name>.<column_name> format.

          2. Click Save.
      4. In the Level Display Description field, do either of the following:
        • Enter a description for the members belonging to this level.
        • Click the Open Expression Editor icon and do the following:

          When the Expression Editor is opened, the system displays the selected Attribute Table Name by default along with all columns available in that table.

          1. In the Expression Input field, enter an expression that determines the Level display description.

            Expressions to define the column name should be represented in <table_name>.<column_name> format.

          2. Click Save.
    3. Click Save to add the new node to the hierarchy.

    Note:

    • You can add multiple nodes.
    • You may also insert nodes at any position as needed to match the hierarchy structure.
  9. If you select Parent Child, do the following
    1. In the Parent Child Mapping section, click Edit.
    2. In the page that opens, enter or update the required mapping details:
      1. In the Parent Code field, do either of the following:
        • Enter a expression representing the parent.
        • Click the Open Expression Editor icon and do the following:

          When the Expression Editor is opened, the system displays the selected Attribute Table Name by default along with all columns available in that table.

          1. In the Expression Input field, enter an expression that determines the Parent Code.

            Expressions to define the column name should be represented in <table_name>.<column_name> format.

          2. Click Save.
      2. In the Child Code field, do either of the following:
        • Enter a expression representing the child.
        • Click the Open Expression Editor icon and do the following:

          When the Expression Editor is opened, the system displays the selected Attribute Table Name by default along with all columns available in that table.

          1. In the Expression Input field, enter an expression that determines the Child code.

            Expressions to define the column name should be represented in <table_name>.<column_name> format.

          2. Click Save.
      3. In the Description field, do either of the following:
        • Enter the description expression/column for the Parent Child.
        • Click the Open Expression Editor icon and do the following:

          When the Expression Editor is opened, the system displays the selected Attribute Table Name by default along with all columns available in that table.

          1. In the Expression Input field, enter an expression that determines the Description.

            Expressions to define the column name should be represented in <table_name>.<column_name> format.

          2. Click Save.
  10. Click Save to apply the mapping.

    Note:

    After you create a hierarchy—either in this page or in OFSAA Setup—you must activate it before it can be used in other STSA components. To activate the hierarchy:
    1. Navigate to Business Attribute Configuration > Attribute Activation & Hierarchy Selection, and click Create New.
    2. In the Dimension Configuration section, expand the required DIM table to view the newly created hierarchy.
    3. Select the hierarchy and click Save to complete the activation.

      The hierarchy becomes available for selection across dependent objects such as variables, portfolios, pathways, and other dimension-based configurations.