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 header 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 (marked in red above), even though you entered 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.
PALO.DATA and PALO.DATAC formulas automatically detect whether the target cell in the cube is a string. If it is, the String Editor popup is displayed on double click, allowing you to see the entire content of the cell and make changes to it.
The String Editor is available when you use Paste Data or Paste View, as well as when you manually type or copy the formula and copy the cell.
When entering large numbers, you can use shortcuts for quicker and more intuitive data entry:
- k = thousands, e.g. the input of "5k" is equivalent to entering "5000".
- m = millions, e.g. entering "3m" is equivalent to entering "3000000".
- g = billions, e.g. entering "2g" is equivalent to entering "2000000000".
See Shortcuts and splashing Overview for more information.
Entering a value in multiple data cells
You can add a value to multiple cells with special key combinations. To add a value to a continuous range of cells, select one cell, then hold the SHIFT key and select the last cell. To add a value to various, noncontinuous cells, select one cell, then hold the CONTROL key and select additional cells. Once the cells have been selected, enter the value and press the ENTER key. The value will then be applied to all of the selected cells. You can also use input via a data validation list or the copy command. It is not required to press CONTROL + ENTER, as with Microsoft Excel. This functionality can be applied only in User Mode and in published Reports, and is not available in Designer Mode and in Jedox Excel Add-in.
Related articles:
Updated November 4, 2024