1. Building Semantic Models in Oracle Analytics Cloud
  2. Create and Build Your Model
  3. Build a Semantic Model's Logical Layer
  4. Open the Logical Diagram

Open the Logical Diagram

The logical diagram provides a graphic view of the logical table or tables that you selected. From the diagram you can view a logical table's columns, show joins, and add, modify, or delete logical joins.

The logical model diagram doesn't display other logical objects, such as business models, dimensions, or hierarchies.

You can select what you want the diagram to contain:

  • Selected Tables Only - Displays only the selected logical tables. Logical joins display only if they exist between the tables that you selected.

  • Selected Tables and Direct Joins - Displays the selected logical tables and any logical tables that join to the table or tables that you selected.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Logical Layer.
  4. Locate and right-click a table, or use Shift click or Ctrl click to select more than one table and right-click.
  5. Hover over Show Logical Diagram and click Selected Tables Only or Selected Tables and Direct Joins.
  6. In the physical diagram, double-click a table to view a list of column names with column type icons. Double-click the list to collapse it.
  7. Right-click a table and select Show Direct Joins to display the tables that join to the table.
  8. Double-click a join to access the Edit Join dialog box to view or modify the join's properties.
  9. Click a table to select it and on the right side of the table, grab its handle and drag to another table to create a logical join and specify its properties.