Installation Guide › Server Installation › Report Server

Report Server

Tenant administration reports are drawn from data in the Business Objects database. They are visible in the reporting tasks which is accessible from the User Console.

Standalone Report Server

If you do not need high availability for the Report Server, use the following procedure for a standalone installation.

Prerequisites

If you are planning to use RHEL 6 for the Business Objects installation, these prerequisites exist:

• Minimum patch requirements for RHEL 6: compat-libstdc++-33-3.2.3-69.el6.i686 (compatibility standard C++ library from GCC 3.3.4); glibc-2.12-1 (RedHat advisory RHBA-2007:0619-3); libXext.i386; libncurses.so.5, libXext-devel-1.1-3.el6.i686, libXext-devel-1.1-3.el6.x86_64

  Note: Install both X86_64 & i636 patches for the above. We recommend using yum install package_name.

  The hostname cannot have special characters such as '-' (a hyphen). It can be only alpha-numeric.

• Oracle Client 32Bit (or you can use Instant Client. To download OracleLinuxClient.zip)
• Open your Oracle server Enterprise Management Console or SQL console and create Tablespaces for CMS ("BO_CMS_TS") and Auditing ("BO_AUDIT_TS"). Also create 2 users, one for CMS ("BO_CMS_USER") and other for Auditing ("BO_AUDIT_USER") and give them dba privileges on respective Tablespaces.
• locale en_US.utf8 (to be default locale for BO installation)
• export LANG=en_US.utf8

Follow these steps:

1. Create a UNIX group (for example: bobje) to be used as a CA Business Intelligence User:

   # groupadd -g 400 bobje
   

2. Create a folder to be used as home folder for CA Business Intelligence User:

   # mkdir /home/bobje
   

3. Create a UNIX user (for example: bobje) to be used by the CA Business Intelligence installer for administrators:

   # useradd -d /home/bobje -g bobje bobje
   

4. Set the password for the user created in step 3.

   # passwd bobje
   

5. Change the ownership of the home directory as follows:

   # chown -R bobje:bobje /home/bobje
   

6. Download and copy the CABI3.3 to /home/bobje (or home folder created in step #2)
7. Extract the installer GZ file as follows:

   gunzip cabi-version_number-linux.tar.gz
   

8. Extract the TAR file as follows:

   tar -xvf cabi-version_number-linux.tar
   

9. Give necessary permissions on CABI install folder and Installer media

   copy OracleLinuxClient.zip to /tmp
   

10. Extract zip file and all other zip files in it
11. Rename the folder "instantclient_11_2" to "oracle" and move "oracle" folder to /opt/.
12. Go to /opt/oracle and create softlinks as below

    ln -s libclntsh.so.11.1 libclntsh.so
    ln -s libocci.so.11.1 libocci.so
    

13. Create a file "tnsnames.ora" with following content. Remember to replace parameters (specified between < and >) according to your setup

     <your Oracle SID> =
       (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <Oracle Hostname>)(PORT = 1521))
      (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = <your Oracle Service/SID name>)
    

14. Edit .bash_profile of both "root" (/root/.bash_profile) and "bobje" (/home/bobje/.bash_profile) (or CA Business object user created in step #3) and add the following.

    Note: If /home/bobje/.bash_profile does not exist for bobje user, create one and change owner to bobje using command "chown bobje:bobje /home/bobje/.bash_profile"

    export ORACLE_HOME=/opt/oracle
    export PATH=$PATH:$ORACLE_HOME
    export TNS_ADMIN=/opt/oracle
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle
    

15. Go to the user home folder (/home/bobje).
16. Run the Cabi installer.

    cabiinstall.sh
    

    Note: CABI installation is console installation. Provide the necessary details in the screen, keeping note of the passwords, ports and usernames provided during the installation.

See the following section for a few important parameters to be given during installation.