Edit data by typing values in cells

You can edit data in the cells of an Exploration View or IBM® Planning Analytics for Microsoft Excel, if you have Write access to those cells. The Exploration View interface identifies the cells that are writable by using a special cell format that is customizable.

Procedure

  1. To edit a value in a cell, click the cell and type the new value.
  2. After entering a new number, press Enter or click another cell.

    The new number displays in bold and blue, which indicates that there is a new value in this cell. You must commit the data changes to the IBM TM1® server for the change that you made to persist.

  3. To save the changes to the TM1 server, click Commit commit changes.
    After you click Commit, you have the option to preview information about the changes that will be saved to the TM1 server. You cannot undo changes after saving to the TM1 server.

Results

After committing the changes, the report displays the updated values in a normal font, indicating that you saved the changes.