The changes made to values in cube cells in the In-Memory (OLAP) DB can be tracked by enabling the Audit feature for specific cubes. The storing of audit information is disabled by default. To enable it, the audit parameter must be added to the configuration file palo.ini. It is a switch parameter and has no additional arguments. Additionally, audit storage has to be enabled for every database cube for which it should be kept.
- At least W rights are required for the rights objects “dimension element” and “audit” to make changes to the audit settings. See Rights Objects in Jedox for more information.
- You cannot enable the parameter “audit” together with the parameter “crypt” In the file palo.ini. The data storage for audit information currently cannot be encrypted (meaning it would contain readable data information), which would conflict with the purpose of the “crypt” option.
Enabling audit storage for a database cube
The Audit manager can be found in Jedox Administration. Click on Settings in the Audit toolbar to select the cubes and the period for which the audit information should be stored. Note that you may need to click on the menu icon in the toolbar if your screen is small:
The audit keeps track of all individual cell changes: it logs the cell path, time of change, user, new value, and operation (splashing, copy, etc.). When disabling audit for a cube, all stored audit data for this cube is deleted.
Note that auditing only stores the change for the cell that was directly modified. It will not store indirect changes, such as when a cell is affected by a splashing operation on a parent element. Also, mass data changes as performed by Jedox Integrator will not be logged. By contrast, cell changes initiated by a Supervision Server cube worker script will be logged in the audit information, provided that these are not using the API for mass data change themselves. The audit log would store the user who had made the initial change also for the changes made by the SVS script.
You can display the stored audit information in two ways:
- Audit manager (see below)
- Drill History in Jedox views (right click on a corresponding cell).
In the Audit toolbar, you can set the filter for the audit data you want to see. Click on Apply Filtering to see the selected audit data.
Most of the columns are self explanatory. The DETAILS column on the right indicates the mode of the cell change. The table below explains the results:
|mode=0||Base cell writeback|