Configure Cognos Business Intelligence after installation

Configure Cognos Business Intelligence after installation

After installation, perform further configuration tasks to ensure that IBM Cognos Business Intelligence works.
Before performing these configuration steps, the following components must have been installed:

Database client for Cognos Transformer. Refer to Install the database client for Cognos Transformer.

Cognos Business Intelligence components.

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:
Set up IBM Cognos Metrics to work with Connections

DB2 instructions

AIX:Make sure the locale on AIX is set to: en_US.ISO8859-1 or en_US.ISO8859-15. The locale setting is required by Cognos Transformer for building PowerCube.

Run first before manually running the script to build the cube:
export LC_ALL=en_US.ISO8859-1

Run 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

AIX:Copy libdb2.a from the lib32 folder under <db2client_home_directory>, and paste it to <transformer_installation_directory>/bin folder.
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.

(RedHat Linux 6 64-bit systems) 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 :

Start server1 of the WAS where you deployed the Cognos BI.

Log into the administrative console of the WAS.

Navigate to Servers > Server Types > WebSphere application servers.

Click the cognos_server link.

Click JAVA and then select Process Management > Process definition > Environment Entries.

Click New to add the following entry: LD_PRELOAD = /usr/lib64/libfreebl3.so

(RedHat Linux only) Make sure LD_PRELOAD is set to: /usr/lib/libfreebl3.so before building cube. Run first before manually running the script to build cube:
export LD_PRELOAD=/usr/lib/libfreebl3.so

Run 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

Be careful about the path of 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.

(Windows) No special configuration needs be done, except to configure the job scheduler for Cognos Transformer on Windows.

Oracle instructions
AIX:Make sure the locale on AIX 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

Run 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
(AIX or Linux) Define the ORACLE_HOME, TNS_ADMIN, and LIBPATH on AIX, LD_LIBRARY_PATH on Linux, JVM variables to the Cognos server. Add this variable to JVM environment variable list.
Login to the WAS console of the Cognos BI Server.

Click Servers > Server Types > WebSphere application servers.

Click the link of the Cognos server.

Click JAVA and then Process Management > Process definition > Environment Entries.
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
AIX:            
LIBPATH=Cognos_BI_install_path/bin64: /u01/app/oracle/product/11.2.0/client_1/lib
Linux:
LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /u01/app/oracle/product/11.2.0/client_1/lib
(RedHat Linux only) Follow the same steps as previously described to add an additional entry:
LD_PRELOAD = /usr/lib64/libfreebl3.so

(AIX or Linux) 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

Linux:

Oracle_client_install_path/lib/libclntsh.so.11.1

Oracle_client_install_path/lib/libnnz11.so

If we are not logged in as root, change the permissions on the two files using chmod 755.
For 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.

(AIX or Linux) Make sure ORACLE_HOME is set before building a cube.

Run first before manually running the script to build cube. For example:
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1

Run 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 the following for AIX:
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

and to the following for Linux:
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

(Windows) No special configuration needs be done, except to configure the job scheduler for Cognos Transformer on Windows.
SQL Server instructions
AIX:Make sure the locale on AIX 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
(AIX or Linux) Define ODBCINI, LD_LIBRARY_PATH on Linux, LIBPATH on AIX, JVM variables to Cognos Server. Add this variable to JVM environment variable list :
Log into the WAS console of the Cognos BI Server.

Click Servers > Server Types > WebSphere application servers.

Click the link of the Cognos server.

Click JAVA and then select Process Management > Process definition > Environment Entries.
Add or edit entries as needed, such as:
 ODBCINI=/root/.odbc.ini
         AIX:            
             LIBPATH=Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
         Linux:
             LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
Restart the Cognos BI Server.
(RedHat Linux only) Follow the same steps as previously described to add an additional entry:
LD_PRELOAD = /usr/lib64/libfreebl3.so
(AIX or Linux) Make sure environment variable ODBCINI, LD_LIBRARY_PATH on Linux, LIBPATH on AIX are set before building a cube.
Runs first before manually running the script to build cube. For example:
export ODBCINI=/root/.odbc.ini
AIX:            
       export LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
Linux:
       export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/ 
Run 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 the following for AIX:
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
and to the following for Linux:
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
(Windows) No special configuration needs be done, except to configure the job scheduler for Cognos Transformer on Windows.