Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
I_MCA
Employee
Employee

The SAP BusinessObjects BI 4 platform uses Tomcat as the default web application server. However there are a couple of configuration changes that can be made to Tomcat that will help Analysis edition for OLAP to perform even better.

Based on a default installation, the first change will increase the maximum memory pool for Java and the second change will increase the maximum number of processing threads. These changes will allow for a larger number of users and larger query size.

This blog explains the simple steps to make these changes, for both Windows (including video) and Linux.

NOTE: The values shown in the video and mentioned in this blog are example values. It is important that you make use of the various sizing tools available at http://service.sap.com/sizing for actual values.

Windows

1. From the machine that is running Tomcat we want to change the properties of the Tomcat service. Click on the "Start" button and open the "Tomcat" program folder. Click on "Tomcat Configuration".

2. In the "Apache Tomcat for BI 4 Properties" dialog, click on the "Java" tab.

3. Change the "Maximum memory pool" setting from 2048 MB to the suggested size from the sizing tools. In the video it is changed to 4096 MB. Click on "Apply". *Do not close the dialog*

4. Use Windows Explorer to navigate to the folder:-

    <SystemDrive:>\Program Files (x86)\SAP BusinessObjects\tomcat\conf\.

5. Open the file "server.xml" in a text editor.

6. Assuming that the default port 8080 is being used by your SAP BusinessObjects BI installation, look for the line that starts:-

    "<Connector port="8080" protocol="HTTP/1.1" ..."

7. Add the maxThreads parameter to this line with the suggested value from the sizing tools. In our example we increase the number of threads from the default value of 200 to 400 threads. The line now starts:-

    "<Connector maxThreads="400" port="8080" protocol="HTTP/1.1" ..."

[Aside: The number of threads is loosely related to the number of concurrent users and the number of Analysis OLAP workspaces that each user will open simultaneously.]

8. Save and close the "server.xml" file.

9. Return back to the "Apache Tomcat for BI 4 Properties" dialog and click on the "General" tab.

10. Click on "Stop" to stop the Apache Tomcat service. Once stopped, click on "Start" to start it again and use the settings you have just made.


[For easier viewing, we recommend you toggle on "Full screen" mode and switch to 720p HD]

Linux

1. From the machine that is running Tomcat we want to change the properties of the Tomcat daemon. Go to the directory $BOBJEDIR (the directory where SAP BusinessObjects Enterprise is installed) and stop Tomcat by executing the command "tomcatshutdown.sh".

2. Go to the directory $BOBJEDIR/tomcat/bin.

3. Open the file "setenv.sh" with a text editor.

4. Locate the line with the JAVA_OPTS environment variable. Change the -Xmx parameter to the suggested size from the sizing tools. In our example we will change it to 8GB (ie 8g). The edited entry will be similar to:-
    JAVA_OPTS="... -Xmx8g ..."

5. Go to the directory $BOBJEDIR/tomcat/conf.

6. Open the file "server.xml" with a text editor.

7. Assuming that the default port 17078 is being used by your SAP BusinessObjects BI installation, look for the line that starts:-

    "<Connector port="17078" protocol="HTTP/1.1" ..."

8. Add the maxThreads parameter to this line with the suggested value from the sizing tools. In our example we increase the number of threads from the default value of 200 to 400 threads. The line now starts:-

    "<Connector maxThreads="400" port="17078" protocol="HTTP/1.1" ..."

[Aside: The number of threads is loosely related to the number of concurrent users and the number of Analysis OLAP workspaces that each user will open simultaneously.]

9. Save and close the "server.xml" file.

10. Go to the $BOBJEDIR directory.

11. Start Tomcat by executing the command "tomcatstartup.sh". It will now use the changes you have just made.

8 Comments