Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers Oracle Analytics Cloud, Oracle Analytics Server and...

OLAP_MAX_CONNECTIONS Property Considerations

The OLAP_MAX_CONNECTIONS property controls the maximum
number of connections from Planning to Essbase. The default setting is 10, but the property can be increased to allow
for more concurrent Essbase connections. The Hyperion Planning Administrator’s Guide recommends a setting of 20
for 100 users and 100 for 500 users.

Although the OLAP_MAX_CONNECTIONS property can be increased,
the amount the setting can be increased is constrained by the SERVERTHREADS
setting in Essbase. The SERVERTHREADS
setting defines the number of threads available for an Essbase
application. The default SERVERTHREADS
setting is 20, so if this setting is not changed, the most the
OLAP_MAX_CONNECTIONS can be increased is 20. Therefore, if an OLAP_MAX_CONNECTIONS setting higher than 20 is
required, the SERVERTHREADS setting in Essbase must also be increased to a
value at least equal to the OLAP_MAX_CONNECTIONS setting. If the application requires direct
connections to Essbase using SmartView or Financial Reports that bypass
Planning altogether, then the SERVERTHREADS setting should be set to a value
higher than the OLAP_MAX_CONNECTIONS setting based on the required number of
concurrent SmartView and Financial Reports Essbase connections.

Join the discussion

Comments ( 1 )
  • siva Thursday, January 7, 2016

    Thumbs up!!

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.