Environment : Cognos 8.4 in Unix Server,Essbase 7.1
Hello Friends, I did not find any good details about it in Cognos documentation,so thought to share with you all so that you do not have to troubleshoot from your side.
Also if you encounter below error,this solution can also help:
Error message : Unable to find or load the shared library 'ld.so.1: BIBusTKServerMain: fatal: /global/site/vendor/cognos/c8_64/./bin/libDB2OlapODP.so: open failed: No such file or directory - /global/site/vendor/cognos/c8_64/./bin/libDB2OlapODP.so' (or one of its dependents) containing the provider 'DB2OlapODP'. Please contact your administrator.
Step1 : Installation of Essbase Client on Cognos Server.
The structure will look like this once you install essbase client in Cognos Unix Server.The installation is pretty easy for Essbase and mostly have to click next.
Servername:/
total 4
drwxr-xr-x 3 common
drwxr-xr-x 9 Essbase
Step 2 : Include the arbor path in Cognos server script.In our case we are using unix so the path will look like as below :
# ESSBASE
export ARBORPATH=/
export LD_LIBRARY_PATH=$otherpath:$ARBORPATH/bin:$LD_LIBRARY_PATH;
export PATH=$otherpath:$ARBORPATH/bin:$PATH;
Step 3 : Change the following entries in qseconfig.xml in
Change following line :
Search for provider name="DB2OlapODP" and in that change
libraryName=doodp82 from existing libraryName=essodp93
By default cognos comes on configured with Essbase 9 so to change to Essbase 7.1 you have to make below changes.
Step 4 : Restart the Services using configuration manager.
Step 5 : Test the connection by creating a Data Source in Cognos connection and pointing it to your Essbase server.Make sure the firewall ports are open between the servers.
