Add a Hierarchy

Add a hierarchy to a dimension table in an existing subject area.

  1. Sign in to your service.
  2. In Oracle NetSuite Analytics Warehouse Console, click Semantic Model Extensions under Application Administration.
  3. On the Semantic Model Extensions page, click User Extensions.
    You see the main and existing customization branches.
  4. In the User Extensions region, under Customization Branches, click a branch to open the Branch page.
  5. On the Branch page, click Add Step.
  6. In Add Step, select Add a Hierarchy.
    You see the wizard sequence to add a hierarchy.
  7. In step 1 of the wizard, enter a name for your customization step, for example, Add Region Hierarchy and add a brief description.
  8. Select the subject area, the folder of the dimension table, and the dimension table to which you want to add a hierarchy.
    You see the existing hierarchies and the hierarchy levels in the selected dimension. If there aren’t any hierarchies, then you see a message informing you that there are no hierarchies in the selected dimension.
  9. Click Next.
  10. In step 2 of the wizard, assemble the product hierarchy using the attributes from this dimension table with these instructions:
    1. Enter a hierarchy name. For example, Region Hierarchy.
    2. Select, drag, and drop available data elements into the Selected Data elements pane to design a hierarchy that you want. You can add multiple levels in your hierarchy by right-clicking at a level and selecting Add Child or Add ‘n’ Child Levels. For example, your Region Hierarchy can have Region Total at Level 1, Region at Level 2, Country at Level 3, State at Level 4, and City at Level 5.
    3. In the Selected Data Elements pane, click a level to update its primary key and set its display attribute in the Properties pane.
  11. Click Next.
  12. Optional: In step 3 of the wizard, select additional subject areas to include the new hierarchy.
  13. Click Finish.
    You see a message that your step is being applied to the customization branch. After it's applied, you see the new customization step in the customization branch. You can now apply the customization branch to the main branch or edit it to add more steps.