CalcMgrCmdLineLauncher.cmd and ODI
ZhuraFeb 2 2012 — edited Feb 8 2012Hello!
I am using EPM System 11.1.2.1.0 and ODI 11.1.1.
I work with CalcMgrLineLauncher.cmd for launching business rules (created with Calculation Manager) from the command prompt.
When I work with command prompt (for example, cmd D:\Oracle\Middleware\user_project\epmsystem1\Planning\planning1\CalcMgrCmdLineLauncher.cmd -f:passwordFile /A:planapp /U:admin /D:db /R:Alloc), I have sucessfully execution of business rule and my values are recalculating - i see that in hyperion planning data form.
But my task is: launching business rules with ODI.
I follow the instruction of John Goodwin blog (http://john-goodwin.blogspot.com/2009/07/odi-series-executing-hyperion-business.html with CmdLineLauncher.bat):
I create procedure in ODI with command: cmd /d CalcMgrCmdLineLauncher.cmd -f:passwordFile /A:planapp /U:admin /D:db /R:Alloc.
Then I execute this procedure (The Operator of ODI shows the successful execution of procedure), but rule does not work (not recalculate values).
John and other hyperion's guru, What I need to change in CalcMgrLineLauncher.cmd file to make my result???
The structure of CalcMgrLineLauncher.cmd:
@echo off
SET EPM_PLANNING_INSTANCE=D:\Oracle\Middleware\user_projects\epmsystem1/Planning/planning1
call "%EPM_PLANNING_INSTANCE%\setHPenv.bat"
"%JAVA_HOME%\bin\java" %HP_JAVA_OPTIONS% %JAVA_OPTIONS% com.hyperion.planning.calcmgr.cmdlnlauncher.HspCalcMgrCmdLineLauncher %* /COMMAND:CalcMgrCmdLineLauncher.cmd
P.S. When I work with CmdLineLauncher.bat (f.e. c:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\console\bin\CmdLnLauncher.bat -p:passwordFile -Sserver -Uadmin -rAlloc -f1.xml)
I give the error: "2012-02-02 04:25:27,860 WARN main com.hyperion.hbr.cmdlnlauncher.CmdLineLauncher - Error logging in to Business Rules. The repository has not been configured or you are not authorized to use Business Rules."
I would appreciate any help! Thanks!