How to connect the arcplan Designer on a 64bit arcplan Server machine to Essbase
To use the arcplan Designer on a server that has arcplan 64bit installed-
One way that works -
Ensure these environemnt variables are in the SYSTEM path variable:
%EPM_ORACLE_HOME%\bin
%EPM_ORACLE_HOME%\bin-32
%EPM_ORACLE_HOME%\products\Essbase\EssbaseClient\bin
%EPM_ORACLE_HOME%\products\Essbase\EssbaseClient-32\bin
Reboot the machine for the changes to take effect.
The designer will then use the correct 32-bit essbase dlls.
- 2,788 views
- 0 previews
- 2 versions
- 2 replies
- 1 follower
- Posted By:
- John Herman
- April 17, 2013
About this forum
- 28,623 views
- 30 topics
- 3 followers
Your forum to share new discoveries, nifty solutions and helpful workarounds
Viewed 2,788 times
Page Options
2 Replies
Here's another way that works.
Leave the bin references in SYSTEM for arcplan on the web to use 64 bit and create new copies of the same variables above with the reference to bin-32 in the USER environment variables for arcplan Designer to use the 32 bit version. In that way both the 64 bit web and the 32 bit designer can be used on the same system. Use ARBORPATH, ESSBASEPATH, and Path for the User variables. Each version of Essbase is a bit different, but those three were necessary for me.
Hello,
I was having a rough time with arcplan 8.2.1 because I thought that the path would be the same as I had with arcplan 6 for my 64 bit-only configuration. That is not the case. The above path suggestion from John didn't work either.
If you have a clean system, you can use the script below. If you run it before opening up arcplan developer, you will not even need to reboot your system. With version 8, everything is 64 bit so there is no need to modify user variables.
Little additional tip: Use Rapid Environment Editor to review and manage your environment variables: http://www.rapidee.com
My Script. Tested with Essbase client 11.1.2.3.505
# Enter your Oracle base path here
$baseOraclePath = "C:\Oracle\Middleware\EPMSystem11R1"
$essbasePath = "$baseOraclePath\products\Essbase\EssbaseClient"
[Environment]::SetEnvironmentVariable("ESSBASEPATH", $essbasePath, "Machine")
Write-Output "Writing EssbasePath as: $essbasePath"
$key = [Microsoft.Win32.Registry]::LocalMachine.OpenSubKey('SYSTEM\CurrentControlSet\Control\Session Manager\Environment', $true)
$path = $key.GetValue('Path',$null,'DoNotExpandEnvironmentNames')
$pathAddition = "$path;$essbasePath\bin;$baseOraclePath\bin"
Write-Output "Writing Path as: $pathAddition"
setx /M PATH $pathAddition
Write-Output "Expanded Paths: "
[Environment]::GetEnvironmentVariable("ESSBASEPATH","Machine")
[Environment]::GetEnvironmentVariable("Path","Machine")