Skip to Content
0

Essbase Universe and Reports

Apr 08 at 06:17 AM

31

avatar image

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
0

1. From Essbase vendor

2. Documented in Data Access guide, which you can find at http://help.sap.com

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

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

Essbase Client

Required Assemblies

commonComponents

productCommonComponents

essbaseProductCommonComponents

essbase_client

Required Download Files

Oracle Hyperion Foundation Services Release 11.1.2.1.0 for PlatformName Part 1 of 7

Oracle Essbase Clients Release 11.1.2.1.0

http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_11121/frameset.htm?ch02s03s02.html

After the installation is done than do the following.

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

  • ESSBASEPATH=%EPM_ORACLE_HOME%\common\EssbaseRTC-64\11.1.2.0
  • PATH=%EPM_ORACLE_HOME%\bin;%EPM_ORACLE_HOME%\common\EssbaseRTC-64\11.1.2.0\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\11.1.2.0\lib\ess_japi.jar
  • %EPM_ORACLE_HOME%\common\EssbaseJavaAPI\11.1.2.0\lib\ess_es_server.jar
Share
10 |10000 characters needed characters left characters exceeded