Has anyone been able to get the new IPA reporting tables to generate or populate in the database?  I have a notification DB but I don't get any of the tables after adding the advanced setting.  I've checked the CS and audit DB as well, nothing is there.  Is there another step needed to get this going?

1. Enable the DISP.zipi.IPAEnabled parameter.
   1. Click Manage > Configuration > System, and select Advanced Settings.
   2. Type DISP.zipi.IPAEnabled in the Key field.
   3. Type true in the Value field.
      Tip: Ensure that the letters in true are all lower case.
   4. Click Apply.
   5. Refresh your browser window.
2. Log in to the IPA database (the Notification database, if configured, otherwise the Content Store database) and confirm that the following tables are generated and populated with data:
   • IPA_ACTIVITY_ACTIONS
   • IPA_BUCKETS
   • IPA_COGDATES
   • IPA_COGTIMES
   • IPA_CUBE_REQ
   • IPA_LOGRECORDS
   • IPA_RECORDETAILS
   • IPA_REPORT_REQ
   • IPA_SERVERS
   • IPA_USERS

Setting up Interactive Performance Assistant (IPA) - IBM Documentation

Has anyone been able to get the new IPA reporting tables to generate or populate in the database?  I have a notification DB but I don't get any of the tables after adding the advanced setting.  I've checked the CS and audit DB as well, nothing is there.  Is there another step needed to get this going?

1. Enable the DISP.zipi.IPAEnabled parameter.
   1. Click Manage > Configuration > System, and select Advanced Settings.
   2. Type DISP.zipi.IPAEnabled in the Key field.
   3. Type true in the Value field.
      Tip: Ensure that the letters in true are all lower case.
   4. Click Apply.
   5. Refresh your browser window.
2. Log in to the IPA database (the Notification database, if configured, otherwise the Content Store database) and confirm that the following tables are generated and populated with data:
   • IPA_ACTIVITY_ACTIONS
   • IPA_BUCKETS
   • IPA_COGDATES
   • IPA_COGTIMES
   • IPA_CUBE_REQ
   • IPA_LOGRECORDS
   • IPA_RECORDETAILS
   • IPA_REPORT_REQ
   • IPA_SERVERS
   • IPA_USERS

Setting up Interactive Performance Assistant (IPA) - IBM Documentation

Hi Todd

Can you let me know what database type you are using and whether you are using any advanced propertied in the NC connection? I can reach out and get further information and do some tests in-house.

Also, do you have a data source called ZIPI? 

Thanks,

------------------------------
TREVOR COMEAU

Original Message:
Sent: Fri June 23, 2023 12:06 PM
From: Todd Schuman
Subject: Cognos 12 - Generate IPA Tables

Has anyone been able to get the new IPA reporting tables to generate or populate in the database?  I have a notification DB but I don't get any of the tables after adding the advanced setting.  I've checked the CS and audit DB as well, nothing is there.  Is there another step needed to get this going?

1. Enable the DISP.zipi.IPAEnabled parameter.
   1. Click Manage > Configuration > System, and select Advanced Settings.
   2. Type DISP.zipi.IPAEnabled in the Key field.
   3. Type true in the Value field.
      Tip: Ensure that the letters in true are all lower case.
   4. Click Apply.
   5. Refresh your browser window.
2. Log in to the IPA database (the Notification database, if configured, otherwise the Content Store database) and confirm that the following tables are generated and populated with data:
   • IPA_ACTIVITY_ACTIONS
   • IPA_BUCKETS
   • IPA_COGDATES
   • IPA_COGTIMES
   • IPA_CUBE_REQ
   • IPA_LOGRECORDS
   • IPA_RECORDETAILS
   • IPA_REPORT_REQ
   • IPA_SERVERS
   • IPA_USERS

Setting up Interactive Performance Assistant (IPA) - IBM Documentation

------------------------------
Todd Schuman
------------------------------

Has anyone been able to get the new IPA reporting tables to generate or populate in the database?  I have a notification DB but I don't get any of the tables after adding the advanced setting.  I've checked the CS and audit DB as well, nothing is there.  Is there another step needed to get this going?

1. Enable the DISP.zipi.IPAEnabled parameter.
   1. Click Manage > Configuration > System, and select Advanced Settings.
   2. Type DISP.zipi.IPAEnabled in the Key field.
   3. Type true in the Value field.
      Tip: Ensure that the letters in true are all lower case.
   4. Click Apply.
   5. Refresh your browser window.
