A customer has a report with some areas that need more explanation about the data or graphic. This is possible to just simple add a text item to the report with some text, but then there is a problem that it is always visible.

With this code it is possible to place the text in a popup window. If they click on the header name, defined in the script, a popup window will show. Click again on the header name to make it invisible again.

How to use:

Continue reading


Error BMT-MD-2049

Getting error BMT-MD-2049 on validating a project. I got this error on a dutch installation, so the error description is in dutch.

BMT-MD-2049 Deze meetwaarde heeft als gegevenstype ‘Character’ en bevat de normale aggregatieregel ‘Sum’. Deze regel wordt niet ondersteund voor dit gegevenstype.
BMT-MD-2050 Deze meetwaarde heeft als gegevenstype ‘Character’ en bevat de semi-additieve aggregatieregel ‘Sum’. Deze regel wordt niet ondersteund voor dit gegevenstype.
Continue reading

Cognos 10 installation on Linux

I found a discussion on the IBM Developer Works site about installing Cognos 10 on Linux. Find it here.

Here are the highlights of this thread, written by Vijendra Sawant:

1. Check if the Linux Operating system is supported for the Cognos 10 version that you are trying to install.

     Go to this link and check http://www-01.ibm.com/support/docview.wss?uid=swg27037784 based on your Cognos version.

2. If (1) if right then you should check if you have installed all the supporting operating system libraries. The libraries are 32-bit and 64-bit , you need to install them both irrespective of the Cognos being 32-bit or 64-bit. You will get the list of libraries at the above link.

3. Then Install Supported JRE version. So if you are using Websphere or Oracle Application server you would need to use the JRE which is included within Websphere or Oracle Application server. Please note if you are install supported JRE it should be installed with same user with which you would also be installing Cognos.

4. Now install Cognos using the Cognos Installable. Execute the setup executeable file. It would be better if you carryout these steps through a GUI rather then through command line. It’s just a matter of ease.

4. then make sure you have copied bcprov-jdkversion.jar to JRE_location/lib/ext. This file needs to be copied from c10_location/bin64/jre/version/lib/ext directory. If you are having 32-bit Cognos then instead of bin64 you should copy it from bin directory.

5. Add the Path and following environment variable to the profile of the user with which you have installed Cognos and would be starting Cognos Service.

Set JAVA_HOME path variable to point to the JRE home directory.

Make sure you have Cognos bin directory path mentioned in LD_LIBRARY_PATH variable. LD_LIBRARY_PATH should have a path point to Cognos Install/bin or cognos Install/bin64 depending upon the bit version of Cognos you have installed

To make sure that they are set correctly you can execute set command and see if you can see both the environment variable having the right paths. While you execute the set command make sure you are login with the same user with which you have installed cognos and it’s the same user with which Cognos service is going to be started as this is very important step.

6. Create the Content Store database on the supported database. You can refer the install and Configuration guide for the settings that is needed for Content store database while creation.

7. Now Open Cognos Configuration and provide the right details to URLs mentioned inside Environment. Provide proper details of your Content Store database. Please go through all the Cognos configuration settings to validate and modify the default settings needed based on your environment.

8. Test the Content Store connection.

9. If you have planned to deploy Cognos on another application server then the default one then you would need to build the ear file and deploy the same on the application server.

10. You are now good to start the Cognos service.

11. You would also need to Install and configure supported Webserver . For configuring Cognos with webserver you need to add in the respective Cognos aliases in httpd.conf file. Restart Webserver for the changes to take effect.

12. Now you are good to test the Cognos Gateway URL.

The above point is generally the steps we follow to setup Cognos on Linux. These can be used as pointer or check points while you progress.

Please note that Install and Configuration guide is the best guide to refer to if you want any indepth assistance.

Juan Pablo has an error:

ERROR-CRP-1042 It is not possible create certificate PKCS#10. Motive: java.net.UnknownHostExpeption

Solution to this error by GracyM:

try suggestions given here: http://www-01.ibm.com/support/docview.wss?uid=swg21344841


Next error:

Cryptography  ERROR java.lang.NullPointerException


Looks to be a cryptographic keys issue. Try regenerating them: http://www-01.ibm.com/support/docview.wss?uid=swg21383421