If Check Integrity indicates that the database of your universe connection has been modified, you can use Refresh Structure to update the contents of the Structure pane. Refresh Structure can modify the universe structure to comply with changes in the database as follows:
| If | Then Designer does the following |
|---|---|
| Columns were added to tables | Adds the columns to the corresponding tables in the universe. |
| Columns were removed from tables | Displays a warning message indicating the columns and associated joins you should delete. |
| Tables were removed from the database | Displays a warning message indicating the tables and associated joins you should delete. |
| Tables were renamed in the database | Displays a message that says it no longer recognizes the corresponding tables in the universe. You should rename these tables to match those in the database. If the names still do not match, Designer returns a message stating that the renamed tables do not exist in the database. |
| No changes were made to the database | Displays a message informing you that no update is needed. |
To refresh the universe structure:
· Select
View > Refresh Structure.
A message box appears informing you of a change in the database, or that
no update is needed if no changes have been made.