There are additional areas of TM1-specific funtionality.

  1. TMI subsets can be selected within the Anaplan XL member selector. They appear under the named sets grouping.
  2. Favorites – TM1 views are available to select from the Favorites dialog. These will be 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 choose between 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. OK applies the changes, and Cancel aborts them.

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")