Update server and package designations to make a server available

After changing the gateway alias or switching from a test to a production environment you receive the following error message advising you that the server is not available and that the Cognos® gateway is unable to connect to the IBM® Cognos Analytics server.

SERVER_NOT_AVAILABLE: The Cognos gateway is unable to connect to the Cognos Analytics server. The server may be unavailable or the gateway may not be correctly configured.

This is probably caused by a change in the gateway URI.

Update the server and package designation in a workbook to switch from a test to a production environment or to access information from a different set of financial data, such as a submission.

Procedure

  1. Optionally, you can update information in cell references.
    • From the worksheet you want to update, open the new server and package.
    • From the Information folder, drag the updated server and package metadata to the server or package cell.
  2. Optionally, you can update information in embedded text.
    • Use the Microsoft Excel search and replace function to update embedded references in the text of cell formulas.