Setting up sample audit reports

To set up sample audit reports you need to create a data server connection to the Audit database, and import the samples deployment.

Procedure

  1. Create a logging database named Audit in a supported database system, such as Db2®, Oracle, or Microsoft SQL Server.

    For more information, see the guidelines for creating a logging database in the IBM Cognos Analytics Installation and Configuration Guide.

  2. In IBM® Cognos® Configuration, configure the Audit database.
    1. Under Environment, right-click Logging.
    2. Select New resource > Destination. Type the name Audit, and choose the type Database. Click OK.
    3. Right-click Audit, and select New resource > Database. Type the name Audit again, and choose the database type that was used to create your logging database in step 1.
    4. Specify the required properties for the Audit database, including the user ID and password, and test the database.
    5. Save the configuration, and re-start IBM Cognos service.
  3. Create a data source connection to the Audit database.
    1. Go to Manage > Administration console.
    2. On the Configuration tab, select Data Source Connections.
    3. Follow the wizard to create a new data source connection. The database and data source must be named Audit.
  4. Copy the samples deployment file IBM_Cognos_Audit.zip from the location where it was installed to the ca_install_location/deployment directory.
    Tip: By default, the IBM_Cognos_Audit.zip file is installed to the installation_location/samples/Audit_samples directory.
  5. Import the audit deployment IBM_Cognos_Audit.zip file.
    1. Go to Manage > Administration console.
    2. On the Configuration tab, select Content Administration.
    3. Follow the import wizard to import IBM_Cognos_Audit.zip. Ensure that the Samples_Audit folder is selected in one of the steps.
    After the import, the sample audit reports are available in the Team content > Samples_Audit > Audit folder.
  6. Test the audit reports.
    1. Check if audit reporting is enabled. To enable audit reporting, the logging level for selected IBM Cognos services must be set to Basic (auditing enabled) or Request. If the logging level is set to Minimal, auditing is disabled. For more information, see the topic about setting up audit reporting in the IBM Cognos Analytics Administration and Security Guide.
    2. Run some of your organization reports or dashboards from Team content. This step is needed to collect some data that the sample audit reports can use when you run them for the first time.
    3. Run the sample audit reports from Team content > Samples_Audit > Audit, and view their contents.