You can edit data in leaf cells if you have Write access to those cells.
Leaf cells appear with a white background in the Cube Viewer.
If you are working in a sandbox, you can save the sandbox to store your values across sessions.
For more information, see Writeback modes and sandboxes.
Procedure
-
Edit a value in a white cell in one of the following ways.
- Edit the value
- Double-click a value in a white cell. TM1 Web displays
the current value in the cell with a border, a white background, and a blinking cursor. This
indicates that you can selectively edit the existing value by using the left and right arrow keys on
your keyboard to position the cursor within the value. You can also use the Backspace and Delete
keys to remove single numbers from the value.
- Replace the value
- Single-click a value in a white cell. TM1 Web displays the
current value in the cell as highlighted, which indicates that the cell is in Edit mode. You can
then type directly over the existing value in the cell, replacing it completely. You can also paste
values into cells.
Note:
- When you paste a negative value, the value must be formatted with a leading minus sign, such as
-1234.
- When you paste values with decimal places, you must be aware of the local browser settings for
formatting. In some cases, pasting values with cell formatting for decimal places is not supported.
If you use a number format in Excel, a number such as
123456.7
is copied as 123 456,7
with a trailing space. A number parser might interpret the trailing space as a thousand separator in
certain locales (for example, fr
) and might not allow the value to be pasted.
- Pasting values that are enclosed in parentheses is not supported in TM1 Web.
- Pick a new date value
- If a cell is formatted as a date, double-click the cell then use the calendar to select a new
date. Double-clicking also puts the cell in edit mode, so you can alternatively enter a new date
directly in the cell.
Formatting is determined by the format attributes that are applied to the
elements that identify a cell. For more information, see Element Attributes in TM1
Developer documentation.
-
After you enter a new value, press Enter or click another cell.
Note: When you enter a number into a consolidated cell in the web Cube Viewer, the value
is proportionally spread across the consolidation. For example, if you enter
50 into a consolidated cell in the web cube viewer, the value is spread
across the consolidation as if you had entered spreading code of 50p. This behavior occurs only in
the web Cube Viewer. In Architect/Server Explorer Cube Viewer and in slices from Perspectives and
websheets, you must enter the spreading code to get the value to spread proportionally across the
consolidated cells.
The new number displays in bold and italic, which indicates there is a new value in this cell.
You must submit the view to the server for the change you made to persist.
Important: If you log out of TM1 Web without
submitting the new value, the change you made is lost.
- Review your data changes.
If you are working in a sandbox, data changes display in a different color until the changes are
committed.
- Click Commit
on
the Cube Viewer toolbar to save the changes to the server.
The Cube Viewer displays the updated values. All values appear in a normal font, indicating that
you saved the changes.