Synchronizing Essbase with Imported Data

If changes are made in the external data source, you must synchronize the metadata and data withPerformance Scorecard in these circumstances:

  To synchronize Performance Scorecard with the external data source:

  1. In Performance Scorecard, select Administration, and then Data Source List.

    The Data Source List is displayed.

  2. Select the external data source which needs to be synchronized with changes in Performance Scorecard.

  3. Depending on the type of changes made in the external data source, synchronize Performance Scorecard:

    • Click Metadata Synchronize if the metadata in the structure of the database has been modified. For example, if the corporate structure is realigned, the new organizational structure must be reflected in the database outline.

    • Click Data Synchronize if the data in the database has been modified. For example, if your budget value is increased, click Data Synchronize to show the new values on the imported measure template.

If changes have been made to the both metadata and data, perform both operations. If no matching external data source is found, an error message is displayed. Review the external data source settings, and try again.

A confirmation message is displayed when the synchronization is complete.