From Version 9.2 XLCubed 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.

Server Configuration

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

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

TM1-specific functionality

There are three additional areas of TM1-specific funtionality :

  1. TMI subsets can be selected within the XLCubed member selector. They appear under the named sets grouping.
  2. Favourites – TM1 views are available to select from the Favourites dialogue. These will be displayed under the relevant connection in the favourites menu once the connection has been made.
  3. TM1 has a wide range of spreading shortcuts. XLCubed supports these when entered directly on a Grid or formula cell, but also provides a Data Spread wizard on the right click menu