Essbase Studio Server

The following table describes the services and processes for the Essbase Studio server.

Table 75. Essbase Studio Server

Information TypeDetails
Windows Start Menu CommandSelect Start, then Programs, then Oracle EPM System, then Essbase, then Essbase Studio, and then Start Server
Registered Service NameHyperion Studio Service BPMS bpms1
Display Name in Windows Services Control PanelHyperion Studio Service BPMS bpms1
DescriptionNA
Windows Startup Script

EPM_ORACLE_INSTANCE/bin/startBPMS_bpms1_Server.bat

UNIX Startup Script

EPM_ORACLE_INSTANCE/bin/startBPMS_bpms1_Server.sh

Windows Stop Script

EPM_ORACLE_INSTANCE/bin/stopBPMS_bpms1_Server.bat

UNIX Stop Script

EPM_ORACLE_INSTANCE/bin/stopBPMS_bpms1_Server.sh

By default, Essbase Studio Server runs in the background on UNIX. This behavior is controlled by a combination of an Essbase Studio Server property (server.runInBackground), EPM System environment variables, and startServer.sh.

  To start Essbase Studio Server in the foreground on UNIX:

  1. In the Essbase Studio server.properties file, set the server.runInBackground property to “false” or comment it out.

    The server.properties file is located in EPM_ORACLE_INSTANCE/user_projects/epmsystem1/BPMS/bpms/bin/server.properties. See Oracle Essbase Studio User's Guide for information on this property.

  2. Set these variables in the environment where you plan to run startServer.sh:

    EPM_ORACLE_INSTANCE=/installationPath/Oracle/Middleware/user_projects/epmsystem1
    EPM_ORACLE_HOME=/installationPath/Oracle/Middleware/EPMSystem11R1
    JAVA_HOME="${EPM_ORACLE_HOME}/../jdk160_21/jre"
    JAVA_OPTIONS="-DESSBASE_STUDIO_INSTANCE=${EPM_ORACLE_INSTANCE}/BPMS/bpms1 
    -DsuppressAPSProductInfo=true"
    
  3. Edit the Essbase Studio startServer.sh shell as follows:

    startServer.sh is located in EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server/startServer.sh.

    • Locate the last line of the file:

      nohup "${JAVA_HOME}/bin/java" -Xms128m -Xmx768m $JAVA_OPTIONS –jar
        "${EPM_ORACLE_HOME}/products/Essbase/EssbaseStudio/Server/server.jar" >/dev/null &
    • Remove nohup from the beginning of the line, the STDOUT to null direction (>/dev/null), and the background processing command (&) from the line; for example:

      "${JAVA_HOME}/bin/java" -Xms128m -Xmx768m $JAVA_OPTIONS -jar "${EPM_ORACLE_HOME}/products/Essbase/EssbaseStudio/Server/server.jar"
  4. Start Essbase Studio Server by running the following statement: ./startServer.sh.