Essbase Client configuration
Here are the paths needed to connect via the Essbase Client 11.1.2.x installed under "C:\Oracle". These paths may differ and may need to be adjusted according to your installation, but in a default installation the following paths should be useable:
ARBORPATH = C:\Oracle\Middleware\EPMSystem11R1
Without the ARBORPATH variable the Essbase client itself should work, but not the Grid-API... (The Essbase 12 client does not need ARBORPATH anymore)
EPM_ORACLE_HOME = C:\Oracle\Middleware\EPMSystem11R1
PATH: You can configure folders for 32 and 64 bit at the same time by adding the following string at the end of the variable:
If only 32bit or only 64bit is used it is recommended to only have the paths of the used architecture in the PATH variable.
The order in the PATH variable is important. The Essbase paths should be in the PATH as early as possible (preferably directly behind the system paths) because there may be conflicts with other drivers. (For example, it does not work if you have the Teradata ODBC driver in the path before)
In case error 1030803 or 1100005 is encountered, please check if the PATH contains %EPM_ORACLE_HOME%\bin or %EPM_ORACLE_HOME%\bin-32.
However, these error messages are standard and are unfortunately issued at every opportunity.They may not be related to incorrect variable entries.
ESSBASEPATH must point to the correct path:
For 32 bits it is: %EPM_ORACLE_HOME%\products\Essbase\EssbaseClient-32
And for 64 bits: %EPM_ORACLE_HOME%\products\Essbase\EssbaseClient
With Essbase 12 (64 bit): %EPM_ORACLE_HOME%\bi\clients\Essbase\EssbaseRTC
It is tricky to use both at the same time. You can configure ESSBASEPATH differently for different users (e.g. for 64 bit servers and 32 bit designers).
You can also have two variables, one for 32 and the other for 64bit. If so, the variable ESSBASEPATH32 is read in 32 bit and ESSBASEPATH should be used in 64bit then:
ESSBASEPATH = %EPM_ORACLE_HOME%\products\Essbase\EssbaseClient
ESSBASEPATH32 = %EPM_ORACLE_HOME%\products\Essbase\EssbaseClient-32