Cognos reports and audit logs

Report problems and their solutions

Unable to view the Cognos drill through reports in Microsoft Internet Explorer version 10

If you are using the Microsoft Internet Explorer version 10 browser, the Cognos drill through reports might not work.

Solution

Complete the following steps:

1. Enable the compatibility view.
   1. In the Microsoft Internet Explorer 10 menu, go to Tools.
   2. Select Compatibility View.
2. Add the IBM® Cognos website to the trusted sites list.
3. In the Microsoft Internet Explorer 10 menu, go to Tools > Internet Options.
4. On the Security tab, click the Trusted sites icon.
5. Click Sites.
6. In the Add this website to the zone box, add the IBM Cognos website address.
7. Click Add.
8. Click Close.

Long filter values are not shown completely on the prompt pages

See the technote at http://www-01.ibm.com/support/docview.wss?uid=swg21341018 to resolve this issue. The information in the technote also applies to IBM Cognos Business Intelligence, 10.2.1 Fix Pack 1.

Generating reports is slow and causes timeouts

You might encounter slow performance or transaction time-outs during report generation for certain reports against large data sets.

To improve performance and reduce time-outs, follow these best practices:

• When you run the large reports in PDF output format, specify the appropriate filters or parameters and avoid the usage of the default filter 'Any' that fetches all the records.
• In a large data deployment, specify the HTML output format. HTML format supports the pagination, which renders one page at a time and provides the options to move to the next pages.
• Tune the database. See the IBM Security Privileged Identity Manager Performance Tuning Guide at http://www-01.ibm.com/support/docview.wss?uid=swg27036205 for suggested indexes to set on columns in Report DB tables.

Known limitations

The Prompt Page Summary table in the IBM Cognos Report shows "--" as the parameter value when more than 1000 filters per prompt is selected.

IBM Cognos Reports provide the option for multiple selection. You can select more than one value for each parameter in the prompt page. When you select several values to filter the report, text overflow can occur and '--' is displayed instead in the Prompt Page Summary table.

Solution

Avoid selecting too many values for each parameter in the prompt page.

Disabled Shared Access Policy credentials are not displayed in the Shared Access Entitlement Definition Report

This report does not include shared access credentials that belong to a disabled Shared Access Policy.

Audit of the disconnected credentials in the IBM Cognos shared access history report

A user can disconnect the shared access credentials in the credential vault. After the credentials are disconnected, they do not have a connection with an account.

IBM Cognos shared access history report does not include the check-out and check-in history of the credentials that are not connected to an account. The shared access history report does not show the disconnected credentials for check-out and check-in audit action.

Cannot truncate the length of the text in the pie charts

An option or a property that truncates the length of the text is not available for the pie charts.

Languages that are not supported by the IBM Cognos Business Intelligence 10.2.1 Fix Pack 1

IBM Cognos Business Intelligence 10.2.1 Fix Pack 1 does not support the following languages:

• ar=Arabic
• iw=Hebrew

Note: The unsupported languages are not in the Product Language list, although they are displayed in the Content Language list in the Cognos configuration of IBM Cognos Business Intelligence Server.

Audit log problems and their solutions

Event number mismatch in the audit logs.

Update the AccessProfile custom audit log action if you are defining custom audit codes.

The event code changes are not reflected on the client.

Synchronize the AccessAgent computer with the IMS Server.