OneCloud

IBM Planning Analytics

The OneCloud Planning Analytics BizApp for TM1 connects and automates your cloud and on-premise versions of TM1. Integration is available for a range of applications, including relational databases, Workday, NetSuite, Namely, Salesforce and many other widely used performance management and business intelligence applications. In addition to our core integration functions to bi-directionally exchange data, the OneCloud Planning Analytics BizApp provides specific automation functionality to support core TM1 functions such as automating TM1 Chores & Processes and querying TM1 log files. As always self-service automation is available for end-users to support an environment of streamlined self-sufficiency for enhanced productivity.

For documentation on all available commands, see the IBM Planning Analytics Command Reference.

Connection Setup

OneCloud connects to both on-premise and cloud deployments of IBM Planning Analytics (TM1) via the REST API. The OneCloud BizApp for IBM Planning Analytics is compatible with all versions of IBM Planning Analytics 10.2 or greater. If you require support for earlier versions of IBM Planning Analytics (TM1), please contact support@onecloud.io.

To automate functionality within your Planning Analytics environment from OneCloud, you'll need to navigate to the connection manager to create a connection.

From here, choose IBM Planning Analytics TM1 from the service drop-down and select the appropriate Runner. Now, enter values for the following fields:

Input
Type
Detail

TM1 API Url

TextField

The full URL to your TM1 application
(i.e. https://<Your TM1 URL here>/api/v1)

Username

TextField

Your TM1 User name

Password

TextField

Your TM1 password

Token

TextField

Your token for authentication
(Only for Windows Integrated Authentication)

Authentication Type

Dropdown
Field

LDAP Namespace

TextField

This is the LDAP namespace for Cognos
Authentication Manager (CAM) authentication.

IBM Planning Analytics Service Account with API Access

The username used for this connection is typically a service account and must be enabled for API access. Please check with your Planning Analytics administrator to learn more.

Connection Example

The following is an example of a working connection. Please substitute your own values.