Preparing the Essbase Environment

How to:

The Adapter for Essbase minimally requires the installation of the Essbase Client. The Essbase Client allows you to connect to a local or remote Essbase Analytical Server.

Note: The level of User and Group Permissions for Applications/Databases required by Essbase 11.1.2 in order to be able to read the Database Outline was changed to the Access Database/Database Manager Level. All Reporting Server requests against Essbase read the Database Outline and, therefore, require this level of permissions.


Top of page

x
Procedure: How to Prepare the Environment on Microsoft Windows

On Microsoft Windows, the Essbase environment is set up during the installation of Essbase.


Top of page

x
Procedure: How to Prepare the Environment on UNIX

The following variables must be set during the installation of the Essbase Client:

ARBORPATH

Is the home directory for the Essbase Client.

For example, for the Essbase Client 11.1.2 on UNIX:

ARBORPATH= /rdbms5/arb11cli/EPMSystem11R1/products/Essbase/EssbaseClient
export ARBORPATH
ESSBASEPATH

Is the home directory for the Essbase Client (same as ARBORPATH).

For example, for the Essbase Client 11.1.2 on UNIX:

ESSBASEPATH= /rdbms5/arb11cli/EPMSystem11R1/products/Essbase/EssbaseClient
export ESSBASEPATH
ESSLANG

Is the language setting for the Essbase Client.

For example, for the Essbase Client 11.1.2 on UNIX:

ESSLANG=English_UnitedStates.US-ASCII@Binary
export ESSLANG 
LD_LIBRARY_PATH

Is the path for the Essbase Client libraries. LD_LIBRARY_PATH must include the bin directory under the Essbase Client home directory as well as the Essbase Client home directory, in that order.

For example, for the Essbase Client 11.1.2 on UNIX:

LD_LIBRARY_PATH =             /rdbms5/arb11cli/EPMSystem11R1/products/Essbase/EssbaseClient/bin;
/rdbms5/arb11cli/EPMSystem11R1/products/Essbase/EssbaseClient
export LD_LIBRARY_PATH 

iWay Software