SAP

Author

Maddie Martin

Maddie Martin

Maddie Martin is a Product and Solutions Marketing Specialist at SAP Canada. She has a passion for finding creative ways to tell stories, and communicating complicated concepts in accessible ways. When she's not at her desk Maddie loves travel, trying new restaurants, and water-skiing.

Keep in touch

Subscribe for the latest news, updates, tips and more delivered right to your inbox.

Subscribe to updates

Category

Learning

Connect with us

Enjoy a familiar excel like experience when completing data entry in tables in SAP Analytics CloudTables 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. 

Multiple 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.  

 

 

 

 

 

 

 

 

 

 

 

SAP Analytics Cloud earns a top ranking from BARC

See how SAP Analytics Cloud performed in the world’s largest survey of Business Intelligence software users.