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, worksheet functions in both Planning Analytics for Excel and TM1 Web only supported default hierarchies.
Syntax
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)
Features
Much like the SUBNM formulas in TM1 Web, cells that contain the TM1SET function display a drop-down.
TM1SET supports set editor integration in Planning Analytics Workspace websheets. You can click a TM1SET cell to open the set editor and change the set definition such as selecting a different hierarchy.
![Set editor in Planning Analytics Workspace websheets](images/tm1web_carbon_set_editor_tm1set.png)
In stand-alone TM1 Web, you cannot open the set editor from a TM1SET cell. Instead, click the cell and change your set selections by using TM1 Web’s subset editor (member drop-down selector).
![TM1 Web subset editor](images/tm1web_standalone_subset_editor.png)
A powerful feature of TM1SET is its true reference traversal capability. TM1SET’s arguments can be written inline, or they can be written in other cells and referenced in the TM1SET function. When you change a TM1SET function (for example, when you select a different hierarchy) that change applies to TM1SET’s output and to any cells that might be referenced in the formula.
For more information, see TM1SET.