Using Basic Manual Planning

Data entry is key to planning functionality. SAP Analytics Cloud's planning functionality makes it easy to enter data, perform calculations on that data, and write it back to your database.

In the following example, you can see some of the key data entry features in SAP Analytics Cloud:

• Adjust plan by +/-, %, or absolute value.
• Shortcut scaling characters to simplify input.
• Automatic highlights of impacted and related cells.
• Messages with number of records changed.

Data tables in stories are automatically scaled to thousands or millions, depending on the data. The scaling factor is displayed on the upper left of the data table. When you enter numeric values, for example 10 as you can see in the following example, the system automatically displays the scaling factor in the cell.

It is also possible to set scaling for a table in the data region styles.

You can see in the following example that when there's a data change an asterisk appears in the affected column. The asterisk and the yellow markup mean that the data entry function is being used but not published.

Data entries can be tested before you save and publish them.

You can type an absolute value in a cell or type a relative value, such as *2 or +500 to perform simple mathematical calculations on existing data. For example, if the data value in a cell is 100, and you type *2 in the cell, the value will change to 200.

You can also include the scale when typing a value. For example, if you want to enter the value 1,000,000, you can simply type 1M, and SAP Analytics Cloud will interpret that entry as 1,000,000.