1 Reply Latest reply: Oct 5, 2013 2:22 AM by Evgeniy.Rasyuk RSS

    Essbase Calculation Script

    dhooan

      Hi Everyone,

      I am trying to calculate Account dimension member and I am not getting any  value. I am using calc script, essbase version 11.1.2.1

      "00000_P" = level 0 member Program dim

      886" = Cost center lvl 0 sparse dim

      100_E = Entity dim lvl 0 member sparse dim

      US= Ledger dim level 0 member Sparse dim

      In formula "Progs_P" is high level member of Program dimension

       

       

      Fix ("Budget","FY14","Working","886","00000_P","100_E","US","Local$")

       

      "50015B" = ("50055"->"885"->"Progs_P"*-1);

      "50015A" = ("ZHR01"->"885"->"Progs_P"*-1);

        EndFix

       

      Thanks,

      T.khan

        • 1. Re: Essbase Calculation Script
          Evgeniy.Rasyuk

          Calc from Source to Target

           

           

           

           

           

           

           

          Fix ("Budget","FY14","Working","886","00000_P","100_E","US","Local$")

           

              "50015B" =  #Missing;

              "50015A" =  #Missing;

            EndFix

           

           

           

           

           

          Fix ("Budget","FY14","Working","Progs_P","100_E","US","Local$")

          "885"(

          "886"->"00000_P"->"50015B" = ("50055"->"885"->"Progs_P"*-1);

          "886"->"00000_P"->"50015A" = ("ZHR01"->"885"->"Progs_P"*-1);

          )

            EndFix