Data entry is key to planning functionality. SAP Analytics Cloud's planning functionality makes it easy to enter data and perform calculations – from simple to robust – 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.
It is also possible to set scaling for a table in the data region styles.
When you enter numeric values, the system automatically displays the scaling factor in the cell, as seen in the following example.
Data Change Indicator
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.
Relative Value Options
X represents a number
|Relative Value Symbol
|Multiply the value by X
|Divide the value by X
|X% or -X%
|Increase or reduce the value by X percentage
|Add X to the value
|Subtract X from the value
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.