Compare sandboxes

You can create personal scenarios in sandboxes that you can view side by side so that you can compare and calculate the difference between scenarios.

Sandboxes are personal to the creator. If the compare sandbox function is enabled, and the Use Sandbox capability is granted by your administrator, you can use sandboxes as a virtual dimension in a view. An individual sandbox is treated as member in the virtual dimension.

You can see the Sandboxes dimension in the Dimensions branch in the tree, and as a tile that you can drag from the benchbench in a view. You can drag the Sandboxes dimension onto a row, column, or onto the context area.
Sandboxes dimension in the tree

Example

For example, suppose you have two sandboxes, Best case, and Worst case. You can display these two sandboxes next to each other in nested columns, and then calculate the variance, as shown in the following example.

Table showing best case the sandbox next to the worst case sandbox and a variance calculation.

You can compare sandboxes by doing the following steps:

  1. Drag the Sandboxes tile from bench, and nest it with the Month tile on columns.
    Tip: You can also drag Sandboxes from the Dimensions branch in the tree.
  2. Right-click, or tap and hold on the Base member column heading and select Hide.
  3. Create a variance calculation by selecting the Best case and Worst case column headers, right-clicking, and select Create calculation.
  4. Name the calculation, choose Best case - Worst case, and click OK.

Limitations

You cannot spread data across multiple sandboxes.

You also cannot add members to the Sandboxes dimension. Sandboxes are added to the dimension when you create a new sandbox.

You can create unnamed sets for the sandbox dimension, and apply them to the current view, but you can't name and save sets.

Enabling the sandbox compare function

To enable the sandbox compare function, ask your TM1 administrator to add EnableSandboxDimension=T to the tm1s.cfg file of the TM1 database that you are using. For more information, see EnableSandboxDimension on IBM Knowledge Center.