Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a 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

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.