Configuring the Server Properties File

A default server.properties file, created during installation, contains the server properties necessary to run Essbase Studio.

During configuration, the EPM System Configurator writes the server configuration settings you select to the Essbase Studio server.properties file.

After installation, you may edit or add server properties.

Note:

The server.properties file is located in MIDDLEWARE_HOME/user_projects/epmsystem1/BPMS/bpms1/bin.

For information on MIDDLEWARE_HOME, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

  To edit the server.properties file:

  1. Edit the file in text format with any text editor, such as Windows Notepad.

  2. Enter each setting on a separate line in the file.

    You do not need to end each line with a semicolon.

  3. Ensure that the file is named server.properties.

  4. Save the file in the Essbase Studio server directory.

  5. After changing the server properties file, stop and restart Essbase Studio Server.

    Essbase Studio Server reads the properties file once, at startup.

The following is an example of the properties that can be configured in server.properties. See Server Properties for descriptions and examples of each property.

catalog.url=database tag\://host:port/
server.css.URL=server.css.URL=http\://server.us.oracle.com\:port/interop/framework/getCSSConfigFile
catalog.db=catalog database name
catalog.username=catalog user ID
catalog.password=encrypted catalog password
server.hss.bpmApplication=BPM\:BPM application ID
server.datafile.dir=path to flat file directory
server.essbase.streamingCubeBuilding=true|false
server.timeoutPeriod=number of seconds
server.queueSize=size of the task queue
server.threadCount=number of worker threads
server.resourceCount=number of tasks that can be executed concurrently
server.sql.fetchSize=fetch size
server.tempDir=path to temporary directory
server.charset=charset
server.readLockTimeOut=number of seconds
server.writeLockTimeOut=number of seconds
server.essbase.TPTapi=true|false
server.essbase.disableDistinct=true|false
server.httpPort=port number
transport.port=port number
server.runInBackground=true|false
server.essbase.blindShare=true|false
oracle.jdbc.ReadTimeout=milliseconds
data-source-type.pool.maxsize=maximum size of the connection pool
data-source-type.cache.size=cache size
server.essbase.uniqueMemberFromCaptionBinding=true|false

Note:

Some exceptions to this syntax exist, depending on your RDBMS. They are discussed in Server Properties File Examples.