There are various ways to get values into a cube. Entering data manually is time consuming, but the process is easy to understand.
In a report, the values are delivered to the Excel cells by PALO.DATA functions. These functions are not only for displaying but also for writing back values to the database.
Make sure that there are no parent elements in the row and column titles or in the head dimensions (range D3:G3) of your report. For data entry only, base elements must be used.
The result of entering the value 175 is displayed below:
Note that the formula is retained although you enter a value. The entered value is written directly to the database.
There is no change in the Excel workbook, and therefore it is not possible to undo an action in Excel. When typing in a new value, previous values in this cube cell are overwritten. To delete a value, you have to re-enter a zero.
To re-enter values, a user needs at least writing access (W). To delete a value, a user needs at least deleting access (D). Thus, it is possible that a user is able to overwrite data with other values but is not allowed to write back a zero.