Manually entering data into a consolidated cell is not possible. This limitation prevents you from unintentionally entering values into a cell containing consolidated data, thereby corrupting the data. After all, consolidated data values are the sum of base element data values.
However, to indicate that you are entering a value intentionally, with the purpose of splitting the value among the subsequent base elements, you can enter a command (such as #, !, “copy”, and “like”) followed by a value. This process of entering data into consolidated cells is called splashing.
The screen shot below shows cells from the cube “Market”, a newly created and empty cube, with the exception of the entry in C7 (175):
There are three months as column titles and different products as row titles.
Although this looks like an ordinary view, the following message appears when you try to enter a number into a cell (e.g. D7):
The reason for this message is that these cells are not only defined by one element of the dimension “Months” and one of the dimension “Products”; they are also influenced by the head dimensions in the cell range D3:G3. Because of the element “Europe”, these are consolidated cells, and writing into a consolidated cell is not possible. These cells don’t hold a single, physically stored value, but instead are calculated in memory as result of the underlying base element data.
Nevertheless, by splashing values into such cells, the values can be delivered to the underlying base cells without being stored there.
Notes on splashing:
- Backup your database regularly! Using these splashing techniques allows you to play with the data in very useful ways, i.e., “What would happen if you change the data by x%?” But data splashing can result in data corruption, as when you no longer know the values of your original data and it cannot be retrieved again. There is a simple solution: create a backup of the database before you play with your data.
- As of Jedox Version 5.1, the Splashing Wizard is also implemented in Jedox Excel Add-in. This wizard simplifies the entries for “General splashing”, “Copy/Like/Predict splashing”, and “Goalseek splashing” (Predict Splashing Wizard is only available in the Jedox Excel Add-in).