2. Log in to the IPA database (the Notification database, if configured, otherwise the Content Store database) and confirm that the following tables are generated and populated with data:
   • IPA_ACTIVITY_ACTIONS
   • IPA_BUCKETS
   • IPA_COGDATES
   • IPA_COGTIMES
   • IPA_CUBE_REQ
   • IPA_LOGRECORDS
   • IPA_RECORDETAILS
   • IPA_REPORT_REQ
   • IPA_SERVERS
   • IPA_USERS

Setting up Interactive Performance Assistant (IPA) - IBM Documentation

Hi Todd,

Just FYI, a data source names ZIPI would override the NC database setting. IPPA looks for a ZIPI database first, the NC configuration second and the CM configuration third.
I am wondering if that data source is a holdover from a prior configuration. We stopped recommending using the ZIPI data source for CA 12. I will check on noting this for upgraded systems that may have once used ZIPI.

If so you would just need to set the advanced property to false, exit out, rename the data source, set the advanced property back to true. The system will recognize the change.

The IPADATA data source is used to connect for reporting off of the data. 

We can't logically use the same source to write and read the data. That would prevent the ability to use the other two configurations unless you were to rename the data source, collect data, rename it back to report on it.

Has anyone been able to get the new IPA reporting tables to generate or populate in the database?  I have a notification DB but I don't get any of the tables after adding the advanced setting.  I've checked the CS and audit DB as well, nothing is there.  Is there another step needed to get this going?

1. Enable the DISP.zipi.IPAEnabled parameter.
   1. Click Manage > Configuration > System, and select Advanced Settings.
   2. Type DISP.zipi.IPAEnabled in the Key field.
   3. Type true in the Value field.
      Tip: Ensure that the letters in true are all lower case.
   4. Click Apply.
   5. Refresh your browser window.
2. Log in to the IPA database (the Notification database, if configured, otherwise the Content Store database) and confirm that the following tables are generated and populated with data:
   • IPA_ACTIVITY_ACTIONS
   • IPA_BUCKETS
   • IPA_COGDATES
   • IPA_COGTIMES
   • IPA_CUBE_REQ
   • IPA_LOGRECORDS
   • IPA_RECORDETAILS
   • IPA_REPORT_REQ
   • IPA_SERVERS
   • IPA_USERS

Setting up Interactive Performance Assistant (IPA) - IBM Documentation

I should have had my coffee before responding.  Sorry I don't have ZIPI, I have the IPADATA data source.  This is a brand-new Content Store with nothing loaded except the samples, audit reports, and IPA package and reports.

Hi Todd,

Just FYI, a data source names ZIPI would override the NC database setting. IPPA looks for a ZIPI database first, the NC configuration second and the CM configuration third.
I am wondering if that data source is a holdover from a prior configuration. We stopped recommending using the ZIPI data source for CA 12. I will check on noting this for upgraded systems that may have once used ZIPI.

If so you would just need to set the advanced property to false, exit out, rename the data source, set the advanced property back to true. The system will recognize the change.

The IPADATA data source is used to connect for reporting off of the data. 

We can't logically use the same source to write and read the data. That would prevent the ability to use the other two configurations unless you were to rename the data source, collect data, rename it back to report on it.

Has anyone been able to get the new IPA reporting tables to generate or populate in the database?  I have a notification DB but I don't get any of the tables after adding the advanced setting.  I've checked the CS and audit DB as well, nothing is there.  Is there another step needed to get this going?

1. Enable the DISP.zipi.IPAEnabled parameter.
   1. Click Manage > Configuration > System, and select Advanced Settings.
   2. Type DISP.zipi.IPAEnabled in the Key field.
   3. Type true in the Value field.
      Tip: Ensure that the letters in true are all lower case.
   4. Click Apply.
   5. Refresh your browser window.
2. Log in to the IPA database (the Notification database, if configured, otherwise the Content Store database) and confirm that the following tables are generated and populated with data:
   • IPA_ACTIVITY_ACTIONS
   • IPA_BUCKETS
   • IPA_COGDATES
   • IPA_COGTIMES
   • IPA_CUBE_REQ
   • IPA_LOGRECORDS
   • IPA_RECORDETAILS
   • IPA_REPORT_REQ
   • IPA_SERVERS
   • IPA_USERS

Setting up Interactive Performance Assistant (IPA) - IBM Documentation