Setting up audit log reporting for Cognos Analysis for Microsoft Excel

You can set up audit log reporting to identify which reports are run from Cognos Analysis For Microsoft Excel.

Procedure

  1. Set up logging. See Setting up Logging.
  2. Set up a database for the audit log. See "Configuring a Repository for Log Messages" in the IBM Cognos Business Intelligence Installation and Configuration Guide and Data Schema for Log Messages.

Example

For example, to identify and report on Cognos Analysis for Excel requests:
  1. Use Framework Manager to create a package including COGIPF_Parameter_Name and COGIPF_Parameter_Value. Publish the package to the portal
  2. Create a report using that package including parameters from the COGIPF_Parameter and COGIPF_RunReport tables. Enable CrossJoin for the query and save the report.
  3. After performing some actions in Cognos Analysis for Excel, run the saved report. You will see it has COGNOSOFFICEFRAMEWORK entries for the requester parameter.
Parent topic: Administering Microsoft Office Documents