Setting Up Audit Reporting

Before you can create audit reports or use the sample audit reports that come with IBM® Cognos® software, you must set up audit reporting.

Procedure

  1. Direct log messages to a database.

    Set up a logging database and configure log messages to be sent to the database. For information about configuring log messages, see the IBM Cognos Business Intelligence Installation and Configuration Guide.

    Important: The logging database must be separate from the Content Store database.
  2. Set the logging level for audit reports.

    For audit reporting, set the logging level to Basic (auditing enabled) or Request. If you set the logging level to Minimum, auditing is disabled. Use Full logging and Trace levels only for detailed troubleshooting purposes, under the guidance of Customer Support. They may significantly degrade server performance.

    For more information about logging levels, see Set Logging Levels.

  3. Enable native query logging. For more information, see Native Query Logging.