Supervision Server Event Handlers

image_pdfimage_print

Supervision Server uses event handlers to react to users interacting with the In-Memory DB. Examples of these event handlers can be found in the sample_scripts folder located at <Install_path>\svs\. This folder contains many sample scripts that can be used for a variety of tasks. The parameters of each event handler can also be found in these files, as well as additional information to define more specific reactions. For example, the name of the saved database can be passed to OnDatabaseSaved such that the script is able to branch accordingly.

Note: by default, the SVS event handler is disabled when running a cube load in Integrator.

The event handlers are described below.

OnUserLogin
Executed by the System Supervisor when a user tries to login. Only used when option “workerlogin information” is passed to the Jedox OLAP Server.

OnUserLogout
Executed by the System Supervisor when a user tries to logout.Only used if some option of type “workerlogin” is passed to Jedox OLAP Server.

OnUserAuthenticate
Executed by the System Supervisor when a user tries to login. Only used with “workerlogin authentication “option. Returns true or false depending on the success of the authentication.

OnUserAuthorize
Executed by the System Supervisor when a user tries to login. Only used with “workerlogin authorization “option. Return true or false as well as the set of groups the user belongs to (inside the array passed to the handler).

OnServerShutdown
Executed by all workers when Jedox OLAP server stops execution.

OnTermination
Called by all workers when Jedox OLAP server sends a termination signal. This happens, for example, when a cube has no set of hot cells and the Jedox OLAP server terminates cube supervision.

OnDatabaseSaved
Executed by the System Supervisor when a database is saved.

InitCubeWorker
Within the function InitCubeWorker, one set (cube slice) of cells can be defined for every cube, and each of these “hot areas” can be linked to its own callback PHP function that will be executed if a user changes the value of a cell inside the set. This callback function, which is called in the InitCubeWorker event definition as part of the WatchCubeArea method and is defined in the script, has predefined parameters that will be automatically filled by the Supervision Server when the event is triggered at runtime (for an example, see the SalesCube function in the sep.inc.on_cell_change.php sample script). These parameters are described below:

Parameter Description
$database Name of the database where the writeback occurs
$cube Name of the cube where the writeback occurs
$areaid Internal ID of the area for which the cube worker was defined
$sid2 Session ID of the user doing the writeback (can be used to retrieve the user name)
$coordinates Array of element names, defining the cell where the writeback occurs
$value Value being written
$splashMode Splash mode used during the writeback: values can be 0 (no splashing), 1 (default splashing with “#”), 2 (add splashing with “!!”), or 3 (set splashing with “!”)
$additive Parameter specifying whether the “add” parameter was used (1) or not used (0) in the writeback. Note that this parameter is always 0 for manual writebacks from Jedox Excel Add-in or Jedox Web.

InitCubeWorker can also be used to define a specific callback for copy events, using the WatchCubeAreaCopy method. For an example, see sep.inc.on_cell_copy.php. The parameters for this event definition are similar to those above, with the following differences:

$coordinatesFrom Array with the source coordinates of the copy operation
$coordinatesTo Array with the source coordinates of the copy operation
$function Parameter specifying which function was used for the “predict” command. Currently, the only supported function is linear regression (1).
$areaPredict Source area for the “predict” command (if any)
$useRules Parameter specifying whether the “withrules” keyword was used (1) or not used (0) in the writeback

OnDrillthroughExt
OnDrillthroughExt is a proprietary event used for interaction with Jedox Integrator. Jedox Integrator must be installed with drill-through functionality of the SVS, and the statement enable-drillthrough must be written into the palo.ini.

This event uses the parameter Session ID ($sid): OnDrillThroughExt($database, $cube, $mode, $arg, $sid)

InitDimensionWorker
Within the function InitDimensionWorker, you can define one or several dimensions to be watched for changes. Each of these watched dimensions can then be linked back to its own callback PHP function that will be executed if the defined event (creation, renaming, or deletion of an element) occurs.

Note: the trigger to Supervision Server is merely to notify it that the event has occurred. The action itself will be executed in the OLAP server.

image_pdfimage_print