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.