Add and Modify Presentation Hierarchy Levels

You can manually add a level to a level-based presentation hierarchy. Presentation levels are displayed within hierarchical columns in the corresponding subject area end users access to create visualization and analyses.

You can specify one or more display columns for a level. Display columns define the columns used for display for that level on drill-down. For example, if two columns called Name and ID are at the same level, you can choose to display Name because it's more user-friendly. The presentation level's available display columns are based on which key columns for the corresponding logical level have the Use for display option selected.

Semantic Modeler doesn't create an alias when you change a presentation hierarchy level's name. If you need to track a hierarchy level's previous names, then Oracle recommends that you use the Alternative Names field to create and manage alternative names for the hierarchy level. For more information about alternative names, see About Alternative Names for Presentation Objects.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Presentation Layer Presentation layer icon.
  4. In the Presentation Layer pane expand the presentation table that contains the hierarchy you want to work with, and from the table's list locate and double-click the hierarchy.
  5. In the presentation table's page, click the Hierarchies tab and then in the Hierarchies pane locate the hierarchy you want to work with.
  6. Optional: To add a level to the hierarchy, click Level to select and add a level. You can select and add a level from any available hierarchy.
  7. Optional: To modify an existing level, click the level to display its properties pane.
  8. Optional: In the Description field, enter a description that is displayed when a user creating visualizations or analyses hovers over the table in the subject area.
  9. Optional: In the Logical Level field, click Select and select a logical level for the presentation level.
  10. In the Display Columns field, select the columns to use for display for the hierarchy level on drill-down.
  11. Click Save.