Audit in Jedox

Return to Jedox Audit Overview

As a method to ensure data credibility, Jedox Audit helps you understand which changes have led to the current state of your data model. With Jedox Audit, you can track manual changes made to cube data. That means any data entry done by a user can be logged and stored for up to 365 days. Furthermore, it is possible to track structural changes. This includes the changes within a database (creation and deletion of a dimension or a cube), changes within a dimension (creation and deletion of elements, moving elements, etc.), and changes in business rules (creation and deletion of rules, modifications of rules).

Settings or other information are often stored in system cubes and can be audited as well. For example, database settings like default access rights can be found in a cube called "#_CONFIGURATION". Changes done to those settings can therefore be viewed as part of the audit trail.

Here is the complete list of OLAP commands that can be audited:

  • CELL_REPLACE_NUMERIC (Entry in numeric cube cell)

  • CELL_REPLACE_STRING (Entry in string cube cell)

  • CELL_REPLACE_NUMERIC_BULK (Numeric bulk writeback via palo_setdata_bulk)

  • CELL_REPLACE_STRING_BULK (String bulk writeback via palo_setdata_bulk)

  • CUBE_CLEAR (Clearing cube values entirely or partially)

  • COPY_VALUES ("copy" splashing in cube cell)

  • COPY_LIKE_VALUES ("like" splashing in cube cell)

  • COPY_AS_VALUES ("as" splashing in cube cell)

  • CELL_GOALSEEK ("Reallocate" in planning assistant / "palo_goal_seek" PHP API function)

  • RULE_CREATE (Creating a new rule)

  • RULE_MODIFY (Modify a rule)

  • RULE_DESTROY (Deleting a rule)

  • RULE_MOVE (Moving the position of a rule)

  • DIMENSION_CREATE (Creating a new dimension)

  • DIMENSION_DESTROY (Deleting a dimension)

  • DIMENSION_RENAME (Changing the name of a dimension)

  • DIMENSION_CLEAR (Deleting an element including its descendants)

  • CUBE_CREATE (Creating a new cube)

  • CUBE_DESTROY (Deleting a cube)

  • CUBE_CHANGE_LAYOUT (Changing the layout of a cube, i.e. adding/removing/moving dimensions)

  • CUBE_RENAME (Changing the name of a cube)

  • HOLD_CREATE (Setting a hold for a cube cell)

  • HOLD_DESTROY (Removing a hold from a cube cell)

  • ELEMENT_INVOKE (Former ELEMENT_CREATE => creating a new element)

  • ELEMENT_DESTROY (Deleting an element)

  • ELEMENT_RENAME (Changing the name of an element)

  • ELEMENT_MOVE (Changing the position of an element)

  • ELEMENT_APPEND (Adding/Changing children to/of an element)

  • ELEMENT_REPLACE (Changing the type of an element, e.g. from numeric to consolidated)

Next step: Activating Audit in Jedox

Related articles:

Updated November 11, 2024