Skip to Content
avatar image
Former Member

BPC 10.0 LOOKUP / ENDLOOKUP

Hi all;

I have a trouble with  my script logic,

*XDIM_MEMBERSET CATEGORY = Actual,Plan1,Plan2,Plan3

*XDIM_MEMBERSET TIME = 2012.01

*XDIM_MEMBERSET GOSTERGELER = GiderTutari

*XDIM_MEMBERSET INPUTCURRENCY = TRY,EUR,USD,GBP

 

*LOOKUP Arete_Demo

*DIM CATEGORY = "$Alloc_Plan$"

*DIM TIME = "BAS($Alloc_where_var$)"

*DIM ENF:GOSTERGELER = "Enf_Oran"

*DIM ENTITY = "CSO"

*DIM INPUTCURRENCY = "TRY"

*ENDLOOKUP

*COMMIT

*RUNALLOCATION

*FACTOR = (100+LOOKUP(ENF))/100*(USING/TOTAL)

*DIM MASRAFYERI                   WHAT = BAS(MY);                       WHERE = BAS(MY);                                USING = <<<;

*DIM MASRAFCESIDI                WHAT = BAS(MC);                       WHERE = BAS(MC);                                USING = <<<;

*DIM GOSTERGELER                WHAT = GiderTutari;                    WHERE = GiderTutari;                              USING = <<<;

*DIM CATEGORY                      WHAT = Actual;                          WHERE = $Alloc_Plan$;                           USING = Actual;

*DIM TIME                               WHAT = BAS($Alloc_what_var);     WHERE = BAS($Alloc_where_var$);           USING = BAS($Alloc_what_var$);

*ENDALLOCATION

*COMMIT

The package status : SUCCESS

But the system gives " Reference Error: LOOKUP is not defined"

In BPC 10.0, do you know any change in LOOKUP function?

Cause I tried to write in *FACTOR row: "[LOOKUP].[ENF] " , "[LOOKUP].[#ENF]", and etc..

Do you have any idea about this error?

Please help me.

Best regards

Haşim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 24, 2012 at 05:37 PM

    Hi Gersh,

    Thank you for valuable answer.

    But I wonder the answer of this question, How can I write dynamic script with BPC 10.0 SP05?

    Which functions help me?

    I think it doesn't necessary to write my script, You can look original post. It is clear enough.

    Please help me.

    Best regards

    Haşim

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Haşim,

      You can even use regular selection from TIME Dimension in your DM package and then loop on base members of that selection. You just have to apply that OSS Note I mentioned above.

      It just won't work for RUNALLOCATION.

      Regards,

      Gersh

  • Jul 20, 2012 at 12:53 PM

    Hi,

    please remove the first *COMMIT in your script and try again

    Regards

    Jörg

    hey, nearly simultaneous 😊

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Haşim,

      Sorry, I was wrong. Issue will be resolved in BPC10.0 SP08 (not in SP07 this is already released).

      Meanwhile you can apple OSS Note1726001 that solves it.

      Right now support mostly solves issues first in BPC 10.0 and then downports code to BPC 7.5.

      Hope this makes it more clear.

      Regards,

      Gersh

  • avatar image
    Former Member
    Jul 20, 2012 at 10:36 AM

    Hello Hasim,

    I don't really see any problem with the Lookup statement that you have used.

    Can you try using the Lookup in a simple *REC statement something as below -

    *REC(EXPRESSION=%VALUE%/LOOKUP(ENF), RPTCURRENCY="EUR")

    See if it is working.

    I presume the error that you have mentioned is during validation.

    btw..what is the account dimension in Rate application, is it being defined in the lookup statement? I don't think it is??

    Hope it helps!!

    Add comment
    10|10000 characters needed characters exceeded