There are additional areas of TM1-specific funtionality.

  1. TMI subsets are selected in the Anaplan XL member selector. They appear under the named sets grouping.
  2. Favorites: Select TM1 views from the Favorites dialog. These are displayed under the relevant connection in the favorites menu once the connection has been made.
  3. TM1 has a wide range of spreading shortcuts. Anaplan XL supports these when entered directly on a Grid or formula cell, but also provides a Data Spread wizard on the right-click menu.
    1. Method options:
      • Proportional Spread
      • Equal Spread
      • Repeat 
      • Clear
      • Percent Change
      • Straight Line
      • Growth %
      • Relative Proportional Spread
      • Relative Percent Adjustment
      • Repeat Leaves
      • Equal Spread Leaves

Users enter a value for the spread and select the Replace and Adjust actions. The directional arrows impact the spread entry. The Spread command field displays the formula (P%+>20) reflecting the chosen parameters. Select OK to apply the changes.

Run Turbo Integrator processes - These can be triggered using an XL3Link formula with special parameters.

ParameterDescription
LinkTypeThis is the normal link type parameter, but it must be set to 7 which indicates "Execte Script".
"XL3Connection"Named parameter that indicates the connection to run the script on.
"XL3ScriptName"Named parameter that is the script to execute.
Script parametersName/Value pairs of parameters to pass to the script.

Example:

XL3Link("", "Run Script", 7, "XL3Connection", 1, "XL3ScriptName", "ProcessMyThings", "MyParameter", "123")