Anaplan XL add-in for Excel can connect to IBM TM1 and query it using MDX using the REST API. 

TM1 connections can be used to create Grids, Small Multiple Charts and Slicers in the same way as Analysis Services connections.

Client configuration

Type the TM1 Admin Server address in the connection box to get the list of available databases.

This'll normally be:

  • http://<adminserver>:5895
  • https://<adminserver>:5898 (for https connections)

The port used can be changed by the server administrator. If these don't work, you could check the connection details. [1]

Server configuration

Depending on how your TM1 authentication is configured, connection settings and defaults can be configured via Anaplan XL Options > Data Options > TM1 Options:

    • Check SSL certificates
    • Use Server Name when connecting
    • DefaultCAMNamespace
    • Register TM1 function
    • Convert TM1 Workbooks