1 Reply Latest reply on Jul 24, 2014 8:55 PM by sunil k

    block creation on sparse formula

    sunil k

      Experts,

      Wanted to know if CREATEBLOCKONEQ is not really needed anymore in latest version of ESSBASE.

      I am running a simple sparse formula through calculation script which is like below

       

      FIX(@Relative(Sparse1,0),@Relative(Sparse2,0))

      USD = Currency 1 + Currency 2; [This is also a sparse dimension]

      ENDFIX;

       

      I input some values for currency 1 and currency 2 and i see there are 2 blocks

       

      After calculation is executed, i can see values on USD and i can see there are 3 blocks now

       

      I do not have Create Block on Equation setting on at database level.

       

      As per the documentation, this should be needing a CREATEBLOCKONEQ ON; for USD to have result of formula.

      I looked in the log and i do not see USD being run in [TOPDOWN] mode.

      This is on 11.1.2.2

      on 11.1.1.3, i can see it works only when CREAETBLOCKONEQ is turned on.

       

      Is there anything else that could be at play here?

      Would appreciate some expert opinions on this

       

      Regards,

      Sunil

        • 1. Re: block creation on sparse formula
          sunil k

          Just adding to the post

           

          Is it really this NOTE in database admin guide

           

          "If Create Blocks on Equations is disabled for a database and data blocks exist for members on either the left- or right-side of the equation, the formula produces results."

           

          If i read it correctly, it would mean than you do not really need Create Blocks on Equations for sparse calculations.

           

          This note is not present in 11.1.1.3

           

          Regards,

          Sunil