Difference between revisions of "TM1"
(→TM1-specific functionality) |
(→TM1-specific functionality) |
||
| Line 19: | Line 19: | ||
<ol> | <ol> | ||
<li>TMI subsets appear under the named sets dialogue</li> | <li>TMI subsets appear under the named sets dialogue</li> | ||
| + | |||
<li>Favourites – TM1 views are available to select from the Favourites dialogue for that connection</li> | <li>Favourites – TM1 views are available to select from the Favourites dialogue for that connection</li> | ||
| + | |||
<li>XLCubed has additional dialogues to handle ‘spreading’ capabilities</li> | <li>XLCubed has additional dialogues to handle ‘spreading’ capabilities</li> | ||
| + | </ol> | ||
Revision as of 14:19, 3 October 2019
From Version 9.2 XLCubed add-in for Excel can connect to IBM TM1 and query it using MDX using 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
This is done via XLCubed Option > 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 main points to remember:
- TMI subsets appear under the named sets dialogue
- Favourites – TM1 views are available to select from the Favourites dialogue for that connection
- XLCubed has additional dialogues to handle ‘spreading’ capabilities
