Create a Presentation Table

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

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

Semantic Modeler doesn't create an alias when you change a presentation table's name. If you need to track a table's previous names, then Oracle recommends that you use the Alternative Names field to create and manage alternative names for the table. 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 click Create Create icon and then click Create Presentation Table.
  5. In Create Presentation Table, go to the Name field and enter a presentation table name.
  6. Go to Subject Area and select which subject area to add the table to.
  7. Click OK.
  8. In the presentation table, click General to set the presentation table's general properties.
  9. 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.
  10. Optional: In the Alternative Names field, enter an alternative name for the presentation table.
  11. Optional: Select the Hide if field and provide an expression that controls whether the presentation table is available to users when they create visualizations and analyses.
  12. Click Save.