Enjoy a familiar excel like experience when completing data entry in tables in SAP Analytics Cloud. Tables based on planning models have a number of features that can be used to quickly and easily enter and update values.
Working with Cells
Adjust cell values by clicking the desired cell and simply type in the new value. By changing certain cell values, other values that are dependent on that value will also change. For example, if you changed the quantity sold of Athletic Shirts, this would also change the value of revenue and profit.
Values will not change however, if they have been locked. Lock cells by right clicking and selecting Lock Cells.
Another way to change values, is to type in relative values of a cell. For example, if I want to add 10% to my sales on caps, I can simply type in +10% and immediately see the changes.
Similarly, I can do this if I want to divide by a certain amount, multiply, subtract, or add. You can also copy and paste or cut and paste using the regular keyboard shortcuts. Additionally, use allocation features to spread, distribute and assign values.
You may want to enter multiple values in one session, instead of processing each cell update as you go. To do this, select Mass Data Entry from your More Actions menu.
Next, change all values you would like to adjust. You can adjust booked or unbooked cells. Once you have completed your mass data entry, choose to Process Data to complete your changes, or choose Exit Mass Data Entry to leave without saving.
To learn more details about all the different data entry options, check out this in depth resource.