3 Replies Latest reply on Jul 6, 2017 7:56 PM by JanGLi

    Executing Calculation Script using FDMEE

    JanGLi

      Hi,


      I wanted to execute a calculation script from FDMEE after my data is loaded in  essbase.

      This is my script....

      //ESS_LOCALE English_UnitedStates.Latin1@Binary

      /* GLOBALRANGE */

      SET RUNTIMESUBVARS

      {

      sp_year = "Year";

      sp_period = "Period";

      sp_version = "Version";

      };

       

       

      FIX (

      "Local",

      "00000000-CC",

      "00000000-RCC",

      "No Future 1",

      "B/S",

      "Common B/S",

      "FFL",

      "Closing Balance - Actual",

      "Actual"

      )

      "52070004"= "52070004" + "52010001";

      ENDFIX

      and this is how i am using the parameters in FDMEE.


      The issue is, this rule is getting executed for every month. Kindly guide what i am doing wrong.

       

       

      Regards

        • 1. Re: Executing Calculation Script using FDMEE
          USER1211

          It appears the system is doing exactly what you told it do execute(after load) each time the load rule is used.

          have you tried changing it from data load rule to location or some other item and retesting ?

          1 person found this helpful
          • 2. Re: Executing Calculation Script using FDMEE
            Jeo123

            Generally you'll have better luck with this in the FDM section, but your problem is that while you are passing the parameter to the Essbase Calc, you don't use them in your Fix.

             

            I suspect it's not only running for all periods, but all years and versions as well.

            • 3. Re: Executing Calculation Script using FDMEE
              JanGLi

              Thanks for help guys,

              The issue is with the parameters i defined..

              These are the variables i have declared in calcscript

              sp_year, sp_period and sp_version.

              In FDMEE i am using these parameters.... ss_year, sp_period and ss_version. Silly spelling mistake.

               

              Plus as Jeo123 said... i have to mention the variables in my fix statement too.... like below....

              FIX (

              "Local",

              "00000000-CC",

              "00000000-RCC",

              "No Future 1",

              "B/S",

              "Common B/S",

              "FFL",

              "Closing Balance - Actual",

              "Actual",

              &sp_year,

              &sp_period,

              &sp_version

              )

               

              Plus i don't know why i opened it in consolidation.... changing it to FDMEE.


              Regards and thanks for help.