Committing changed data from a personal workspace or sandbox to base

The Commit command or button merges all of the changed data values in your personal workspace or sandbox to the base data. You cannot use the undo command to undo a commit action.

Note: When you have multiple sandboxes and commit one of them to base, the new base values are automatically applied to all the unchanged cells in your other sandboxes. If you entered new data values in any other sandbox, those data values remain and do not show the new values that were committed to the base data.

The following figure shows an example of committing sandbox values to the base data when you are working with multiple sandboxes. In this figure, the new values in Sandbox 3 are committed to base data and then the new base values are applied to all the unchanged cells in the other sandboxes. The figure shows how sandbox cells that contain changed data are not updated.

diagram showing how multiple sandboxes interact.

Procedure

Depending on which TM1® component you are using:
  • In TM1 Web and Server Explorer / Architect, click the Sandbox list and select Commit Sandbox.
  • In TM1 Perspectives/Microsoft Excel, click the Commit Sandbox button Commit Sandbox icon on the Sandbox toolbar.

TM1 performs the following actions:

  • The changed data values in the current sandbox are saved to the base data.
  • The cell coloring for any changed data in the current sandbox is cleared and set to black.
  • The new base data values are applied to all the unchanged cells in your other sandboxes.

    When you have multiple sandboxes, you can use the menu bar pull-down options to create, delete and select the different sandboxes available to you. Some interfaces offer a Delete Sandbox button.