TEXT POP-UP WINDOW IN COGNOS REPORT

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

BMT-MD-2049

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

Start cognos on startup linux server

If you have cognos installed on an linux server it is nice to start cognos bi automatic when the server starts. To achieve this you have to add a script to the folder /etc/init.d

After that you have to perform some commands to add cognos to the startup proces of the linux server.

The following script is used to start cognos 8 on a Oracle Linux installation [Enterprise Linux release 4 (October Update 5)]:

#!/bin/bash
#
# Description: Cognos services auto start-stop script.
# Save script in: /etc/init.d as “cognos”
# Perform next steps to make it autostart on powerup:
# – chmod a+x cognos
# – chkconfig –add cognos
# – chkconfig cognos on
#
JAVA_HOME=/opt/IBMJava2-142/jre
COGNOS_OWNER=root
RETVAL=0
prog=”Cognos Services”
start() {
echo -n $”Starting $prog: ”
# Start the Cognos services
su – $COGNOS_OWNER -c “/opt/cognos/c8/bin/cogconfig.sh -s”
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/cognos
return $RETVAL
}
stop() {
echo -n $”Stopping $prog: ”
# Stop the Cognos services
su – $COGNOS_OWNER -c “/opt/cognos/c8/bin/cogconfig.sh -stop”
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && rm -r /var/lock/subsys/cognos
return $RETVAL
}
case “$1″ in
start)
start
;;
stop)
stop
;;
restart)
stop
start
;;
*)
echo $”Usage: $0 {start|stop|restart}”
exit 1
esac