Skip to Content
avatar image
Former Member

Variable assignments using LOOKUP feature in BPC Script Logic

Hi Experts

I am trying to run a script where the scenario is I want to lookup a rate from the system and then create a record using that rate. To retrieve the rate, I have used the lookup feature (script in 1.txt attached).

You will see that I have hard coded the time dimension. That works; however, I want to run the script using a time variable. To do so, I included the two lines currently commented out in the dynamic script, and marked the time statements in the LGF file as


This doesn't work. It gives me an error saying "

RUN_LOGIC:Members invalid On Dimension(TIME)


Do I surmise that lookup functions dont work with variables?



1.txt (1.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 27, 2016 at 07:56 AM

    First about LOOKUP: If you don't specify some dimension in LOOKUP definition then the member of current record in WHEN/ENDWHEN loop will be used. Simply don't specify TIME in LOOKUP!

    Second - incorrect advanced script:


    Has to be:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2016 at 07:48 AM

    am guessing the answer is going to be this?


    In general you can't read the value by LOOKUP and use it in some variable. No way!"

    Add comment
    10|10000 characters needed characters exceeded