Configuring Cognos Business Intelligence after installation

After installation, you need to perform further configuration tasks to ensure that IBM® Cognos® Business Intelligence works.

Before you begin

Before performing these configuration steps, the following components must have been installed:

About this task

Cognos Business Intelligence Server and Cognos Transformer need to communicate with a database client to set up the Cognos content store and to build the Cognos PowerCube. A set of specific settings (appropriate to each operation system and database type) must be specified before Cognos components can work properly. The following topics detail the configuration steps according to the supported database types:
Parent topic: Setting up IBM Cognos Metrics to work with IBM Connections

DB2 instructions for AIX

Procedure

  1. Make sure the locale is set to: en_US.ISO8859-1 or en_US.ISO8859-15. The locale setting is required by Cognos Transformer for building PowerCube.
    • Run the following command first before manually running the script to build the cube:
      export LC_ALL=en_US.ISO8859-1
    • Use the following command to edit the cron jobs to set the locale for scheduled PowerCube generation tasks:
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
      to:
      05 00 * * 1-6 export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
  2. Copy libdb2.a from the lib32 folder under <db2client_home_directory>, and paste it to <transformer_installation_directory>/bin folder.
    Note: Cognos Transformer is a 32-bit application, but the DB2® client is 64-bit. This incompatibility can cause issues when Transformer accesses the database. Associated errors that might occur are: UDA-SQL-0569 Unable to unable to load driver manager library (liddb2.a(shr.o) and cannot load module shr.o. To resolve this problem, copy the 32-bit compatible library provided by the DB2 client to the Transformer location.
  3. Use the following command to edit the cron jobs to set the LD_PRELOAD for scheduled cube generation tasks: 
    crontab -e
    For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
    05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
    To:
    05 00 * * 1-6 export LD_PRELOAD=/usr/lib/libfreebl3.so; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export LD_PRELOAD=/usr/lib/libfreebl3.so; /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
    Note: Be careful about the path of the libfreebl3.so file. In the earlier step, the 64bit libfreebl3.so in /usr/lib64/ folder is used when installing Cognos components. In this step, the 32-bit version in lib folder should be used.

DB2 instructions for Linux

About this task

This procedure applies to RedHat Linux 6 64-bit systems.

Procedure

  1. Set the LD_PRELOAD variable to the JVM environment variable list of the Cognos server. The environment variable LD_PRELOAD needs to be set every time after a Linux system restart. To enable this, add this variable to JVM environment variable list as follows:
    1. Start server1 of the WebSphere® Application Server where you deployed the Cognos BI.
    2. Log into the administrative console of the WebSphere Application Server.
    3. Navigate to Servers > Server Types > WebSphere application servers.
    4. Click the cognos_server link.
    5. Click JAVA and then select Process Management > Process definition > Environment Entries.
    6. Click New to add the following entry: LD_PRELOAD = /usr/lib64/libfreebl3.so
  2. Make sure LD_PRELOAD is set to: /usr/lib/libfreebl3.so before building cube. Run the following command first before manually running the script to build cube:
    export LD_PRELOAD=/usr/lib/libfreebl3.so
  3. Use the following command to edit the cron jobs to set the LD_PRELOAD for scheduled cube generation tasks: 
    crontab -e
    For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
    05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
    to
    05 00 * * 1-6 export LD_PRELOAD=/usr/lib/libfreebl3.so; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export LD_PRELOAD=/usr/lib/libfreebl3.so; /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
    Note: Be careful about the path of the libfreebl3.so file. In the earlier step, the 64bit libfreebl3.so in /usr/lib64/ folder is used when installing Cognos components. In this step, the 32-bit version in lib folder should be used.

Oracle instructions for AIX

Procedure

  1. Make sure the locale on is set to: en_US.ISO8859-1 or en_US.ISO8859-15. The locale setting is required by Cognos Transformer for building a power cube.
    • Execute the following command first before manually running the script to build a cube.
      export LC_ALL=en_US.ISO8859-1
    • Use the following command to edit the cron jobs to set the locale for scheduled cube generation tasks:
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
      to:
      05 00 * * 1-6 export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export LC_ALL=en_US.ISO8859-1;  /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
  2. Define the ORACLE_HOME, TNS_ADMIN, and LIBPATH JVM variables to the Cognos server. Add this variable to JVM environment variable list.
    1. Log into the WebSphere Application Server Integrated Solutions Console of the Cognos BI Server.
    2. Click Servers > Server Types > WebSphere application servers.
    3. Click the link of the Cognos server.
    4. Click JAVA and then Process Management > Process definition > Environment Entries.
    5. Add or edit entries as needed, such as: 
      ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
TNS_ADMIN=ORACLE_HOME/network/admin
LIBPATH=Cognos_BI_install_path/bin64: /u01/app/oracle/product/11.2.0/client_1/lib
  3. Copy the following files to the Cognos_Transformer_install_path/bin directory: AIX®:
    • Oracle_client_install_path/lib/libclntsh.so
    • Oracle_client_install_path/lib/libnnz11.so
    If you are not logged in as root, change the permissions on the two files using chmod 755.
    Note: If you are using a different version of the Oracle client, you should find similar files (named for the version) in the same location and can use those files instead.
  4. Make sure ORACLE_HOME is set before building a cube.
    • Run the following command first before manually running the script to build cube. For example:
      export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
    • Use the following command to edit the cron jobs to set the ORACLE_HOME for scheduled cube generation tasks:
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
      to:
      05 00 * * 1-6 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1; export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1; export LC_ALL=en_US.ISO8859-1;  /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh

Oracle instructions for Linux

Procedure

  1. Define the LD_LIBRARY_PATH JVM variable to the Cognos server. Add this variable to JVM environment variable list.
    1. Log in to the WebSphere Application Server Integrated Solutions Console of the Cognos BI Server.
    2. Click Servers > Server Types > WebSphere application servers.
    3. Click the link of the Cognos server.
    4. Click JAVA and then Process Management > Process definition > Environment Entries.
    5. Add or edit entries as needed, such as: 
      ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
TNS_ADMIN=ORACLE_HOME/network/admin
LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /u01/app/oracle/product/11.2.0/client_1/lib
  2. Follow the same steps as previously described to add an additional entry: 
    LD_PRELOAD = /usr/lib64/libfreebl3.so
  3. Copy the following files to the Cognos_Transformer_install_path/bin directory:
    • Oracle_client_install_path/lib/libclntsh.so.11.1
    • Oracle_client_install_path/lib/libnnz11.so
    If you are not logged in as root, change the permissions on the two files using chmod 755.
    Note: If you are using a different version of the Oracle client, you should find similar files (named for the version) in the same location and can use those files instead.
  4. Make sure ORACLE_HOME is set before building a cube.
    • Run the following command first before manually running the script to build cube. For example:
      export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
    • Use the following command to edit the cron jobs to set the ORACLE_HOME for scheduled cube generation tasks:
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
    • To:
      05 00 * * 1-6 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1;   /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh

SQL Server instructions for AIX

Procedure

  1. Make sure the locale is set to: en_US.ISO8859-1 or en_US.ISO8859-15. The locale setting is required by Cognos Transformer for building powercube. Execute the following command first before manually running the script to build cube.
    export LC_ALL=en_US.ISO8859-1
  2. Define LIBPATH on AIX, JVM variables to Cognos Server. Add this variable to JVM environment variable list as follows:
    1. Log into the WebSphere Application Server Integrated Solutions Console of the Cognos BI Server.
    2. Click Servers > Server Types > WebSphere application servers.
    3. Click the link of the Cognos server.
    4. Click JAVA and then select Process Management > Process definition > Environment Entries.
    5. Add or edit entries as needed, such as: 
       ODBCINI=/root/.odbc.ini
         LIBPATH=Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    6. Restart the Cognos BI Server.
  3. Make sure the ODBCINI, LD_LIBRARY_PATH environment variable is set before building a cube.
    • Run the following commands first before manually running the script to build cube. For example:
      export ODBCINI=/root/.odbc.ini          
       export LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    • Use the following command to edit the cron jobs to set the ODBCINI, LD_LIBRARY_PATH on Linux, LIBPATH on AIX for scheduled cube generation tasks, 
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
      To:
      05 00 * * 1-6 export LC_ALL=en_US.ISO8859-1: export ODBCINI=/root/.odbc.ini:export LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/:/opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export LC_ALL=en_US.ISO8859-1: export ODBCINI=/root/.odbc.ini:export LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/:/opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh

SQL Server instructions for Linux

Procedure

  1. Define the ODBCINI, LD_LIBRARY_PATH JVM variable to Cognos Server. Add this variable to JVM environment variable list as follows:
    1. Log into the WebSphere Application Server Integrated Solutions Console of the Cognos BI Server.
    2. Click Servers > Server Types > WebSphere application servers.
    3. Click the link of the Cognos server.
    4. Click JAVA and then select Process Management > Process definition > Environment Entries.
    5. Add or edit entries as needed, such as: 
       ODBCINI=/root/.odbc.ini
         LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    6. Restart the Cognos BI Server.
  2. Follow the same steps as previously described to add an additional entry: 
    LD_PRELOAD = /usr/lib64/libfreebl3.so
  3. Make sure the ODBCINI, LD_LIBRARY_PATH environment variable is set before building a cube.
    • Run the following commands first before manually running the script to build cube. For example:
      export ODBCINI=/root/.odbc.ini
       export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    • Use the following command to edit the cron jobs to set the ODBCINI, LD_LIBRARY_PATH on Linux, LIBPATH on AIX for scheduled cube generation tasks, 
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
      To:
      05 00 * * 1-6 export ODBCINI=/root/.odbc.ini:export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/: /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export ODBCINI=/root/.odbc.ini:export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/: /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh