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:
- Right-click the table name and select Show Columns Only.
- 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: