Add a Presentation Hierarchy to a Presentation Table

Manually add a presentation hierarchy when you can't drag and drop a logical hierarchy from the logical layer to the presentation layer.

You can edit a presentation hierarchy's properties to set permissions and apply role-based access control and add data filters. If you're adding or editing a level-based hierarchy, then you can add or delete levels and modify a level's properties. See Add and Modify Presentation Hierarchy Levels.

You can select the Hide if field and write an expression to hide a presentation hierarchy. See Write an Expression to Hide a Presentation Object.

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

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Presentation Layer .
4. In the Presentation Layer pane locate and double-click the presentation table that you want to add a hierarchy to.
5. In the presentation table, click the Hierarchies tab and then click Add Hierarchy. Browse for and select the hierarchy to add it to the presentation table. Confirm that the added hierarchy is highlighted in the Hierarchies pane.
6. 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.
7. Optional: Select the Hide if field and provide an expression that controls whether the hierarchy is available to users when they create visualizations and analyses.
8. Click Save.