Creating a Planning Analytics as a Service data server connection

You can connect to a Planning Analytics as a Service data server.

Procedure

  1. Go to the Create data server connection wizard.
    • Click the Open menu icon Open menu icon.
    • Click New > Data server.
  2. In the field Name, type a unique name for the connection.
  3. Select the IBM Planning Analytics as a Service data server type from the list of supported types and click Next.
  4. If you are connecting to Planning Analytics as a Service on IBM Cloud Pak for Data:
    1. Under Connection details, enter the database host as follows: :

      https://<planning-analytics-host>/api/v0/tm1/<serverName>

    2. Under Authentication method, select either:
      • Use an external namespace and select your namespace used by IBM Cloud Pak for Data.

        or

      • Use signon.

        To use this method, log into IBM Cloud Pak for Data and generate an API key. The same user name will be your Cognos user ID and the password will be your API key.

    3. Click Test to verify that the data server connection works, and then click Save to save the new data server connection.
      Tip: If a message starting with XTR-ERR-0005 appears, see XTR-ERR-0005 error when testing IBM Planning Analytics data source from IBM Cognos Analytics 12.0.3 (https://www.ibm.com/support/pages/node/7144464) for information about resolving the issue.
  5. If you are connecting to Planning Analytics as a Service on other platforms,such as AWS:
    1. Under Connection details, enter the database host as follows:
      https://<planning-analytics-host>/api/<tenantID>/v0/tm1/<serverName>
      Note: You can find the tenantID in the URL after you log into IBM Planning Analytics as a Service.
    2. Under Authentication method, select either:
      • Use signon

        or

      • Prompt for the user ID and password.

        Enter the apikey word as the user ID and the password is the API key that is generated from within IBM Planning Analytics as a Service.

    3. Click Test to verify that the data server connection works, and then click Save to save the new data server connection.
      Tip: If a message starting with XTR-ERR-0005 appears, see XTR-ERR-0005 error when testing IBM Planning Analytics data source from IBM Cognos Analytics 12.0.3 (https://www.ibm.com/support/pages/node/7144464) for information about resolving the issue.
Results
The new IBM Planning Analytics as a Service data server appears in the Data server connections pane.