4 Replies Latest reply on Nov 15, 2017 2:20 PM by Sidharda Chava

    HP - Use variable in @ALLOCATE

    Ana Teresa Vicentini

      Hi Folks!

       

      I need to use variable as the parameters of @ALLOCATE in a Calculation manager rule. Unfortunately, it is not working (no validation). My version is 11.1.2.4.

       

      Below, an example...

       

      VAR PREMISSA1 = #MISSING;
      VAR PREMISSA3 = #MISSING;
      VAR TESTE_ANA_PREMISSA1;
      VAR TESTE_ANA_PREMISSA3;

      ARRAY PREMISSA2["PRODUCT"];

       

      FIX "N/A - Rateios,"PJ999,"V0,"Actual","UG999","PREMISSA_ANA","NA_EMPRESA","M01","FY17")


          "CC999"(

            PREMISSA1 = @MEMBER("INPUT_ANA"->"PR999"->"PARCERIA NA"); /* it is working! */

       

            IF (@ISMBR( "MD9999") AND @ISMBR("PR999") AND @ISLEV("Parceria",0))
              IF ( "PREMISSA_ANA" == [[TESTE_ANA_SL.BBC20]] )

                PREMISSA2 = @LEVMBRS("Total Prod",0);
                PREMISSA3 = @LEVMBRS("Total Prod",0);
                "RESULT_ANA" = @ALLOCATE (PREMISSA1, PREMISSA2 ,{TESTE_ANA_PREMISSA6} ,, share);  /* if I use PREMISSA2 or PREMISSA3 as second parameter, no validation. If I use ,{TESTE_ANA_PREMISSA6} as third parameter and replace PREMISSA2 to @LEVMBRS("Total Prod",0); it works! */

              ENDIF
            ENDIF
          )


      ENDFIX

       

      I really apreciate any help!

       

      best regards,

       

      Ana Teresa