Connecting to Planning Analytics data servers from CA on Demand

Applies to version 11.1.7 and subsequent versions unless specifically overridden. From an IBM Cognos Analytics on Demand environment, you can connect to a TM1 data server that is in a Planning Analytics on Cloud Hosted environment.

Note: There are two types of Planning Analytics on Cloud: Hosted and On Demand. Only the Hosted Planning Analytics on Cloud environment is supported if you are connecting from Cognos Analytics on Demand.

To do so, create a data server connection, selecting IBM Planning Analytics as the data server type.

Important: This topic describes how to set the authentication method in Cognos Analytics to match the authentication method used in the TM1 data server. However, the TM1 database administrator must also secure the TM1 server using the dedicated Cognos Analytics instance that is associated with the users' Planning Analytics tenant. Contact the TM1 database administrator to determine the URL of the TM1 database server.

Users and groups are separately managed and configured in Cognos Analytics on Demand and Planning Analytics on Cloud. Therefore, security groups in Cognos Analytics on Demand cannot be used in Planning Analytics on Cloud.

The Cognos Analytics on Demand user ID must be included in the Planning Analytics on Cloud subscription.

For more information, see Planning Analytics security overview.

Procedure

  1. Click Manage > Data server connections.
  2. In the Data server connections pane, click the Add data server icon new data server icon .
  3. Select IBM Planning Analytics from the list of supported types.
  4. In the field New data server connection, type a unique name for the connection.
  5. Under Authentication method, select Integrated security, where the TM1 database is configured for Integrated Security mode 4 or 5.
  6. Beside Connections details, click Edit and enter the connection details:
    1. In the TM1 database host field, enter the URL of the TM1 database server, for example: 
      https://prodsupport.planning-analytics.ibmcloud.com/api/v0/tm1/GO_New_Stores
    2. In the HTTP port number field, enter -2
    3. Leave the Use SSL check box unchecked.
  7. Click Test Test icon to ensure the connection is valid.
  8. Click Save.