Updating Connection URLs

If the URL of an IBM® system changes, you can edit the information to use the new URL.

Editing the URL updates the saved connection for the IBM Planning Analytics for Microsoft Excel application, but not the connections for the reports in the workbook. To update the connections for Exploration Views or Quick Reports in an open workbook, use the Update connection utility. For more information, see Update connections using the Update connection utility.

About this task

When running this command, the name of the data source or package remains the same. You can use this command to change only one server, such as a test server to another server, such as a production server. You choose the URLs from the list of systems that you enter in the IBM connections section of the Options dialog box.

Procedure

  1. Open the file you want to update.
  2. On the IBM Planning Analytics tab, click Options Options icon.
    The Options dialog box is displayed.
  3. In the navigation pane, click IBM.
  4. Select the system you want to update and click Edit.
  5. Select the Datasource type.
  6. Type the new Connection URL in the field.
  7. Update the Friendly name field as required.
  8. Test the connection and click save.
  9. Click OK.

Results

The open IBM enabled files are searched and the server information is updated.