6 Replies Latest reply: Aug 7, 2014 9:54 AM by SreekumarHariharan RSS

    How to scheudle atutomatic run for essbase cube

    user652652

      Hi experts ,

       

      we have essbase cube in Essbase studio and run it manually and it get succeded...now i want to schedule it automatic..how can i do it..? A sample script is

       

      deploy all from model 'Membership Cancel Stats' in cube schema '\Benchmark Cube\Cube\Membership Cancel Stats' with option incremental_load update all preserve all data login $1 identified by $2 on host 'adv-fa-dev-cube' to application 'CNCLDMEM' database 'CNCLDMEM' add values use streaming build using connection 'Benchmark2' keep 200 errors on error ignore dataload write to default;

        • 1. Re: How to scheudle atutomatic run for essbase cube
          KKT

          Have a look at this for reference.

           

          Schedule Essbase Studio

           

          Thanks,

          ~KKT~

          • 2. Re: How to scheudle atutomatic run for essbase cube
            user652652

            Thanks,

             

            what will be the exact command(including loign etc...) with the maxl command(in previous post)

            • 3. Re: How to scheudle atutomatic run for essbase cube
              1006999

              The commands we use for our enviornment to schedule are the following:

               

              login <userid>
              <password> on (server);  

               

              execute calculation
              'ESSBASE'.'FIN_RPTS'.'ClrAct';

               

              import database
              'ESSBASE'.'FIN_RPTS' data from data_file
              '\\\\server\\share\\Hyperion_ABS.txt' using server rules_file 'LD_ABS'
              on error write to '\\\\server\\share\\LDABS.err';

               

              import database
              'ESSBASE'.'FIN_RPTS' data from data_file
              '\\\\server\\share\\Hyperion_EBS.txt' using server rules_file 'LD_EBS'
              on error write to '\\\\server\\share\\LDEBS.err';

               

              import database
              'ESSBASE'.'FIN_RPTS' data from data_file

              '\\\\server\\share\\Hyperion_EBS.txt' using server rules_file 'LD_IS' on error write to
              '\\\\server\\share\\LDIS.err';

               

              execute calculation
              'ESSBASE'.'FIN_RPTS'.'AggAct';

               

              we use win automation to run the calcs

               


              • 4. Re: How to scheudle atutomatic run for essbase cube
                user652652

                Thanks,


                We are gettign the below error when run on unix:

                 

                BPM Connect Status: Success

                BPM Message Reporting:error

                • 6. Re: How to scheudle atutomatic run for essbase cube
                  SreekumarHariharan

                  Hello,

                   

                  You can  create a .msh file for essbase studio which needs to called in batch files

                   

                   

                  For E.G I have created CubeBuild.msh which is embededed in script.bat .The script.bat is being called in Build.bat file

                   

                   

                  deploy all from model 'Test' in cube schema '\Test\Cube Schemas\Test' login $essuser identified by $esspwd on host $esssvr to application $essApp database $essDB overwrite values use streaming build using connection 'TESTER' keep 200 errors on error ignore dataload write to default;

                   

                   

                  Script.bat

                  ==================

                   

                   

                  set d=%date:~-4,4%%date:~-7,2%%date:~0,2%

                  set d=%d: =_%

                  set t=%time:~0,2%%time:~3,2%%time:~6,2%

                  set t=%t: =0%

                  SET ESSBASEPATH=D:\Hyperion\Middleware\EPMSystem11R1\products\Essbase\EssbaseServer

                  set filepath=d:\Backup\

                   

                   

                  @REM ****  ENTER THE USERNAME USED TO LOGIN   *******

                  set essuser=Sree

                   

                   

                  @REM ****  ENTER THE PASSWORD   ********

                  set esspwd=password

                   

                   

                  @REM ****** ENTER THE SERVER NAME ******

                  set esssvr=localhost

                   

                   

                  @REM ******* ENTER THE ESSBASE APPLICATION NAME  *******

                  set essApp=Tester

                   

                   

                  @REM ******* ENTER THE ESSBASE DATABASE NAME  *******

                  set essDB=Tester

                   

                   

                  @REM ******* ENTER THE CURRENT YEAR  *******

                  set CurrYear='"2014"'

                   

                   

                  @REM ******* ENTER THE CURRENT MONTH  *******

                  set CurrMnth='"August"'

                   

                   

                  Build.bat file

                  ======================

                   

                   

                  @REM *** SETTING THE PARAMETERS ***

                  @call D:\Backup\script.bat

                   

                   

                   

                   

                  @REM *** CUBE BUILD ***

                  essmsh %filepath%CubeBuild.msh

                   

                   

                   

                   

                  PAUSE

                   

                   

                  Hope this one help you

                   

                   

                  Thanks,

                  Sreekumar Hariharan