New TM1SET function supports alternate hierarchies

TM1SET, a new worksheet function that supports alternate hierarchies, is now available in IBM® Planning Analytics for Microsoft Excel and IBM Planning Analytics TM1® Web. Until now, functions in both Planning Analytics for Excel and TM1 Web only supported default hierarchies.

Important: To use the TM1SET function, you must be on at least Planning Analytics for Microsoft Excel 2.0.81, TM1 Web 2.0.81, and IBM Planning Analytics Workspace 2.0.80.

You can add TM1SET to new and existing reports for greater customization. For example, you can add TM1SETs into the slicer area of Quick Reports or Dynamic Reports. You can even replace existing SUBNMs in Custom Reports with TM1SET functions.

A dynamic and versatile function, the TM1SET takes nine arguments, and you can configure the function’s output.

=@TM1SET(Host, Server, Dimension, Hierarchy, Set Expression, Selected Member, Session Set Id, Active Alias, Output type)

TM1SET also supports set editor integration. Double-click a TM1SET cell to open the set editor and modify the TM1SET function. You can also edit the TM1SET formula manually.

Note: To open the set editor with a double-click from a TM1SET cell, that cell must be in a tracked area named range (apply tm2\\_tracked). For more information, see TM1SET.

Another powerful feature of the TM1SET is its reference traversal capability in both Planning Analytics for Excel and TM1 Web. TM1SET’s arguments can be written inline, or they can be written in other cells and referenced in the TM1SET function. When you change the TM1SET in the set editor (for example, when you select a different hierarchy) that change applies to the output values and to any cells that might be referenced in the TM1SET formula.

For more information, see TM1SET.