Creating a Planning Analytics as a Service data server connection
You can connect to a Planning Analytics as a Service data server.
Procedure
- Go to the Create data server connection wizard.
- Click the Open menu icon
. - Click .
- Click the Open menu icon
- In the field Name, type a unique name for the connection.
- Select the IBM Planning Analytics as a Service data server type from the list of supported types and click Next.
- If you are connecting to Planning Analytics as a Service on IBM Cloud Pak for Data:
- Under Connection details, enter the database host as follows: :
https://<planning-analytics-host>/api/v0/tm1/<serverName> - 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.
- Use an external namespace and select your namespace used by IBM Cloud Pak
for Data.
- 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.
- Under Connection details, enter the database host as follows: :
- If you are connecting to Planning Analytics as a Service on other platforms,such as AWS:
- 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. - 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.
- Use signon
- 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.
- Under Connection details, enter the database host as follows:
- Results
- The new IBM Planning Analytics as a Service data server appears in the Data server connections pane.