Skip to main content

Displaying the model

Displaying the model is a good way to see the relationships between the various tables and/or views in your model.

  1. Either click the Display button in the bottom right of the Model panel.

    OR

    Select Display from the drop-down menu in the top right of the Model panel.

    The Display Model window opens in Diagram view.

    The Display model dialog, with the data model illustrated as a diagram

  2. In Diagram view, the following display options are available:

    Note:

    You can select multiple entities by clicking them while holding down the [Ctrl] keyboard button.

    • Zoom - Increase or decrease the magnification using the slider at the top right of the screen. Click the button to the right of the slider to restore the default size.
    • Search - The ability to search for entities is particularly useful in a large model. To search for an entity, type a search string in the Search box. Compose for Data Warehouses lists the names of entities that match the search string. Select the desired entity.

      Example search in upper left of diagram view

    • Drag the diagram - In addition to zooming, you can also drag the diagram by clicking the space around the diagram and dragging. This is useful for very large diagrams where zooming out would render the text unreadable. The guide at the bottom right of the dialog box shows you which part of the diagram is currently displayed.
    • Show/Hide business keys - Select/Clear the Keys check box at the top of the dialog box.
    • Show/Hide attributes - Select/Clear the Attributes check box at the top of the dialog box.
    • Change the Diagram Direction - Select one of the available options from the Direction drop-down list at the top of the dialog box.
    • Create a relationship to another entity - See Adding relationships via the Display Model dialog box.
    • Select path - To highlight the path to which an entity belongs, either hover your mouse cursor over the entity or right-click the entity and select Select Path.
    • Select neighbors - Right-click an entity and select this option to highlight the entity’s neighbors.
    • Select all - Right-click an entity and select this option to highlight all entities in the model.
    • Edit - Either double-click the entity or right-click an entity and select the Edit option to edit the entity’s attributes.
    • Lineage - Right-click an entity and select this option to show/hide the entity’s lineage. For more information on lineages, see Lineage and impact analysis.
    • Hide this node - Right-click an entity and select this option to show/hide the entity. To show the entity, click the Hidden Nodes box in the left of the dialog box.
    • Hide selected nodes - Right-click an entity and select this option to show/hide selected entities. To show the hidden entities, click the Hidden Nodes box in the left of the dialog box.
    • Invert selection - Right-click an entity and select this option to highlight all entities except the selected entity.
    • Hide non-selected nodes - Right-click an entity and select this option to show/hide non-selected entities. To show the hidden entities, click the Hidden Nodes box in the left of the dialog box.
  3. To switch to Tree view, click the Tree View tab. In Tree view, the following display options are available:

    • Expand/Collapse - Click the arrow to the left of a table to see its columns or related tables. To show or hide all sub-tables and table columns, click the Expand All/Collapse All buttons at the top of the Tree View tab.
    • Lineage - To see an entity’s lineage, hover your mouse over a table or column and then click the link icon that appears to its right.

      Lineage link icon visible to the right of a column name in the tree view

  4. To search for a specific entity, enter a part of the entity’s name in the Search box.

    Entities that match the search string will be highlighted.