Link to the main article: Jedox Supervision Server (SVS)
The installation of Jedox Supervision Server includes several sample PHP scripts that demonstrate the various capabilities of monitoring databases with Supervision Server, and reacting to certain events.
|In the folder <Install_path>\svs\sample_scripts
you will find the PHP sample scripts shown to the right:
Note: in the case that you have customized Version 7.0 scripts, please check them if adaptions must be done for newer Jedox Versions.
Reacting to cell changes: “cube worker” example
Add the following entry to the palo.ini:
worker "<Install_path>\svs\SupervisionServer.exe" use-cube-worker
In the file “sep.inc.php”, replace the entry “sep.inc.default.php” or “sep.inc.drill_through.php” with “sep.inc.on_cell_change.php” and restart the JedoxSuiteMolapService.
In the sample, which we use later, “Turnover” is calculated as product of “Units” and “Price Per Unit”. For this we add the element “Price Per Unit” in the attribute dimension “#_Products_” in Modeler:
Then we enter 500 as “Price per Unit” for the element “Desktop L” in the corresponding Jedox view:
Now we open the file <Install_path>\svs\sample_scripts\sample_on_cell_change.xls:If you change the value in cell B11, you will see that the value in D11 also changes automatically. This change is performed by the Supervision Server: it monitors the “Units” cube slice for changes, and when a value is changed in that area of the cube, SVS automatically calculates a “Turnover” value in the PHP script, setting this value in the corresponding cube cell.
If you try to change the value in D11, you will receive the following error message from the SVS:For the “Turnover” cube slice, the Supervision Server reacts to any input by returning this (configurable) error message to the user. When the SVS is turned off, you can change the value in D11 without any message.