Adding IBM Cognos Analytics to OpenPages

You can configure OpenPages instances to use IBM® Cognos® Analytics for your organization's reporting requirements.

Before you begin

The IBM Cognos Analytics instance and the OpenPages instance are installed and running in the same instance of Cloud Pak for Data.

About this task

You can set up the integration with IBM Cognos Analytics when you provision an OpenPages instance. You can also set up the integration for instances that already exist.

The IBM Cognos Analytics instance and the OpenPages instance must be installed in the same instance of Cloud Pak for Data.

You can integrate multiple OpenPages instances with a single IBM Cognos Analytics instance.

After you set up the integration, you enable IBM Cognos Analytics in your OpenPages instance and generate the reporting framework.

1. If you did not enable the integration when you provisioned OpenPages, do the following steps:
   1. Run the following command:

       cpd-cli manage update-cr --component=openpages_instance \
       --cpd_instance_ns==${PROJECT_CPD_INST_OPERANDS} \
       --patch="{\"metadata\":{\"enableIntegrationWithCognos\":True}}" \
       --extra-vars='{"cr_name":"${INSTANCE_NAME}"}' \
       [--tethered_instance_ns=${TETHERED_NAMESPACE}]

      Replace ${INSTANCE_NAME} with the name of your OpenPages instance.

      Use the --tethered_instance_ns parameter if the OpenPages instance is installed in a tethered project.

   2. Wait until the status of the process is Complete.
2. Log in to OpenPages as an administrator.
3. Click > Integrations > Cognos Analytics.
4. Optional: In the OpenPages Instance Name, type the name you want to use for the integration in IBM Cognos Analytics. The default value is the name of your OpenPages instance.

   For example, if you use openpagesinstance-2, the folder in IBM Cognos Analytics will be Team content/openpagesinstance-2.

   

   You can, for example, use a folder that is called Dev, and then later use another that is called UAT. Your OpenPages instance can use only one folder at a time, but you can switch between them by updating the OpenPages Instance Name field.

5. Click Enable.
6. Click Submit.
7. Refresh OpenPages by doing the following steps:
   1. Close all OpenPages browser windows.
   2. Open a new incognito or private window.

      Or, clear the OpenPages session cookies, which are called OPJSESSIONID-POD<N>.

      For example, in Chrome, go to Settings > Privacy and security. Click See all cookies and site data. Click the OpenPages URL, and then delete the OPJSESSIONID-POD<N> cookies.

8. 5.0.0 - 5.0.2 If you enabled Cognos on Cloud Pak for Data 5.0.0 through 5.0.2 and you're using Oracle external database, complete these steps:
   1. Log on to IBM Cognos Analytics as a user with administrative privileges by doing one of the following steps:
      • In OpenPages, click Analytics.
      • Or, go to the following URL: http://<hostname>/ibmcognos/bi

        Where <hostname> is the name of the Cognos server.

   2. Click Manage > Administration Console to launch the IBM Cognos Administration page.
   3. Click the Configuration tab.
   4. Click OpenPages DataSource under Data Source Connections.
   5. Click Actions > More > Set Properties.
   6. Update the JDBC connection information.
      1. Click the Connection tab.
      2. Click the pencil icon next to the Connection String box to edit the field.
      3. Click the JDBC tab.
      4. In the Port number field, enter your non-ssl port number, for example, 1521.
      5. In Oracle Service ID field, enter OP. Make sure there are no other text in this field.
      6. Click OK.
   7. Click OK.
   8. In the Admin UI on the Configuration tab, click Test to ensure that IBM Cognos Analytics can access the Oracle database.
9. Update the reporting framework:
   1. Click > Cognos Analytics > Reporting Framework Generation.
   2. Ensure that All Models is enabled, and then click Submit.

   The framework models are published to IBM Cognos Analytics in the Team content/<op_instance_name>/OpenPages Packages folder.

   
10. Verify the integration.
    • Click to open the Primary menu and click Analytics.
    • Add a report to your dashboard, and open the report.