Defining Audit Events

After you create the audit table on the database, define the events that track each data model.

Note:

To log audit data, provide Interactive Reporting users the database authority to execute each SQL statement you define for auditing events. For example, all users must have insert or update authority to the Audit table that you create.

  To define audit events:

  1. Download an existing data model that you want to track from the document repository, or create a new data model in the Content frame using the Table catalog.

    For more information about creating a new data model, see Building a Data Model.

  2. In the Query section, select DataModel , then Data Model Options.

    The Data Model Options dialog box is displayed.

  3. Select the Auditing tab to display the Auditing tab.

    The Auditing tab displays the events you can audit.

  4. Click Define to define the way in which an event is audited.

    The SQL For Event dialog box is displayed.

  5. Enter one or more SQL statements to update the audit table when the event occurs, and click OK.

    A check mark is displayed next to the event on the Auditing tab in the Data Model Options dialog box. You can use the check box to enable or disable the event definition without entering the SQL statement again. You can also click Define again at any time to modify the SQL statement.

  6. Select File, then Save to Repository to save the audited data model to the document repository.

    The SQL statement is sent to the database whenever a user triggers the event while using the data model.