Skip to Content
avatar image
Former Member

Essbase Universe and Reports

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 09, 2018 at 12:01 PM

    1. From Essbase vendor

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 09, 2018 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

    • ESSBASEPATH=%EPM_ORACLE_HOME%\common\EssbaseRTC-64\
    • 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
    Add comment
    10|10000 characters needed characters exceeded