13 Replies Latest reply on Jun 8, 2018 8:38 AM by Larry's Friday Girl

    IF .. apply to numerous accounts

    Larry's Friday Girl

      Hi,

       

      fix(FY18, Jan:Oct, Working, Budget, @relative("Cost Centre",0), @relative(Entity,0), AccountA, AccountB, AccountC, AccountD, AccountE, AccountF, AccountG, AccountH, AccountN, AccountV, AccountQ, AccountL)

       

       

      &currbudget (

         IF ("open month"->"BegBalance" == 11)

                  &currbudget = #missing;

         ENDIF;

       

       

      endfix

       

       

      I tried the above, where &currbudget is a sparse dimension and AccountA, B, etc are dense.

       

      The syntax is brief, but the result is very slow running, never break on the wisdom of IF on dense - yes!

       

      Is there no way in a business rule to apply the same IF statement to a large block of accounts to replicate the result that I am trying to get ahead, with multiplying the IFs by 12 - in practise it is more than twelve...

       

       

      Anybody going to make my day a better one?

       

      thank you!!!!

       

      Teresa