Viewing Specific Information

To view the list of fields in a table if they are hidden:

  • In the upper right hand corner of the table, click OR right-click the table name and select Show All Fields.
    Note

    Linking from another table to the fact table is not possible: links always need to be created from the fact table (which corresponds to the fact table having a left join to the other table).

To view only the columns from a table that is already being used in the data model:

  1. Right-click the table name and select Show Columns Only.
  2. After a join has been created, right-click it and change the join properties.
    Note

    By default, joins are created as left joins.

    Right-click the join to change it to an inner join or to delete it.

To display the SQL statement used in the Data Model:

  • Click the SQL Statement icon on the toolbar. A pop-up window is displayed. You can copy the SQL statement if needed.

To filter columns in the fields table, you can use the Search function:

  1. In the Search bar on the left, enter the field you are looking for.

  2. Click Save if you wish to save the table view with this search.