Skip to Content

Essbase Universe and Reports

Apr 08 at 06:17 AM


avatar image
Former Member

Hi All,

Require your help with questions for Essbase Universe creation steps?

Environment : SAP BI 4.2 on a Unix Server. Essbase 11

1)Where to get the right Essbase middleware installation package for a BO Unix server?

2)What configuration /environment variables changes required on the BO Unix server? Are these changes required on local machines too?

3)There was known issue even in BI 4.0 regarding performance in Essbase Universe? Any realtime experiences for Unix or Windows?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Denis Konovalov
Apr 09 at 12:01 PM

1. From Essbase vendor

2. Documented in Data Access guide, which you can find at

10 |10000 characters needed characters left characters exceeded
Sonet Kebede
Apr 09 at 01:06 PM

I believe you need to have the full version of essbase client to get this working with all the product.

Essbase Client

Required Assemblies





Required Download Files

Oracle Hyperion Foundation Services Release for PlatformName Part 1 of 7

Oracle Essbase Clients Release

After the installation is done than do the following.

Configured environment variables for the Essbase data source version and Higher and the oracle client

  • PATH=%EPM_ORACLE_HOME%\bin;%EPM_ORACLE_HOME%\common\EssbaseRTC-64\\bin;%PATH%

Copy the 3 following JAR files from the Oracle Essbase client installation directory to the java\lib BIP installation directory. This ensures that hierarchy levels are determined spontaneously in the Query Panel and can be selected in the query.

  • %EPM_ORACLE_HOME%\_vpddb\Gen1\engine\1.0\library\ojdl.jar
  • %EPM_ORACLE_HOME%\common\EssbaseJavaAPI\\lib\ess_japi.jar
  • %EPM_ORACLE_HOME%\common\EssbaseJavaAPI\\lib\ess_es_server.jar
10 |10000 characters needed characters left characters exceeded