Installing SpagoBI with LibreOffice : Error OPENOFFICE_HOME is not defined

Installing SpagoBI with libreofffice throws error

root@boss[bin]#./OOStart.sh

Error

OPENOFFICE_HOME is not defined ,  SpagoBI component for dossier creation will not work!!
Control that OpenOffice 2.x is installed and set OPENOFFICE_HOME variable to the installation folder.

I've installed libreoffcie in my machine [ debian squeeze OS ].( If you have installed Openoffice set openofficehome)

SOLUTION

find libreoffice by locate libreoffice

root@boss[bin]#locate libreoffice

the executable sofffice resides in program dir

root@boss[bin]#ls /usr/lib/libreoffice/
basis3.4  basis-link  CREDITS.odt  LICENSE.odt  program  share

set libreoffice_home i.e /var/lib/libreoffice as OPENOFFICE_HOME  in /etc/profile

root@boss:/opt/software/SpagoBI-4.0/bin# vi /etc/profile

OPENOFFICE_HOME=/var/lib/libreoffice
.......

EXPORT  PATH OPENOFFICE_HOME

execute /etc/profile to make sure changes are in place.

root@boss:/opt/software/SpagoBI-4.0/bin#. /etc/profile

now do start SpagoBI 

root@boss[bin]#./OOStart.sh