Skip to main content
Planview Customer Success Center

How to improve performance of Cognos reports?

Install the Cognos package released as GP 17.02.087.000 that by-passes security access checks to improve performance.

Changing a report to the unsecured package:
1- In Report Studio, open the report and select File > Report Package.
2- Select the ChangepointUnsecured package. Save the report.


ADDITIONAL NOTES:
- By-passing security access may also mean more data for certain reports which may in turn impact the performance as well.

- When switching to the new package, the recommended method is to create a copy of a report, and then change the copied report to use the ChangepointUnsecured package.

- Save reports into folders under their respective Changepoint or ChangepointUnsecured packages, to be able to identify them easily.

- If “copy report from clipboard” is used, double-check which package the report is using. It will use the package from the source report, which may not be the intended package.

- Deleted records are not automatically filtered out of the ChangepointUnsecured package. Most query subjects have a deleted flag that you can add to reports to filter out deleted data. To filter out deleted data in query subjects that do not have a deleted flag, add a small SQL query and join it to the query subject.

- In some cases, Cognos infers a data relationship between two query subjects by using the predefined inter-model relationships and determines its own path for joining the two, which may yield unexpected results and can make queries inefficient. To alleviate this you may need to include more fields or filters in the queries to allow Cognos to determine a relationship in the unsecured model.