As of Jedox 7.1, OLAP Server offers users the ability to define holds on cube cells. When a hold is defined, the value in the cell is fixed and will not be affected by writeback operations. However, values can still be splashed on cells above a held cell in the hierarchy; in that case, the value changes are applied only on sibling elements of the held element. Holds obtain a continuous ID number after their chronological creation. Every user attempting writeback is affected by holds, and they carry over across sessions in the server. Multiple holds can be set on the same cell. Holds can be set from reports in both Jedox Web and Excel.
Cell value holds can be defined using the context menu of a PALO.DATA* cell (unlocked). They can also be defined in the Planning Assistant.
Once defined, holds do not react to changes in dimension hierarchy. If the child element of an element that was held is moved into a different branch of a dimension hierarchy, that element will still be held. The hold on the consolidated element has to be reset (removed and set again) in this scenario. Similarly, if an element is added as a child to a held, consolidated element, it will at first not be held.
If an element that was explicitly held is deleted, the hold is removed. If the element was only part of a hold with multiple other elements from the same dimension, the hold is kept; only the deleted element is removed in this case.
String cells can not be held.
Holds are also accessible from Jedox Integrator via Groovy scripting.
Using the Hold command to create a hold
For this example, create the following view:
Next, splash 100,000,000 in cell C7 and define holds in C11 and in E7 using the Create Hold command from the context menu:
To display the holds that affect a PALO.DATA* cell, open the Hold Manager with the context menu for the corresponding cell. The example above has the following results:
- Cell D8 isn’t affected by any hold.
- Cell C8 is only affected by one hold: this cell has children in “East” region. Splashing another value in C8 will not change the value in E8.
- Cell E11 is affected by both defined holds:
The Hold Manager displays the cell coordinates, the creation time, and the creator of the hold.
Splashing another value in cell E11 will result in the following message:
The message only shows the first hold that blocks the writeback operation, even if there are several holds that would block it.
To delete holds, select them in the Hold Manager and click Release.
After the selection of a cube in Modeler, you can also start the Hold Manager in the Advanced section of the cube properties.