Refreshing Tables

  To refresh data source connection tables:

1. Perform an action:

   • Right-click one or more tables in a data source connection.

     Use the Shift or Ctrl keys to select multiple tables.

   • Right-click a data source connection name.

2. Select Refresh from the shortcut menu.

   Tables that are out of sync with the physical data source are flagged in the Refresh dialog box.

   Note:

   If the selected tables or connection are already in sync with the physical data source, a message is displayed and no refresh action is performed.

3. In the Refresh dialog box, perform these steps:

   1. Under Changed Tables, select a table.

   2. Under Changed Columns of Table, review the information:

      • Column Name

      • State—Whether the column is new, updated, and so on

      • Data Type

      • Change Details

   3. After reviewing the changes for each table listed under Changed Tables, select the tables that you want to refresh, and then click Refresh.

      Note:

      Tables cannot be refreshed if outdated columns are still used in Essbase Studio metadata elements. You must remove such elements before you refresh the tables. The Refresh dialog box displays the tables that cannot be refreshed, along with the affected metadata elements.

   4. If any joins will become invalid after the refresh, review them in the Refresh dialog box.

   5. Select the tables that contain joins to be deleted, and click OK.

      All joins associated with a table are deleted. You cannot select joins individually.

      Alternatively, select the Select All Joins check box.

      Note:

      You must explicitly select the tables containing the joins to be deleted. They are not deleted automatically during a refresh.

4. Perform the steps in Adding Joins to complete the process.