3.1.2.3 Editing Business Attribute Setup

Use this procedure to edit the Hierarchy Setup. To edit the Hierarchy Setup:
  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 Setup Summary page is displayed.
  6. To view details about a Hierarchy Setup, under Actions, click Edit to edit the Hierarchy Setup details.
  7. In the page that opens, update the hierarchy details as applicable.
  8. If the Hierarchy Type is Business Intelligence, do the following:
    1. In the Business Hierarchy Nodes section, click Edit for the required node

      Note:

      You can also click Add to add the required node.
    2. Update the following fields as applicable:
      • Hierarchy Level
      • Level Name
    3. In the Level Code field, do either of the following:
      • Enter a value directly.
      • 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. Select the Entity of the fact table to which you want join the dimension entities.
        2. Select a Function depending on the database type.
        3. Select the Operator you want to use for the join condition.
        4. Click Save.
    4. In the Level Display Description field, do either of the following:
      • Enter a description.
      • 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. Select the Entity of the fact table to which you want join the dimension entities.
        2. Select a Function depending on the database type.
        3. Select the Operator you want to use for the join condition.
        4. Click Save.
  9. If the Hierarchy Type is Parent-Child, do the following:
    1. In the Parent Child Mapping section, click Edit for the required node

      Note:

      You can also click Add to add the required node.
    2. In the Parent Code field, do either of the following:
      • Enter a value directly.
      • 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. Select the Entity of the fact table to which you want join the dimension entities.
        2. Select a Function depending on the database type.
        3. Select the Operator you want to use for the join condition.
        4. Click Save.
    3. In the Child Code field, do either of the following:
      • Enter a value directly.
      • 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. Select the Entity of the fact table to which you want join the dimension entities.
        2. Select a Function depending on the database type.
        3. Select the Operator you want to use for the join condition.
        4. Click Save.
  10. Click Save.

    The hierarchy is created and displayed in the Business Attribute & Hierarchy Setup Summary page.