Configuring the IBM Cognos BI service

IBM® Business Monitor uses the IBM Cognos® Business Intelligence service to conduct multidimensional data analysis from your Monitoring dashboard space or portlet-based dashboards. In the four-cluster topology, IBM Cognos BI is installed on the support cluster.

About this task

To view this administrative console page, click Servers > IBM Business Monitor configuration.

Procedure

To install and configure IBM Cognos BI, complete the following steps:

  1. In the list of components, click Cognos. The status for the service is displayed. If the service is properly installed, the location of the installed service is listed in the status box. (If you installed IBM Cognos BI with IBM Business Monitor and created a stand-alone profile, the IBM Cognos BI service is already deployed.)
  2. To deploy a new IBM Cognos BI service, select the server or cluster for the IBM Cognos BI service from the list. All available servers and clusters are listed. (The available servers and clusters are shown with asterisks (*)). If you have more than one server with the same name, be sure to choose the server on the correct node.

    Provide a database name to be used for the content store. On DB2® and Microsoft SQL Server, the database name must be different from the MONITOR database name. Provide a database user name and password. If you use the same user name for the content store as for the MONITOR database, you must use the same password.

    The IBM Cognos BI service creates tables in the IBM Cognos BI content store database the first time it is started. Because the database user provided for accessing the content store database must have privilege to create tables in the database, it is recommended that you create a new database user for the content store database only.

    Note: The user name and password for the IBM Cognos BI content store database are kept in the Cognos_JDBC_Alias, which allows all database credentials to be maintained in one place. Whenever you start the IBM Business Monitor IBM Cognos BI server, the current values are passed to the IBM Cognos BI configuration to allow IBM Cognos BI access to the content store. Because of this integration, you cannot change the content store user name and password using the IBM Cognos BI Configuration application.
    If administrative security is enabled, you must also provide the IBM Cognos BI administrator user name and password.

    Click Deploy Cognos Service. The status box is updated with the location of the installed service. If this service has been installed to a cluster, the service will appear unavailable until all nodes in the cluster have been synchronized and restarted. If the deployment takes more time than is provided by the administrative console response timeout, you might see a timeout message. Wait a few more minutes before attempting to restart the servers.

  3. If you already have an existing version of IBM Cognos BI installed, under Use an existing Cognos service, provide the external dispatcher URI of the IBM Cognos BI server. You can find this URI in the IBM Cognos BI configuration client in Local Configuration > Environment > Dispatcher Settings (for example, http://my_host:my_port/p2pd/servlet/dispatch/ext). If administrative security is enabled on the IBM Cognos BI server, you must also provide the IBM Cognos BI administrator user name and password.

    Click Use an Existing Cognos Service. The status box is updated with the location of the installed service.

  4. Return to the main configuration page by clicking IBM Business Monitor configuration in the breadcrumb listing.