Deleting Values in a Table
In SAP Analytics Cloud, you can delete values in a table to remove them from a public or private version of a planning model, or to simulate changes to embedded data.
You can delete data values from a table by selecting a cell or multiple cells and then pressing Delete. You are able to delete from public versions and private versions. Pasting an unbooked cell to a booked cell (from a table or an external spreadsheet) will also delete the underlying data values.
How Deleting Values Works
When you choose to delete a value, keep the following information in mind:
-
Delete removes the value instead of setting the cell value to zero.
-
When publishing, the deletions are propagated to the public version for those values that were already present in the private version when it was created.
-
You can use the history feature to undo and redo delete actions.
-
In Mass Data Entry mode, delete followed by copy & paste operates as a simple value change, not a redistribution.
-
For first or last accounts, delete removes all data in the time span of the node (for example, the whole year).
Restrictions
There are some things that you need to be aware of when deleting values:
-
Deleting values may affect performance for queries and planning. For more information, refer to Performance Considerations.
-
You can't use delete in assignee versions of input schedules or in BPC write-back models.
-
Delete doesn't work for formula accounts with inverse formulas.
-
Delete doesn’t work in tables that have cell locks. Unlock all cells in your table before deleting values.