IPA (Interactive Performance Assistance) and ZIPI (Zero Impact Performance Indicator) are available in all IBM Cognos Analytics 11.0.13 versions. With IBM Cognos Analytics 11.0.13 FP4, you can use IPA/ZIPI to write to an encrypted data source.
- An explicit location for the IPA database can be specified by creating a data source called ZIPI.
- If there is no ZIPI data source, but there is a Notification database defined in IBM Cognos Configuration it is used.
- If there is no ZIPI data source or Notification database defined, the Content Store database is used.
The IPA data only appears in HTML reports. There is no method to get this interactive information in .pdf or other output types.
2. Import the IPA_Package deployment. The IPA_Package.zip needs to exist in the deployment directory of the active Content Manager. (See the bottom of this document for a link to the deployment.)
3. The import of the deployment publishes a package and reports to "Team Content > ZIPI".
4. Create a data source called IPADATA that points to the IPA database (shown in Step 1). This data source is used for the IPA reports.
8. Within a couple minutes, the following tables get created in the database previously specified.
2. The report can be run from the main Run options or the Run Page by selecting the Pages tab and then Right clicking a page then clicking Run Page.
The benefit of the Run Page over the main Run options is that the option to drill through to detailed IPA data is only currently available on the first run page. Paging down deactivates this drill through ability.
3. After the report page runs, the execution times are shown for the relevant objects on the page as well as the total execution time for the page. Mousing over the information (i) icon gives a breakdown of query execution time vs rendering time.
The links become active and clicking them drills to a detail report that further breaks down the report timing.
Clicking the Execution time drills to the ReportServerTimeBreakdown report.
Analyzing the Execution Time
3. The target reports available.
4. The processTime report breaks down the execution time into its main processes.
5. Drilling down on a process shows its underlying services.
6. Drilling down on a service shows its underlying actions.
Note: How to enable SSL connections in IBM Cognos Configuration
19 July 2021