IBM Support

Using IPPA in IBM Cognos Analytics 11.2

How To


Summary

IPPA (In Product Performance Assistant) is an internal IBM Cognos Analytics tool that assists Report and Dashboard Authors requiring detailed performance analysis.

IPPA is largely based on IPA (Interactive Performance Assistant) from previous versions.

Note: To get the optimal experience, use Google Chrome or Edge Chromium.

Steps

IPPA_Deployment_and_Gantt_Chart.zip

1a.) Start by downloading the attached .zip file and extracting it. Copy the downloaded IPPA_PACKAGE.zip file to the <Cognos Install>\deployment folder of the Content Manager installation and the customvis.catalog.gantt.zip to your local computer.

1b.) Enable IPPA in the Advanced Settings in IBM Cognos Administration -> System –> Set Properties.

image-20210531101428-1

1c.) Select the Edit… link to launch the Advanced Settings.

image-20210531101428-2

1d.) Add in a Parameter called [DISP.zipi.IPAEnabled] and set it to [true]. Click OK twice to save the parameter.

Note: A restart is not required.

image-20210531101453-3

Note: 

  1. An explicit location for the IPPA database can be specified by creating a datasource called ZIPI.
  2. If there is no ZIPI datasource, the Notification database defined in IBM Cognos Configuration is used.
  3. If there is no ZIPI datasource or Notification database defined, the Content Store database is used.

To change the location of a current database, use the following steps.

  1. Unset the advanced parameter by setting it to [false] and confirming the change. (Select OK twice)
  2. Make the appropriate change (Example: Create a ZIPI datasource.)
  3. Reset the parameter back to True.

Oracle, DB2, and SQL Server are supported database types.

2a.) Create a datasource that points to your Content Store named IPADATA. The IPADATA data source is used for the reports supplied in the IPPA_PACKAGE deployment.

image-20210531101544-4

2b.) Import the IPPA_PACKAGE deployment to generate a folder called ZIPI under Team Content. It contains a package and reports that display IPPA data.

image-20210531101544-5

2c.) To import the Gantt chart, go to IBM Cognos Administration -> Library -> Import Visualizations

image-20210531101544-6

2d.) Click Browse… select the customvis.catalog.gantt.zip file and click Import.

image-20210531101544-7

3a.) To gather the performance data for reports. Go to Authoring by editing a report.  Select the chevron next to the run button and select ‘Show run options’.

image-20210531101609-8

3b.) Enable the ‘Include performance details’ option and click OK.

image-20210531101609-9

3c.) Select Run HTML

image-20210531101609-10

3d.) If you want to run a specific page of the report and go to Report > Pages, select the page and then Run HTML.

image-20210531101609-11

3e.) Running the report with IPPA enabled generates and populate the following tables. (One time only.)

IPA_ACTIVITY_ACTIONS

IPA_BUCKETS

IPA_COGDATES

IPA_COGTIMES

IPA_CUBE_REQ

IPA_LOGRECORDS

IPA_RECORDETAILS

IPA_REPORT_REQ

IPA_SERVERS

IPA_USERS

3e.) The report renders with an execution time for individual items and a total at the bottom of the page. These links drill through using the ZIPIID to different detailed reports.

image-20210531101632-12

3f.) After drilling to the ProcessTime report, you can drill down further on additional processes.

(Drilling down on the Crosstab Execution Time displays a Gantt chart, which shows the Start and End times of the processes.)

Many different actions take place in parallel running a report.

Blue: Java Process – Content Manager, present the output in the viewer.

Green: BIBusTKServerMain Process – Output (HTML) generation. (Also query planning and execution for CQM.)

Yellow: Dataset Service – Plans, executes the query and generates a result set. (Not applicable to CQM.)

image-20210531101632-13

*Firefox might not display this custom chart properly.

3g.) Drilling on the Total Execution Time allows drilling down further on individual processes or the ZIPIID to show a Gantt chart (similar to 3f) of the execution or a list of individual service timings.

image-20210531101632-14

3h.) A report running with a CQM (Compatible Query Mode) does not display the dataset-service as this processing is performed in the BIBusTKServerMain process.

image-20210531101632-15

3i.) To see Report Server Time Detail report, select the ReportServerTimeDetail link. image-20210531101652-16

3j.) Report Server Time Detail report.

image-20210531101652-17

4a.) To show performance information for a Dashboard, select a widget and press [Ctrl] + [.] to launch the Serviceability flyout.

Enable the ‘Show duration for all visualizations’ to return performance information.

To get refreshed data, toggle the ‘Rerun all widgets to include performance details’. You are required to wait for the data to refresh to see new performance numbers. The numbers are updated in the flyout.

After refreshing, drill-through to additional information is available. Clicking the query time drills to the ProcessTimeDashboard.

The Duration numbers represent the following in this case.

Total (ms): The total time, in milliseconds, to run queries and render the visualization.

Server query 1 (ms) & Server query 2 (ms) represent the queries for the line and bar components of the chart.

To determine which query relates to the columns (Quantity) and which relates to the line (Unit Price), look at the ‘View Specification’. Download and search the specification. The first reference is the first query and so on.

image 10295

4b.) Clicking the Performance detail - Gantt chart displays the Gantt chart.

image 10296

4c.) The Gantt chart displays a representation of when actions occurred and how long they took.

image 10297

Notes:

Records are only captured during the specific report execution and not system wide. The IPPA records stored in the database are truncated 10 hours after their creation.

IPPA does not provide individual details for report visualizations.

The IPPA database can be used with SSL secured connections. To learn how to enable secured connections in IBM Cognos Configuration, follow this link.

https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=options-using-ssl-protocol-database-communications

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.0"}]

Document Information

Modified date:
01 June 2021

UID

ibm16457641