Skip to Content
0
Former Member
Nov 27, 2016 at 07:26 AM

Variable assignments using LOOKUP feature in BPC Script Logic

384 Views

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

TIME = %TIME_DIM%.

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?

regards

Shrikant

Attachments

1.txt (1.3 kB)