BPC 10.1 - Logic Script - Lookup error: "Invalid dimension "" in a "" model"

[former_member645232]

Hi all,

I am getting the following error in my logic script because the system doesn't find the variable "PCON" defined in my LOOKUP statement and I don´t know why this might be happening. Could someone help me to figure out how can I use my Lookup variable within my When statement?

Thanks!

Regards.

[former_member186338 · Accepted solution]

Sorry, but you are trying to invent something not supported!

In WHEN ... IS you can't use lookup and check for a value!

Only dimension members and member properties can be used... Why not to read help?

To check for the value you can use ternary operator in REC:

*REC(EXPRESSION=LOOKUP(PCON)==0 ? if true : if false, target)

P.S. Please read:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/