Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CalcMgrCmdLineLauncher.cmd and ODI

ZhuraFeb 2 2012 — edited Feb 8 2012
Hello!

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!
This post has been answered by JohnGoodwin on Feb 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2012
Added on Feb 2 2012
7 comments
2,401 views