BPC Script Logic: Lookup LImitation

[Former Member]

Good Morning,

I have been working with a client on BPC 7.0 NW SP4 where we are trying to build out advanced logic. I have run into a limitation where only one *LOOKUP command is allowed per cube (Error Message: Invalid Lookup Structure: Multi Lookup on same Cube not allowed). I was not able to work around this limitation by creating multiple .LGF logic files and referencing these files with *INCLUDE statements.

Is there a known work around for this? Is there newer functionality that was intended to replace this?

Do you know if this is an issue that will be changed in the future?

Thank you for your input.

Jon Pause

[esjewett · Accepted solution]

Jon,

There is functionality that replaces this, allowing you to define multiple lookup keys within a single lookup statement. Please take a look at the example at the end of this thread ([😉 and at the SP02 documentation addendum ([https://websmp103.sap-ag.de/~sapdownload/011000358700000273492009E/7NW_SP02_Doc_Addend.pdf]).

Thanks,

Ethan

[Former Member · Accepted solution]

That is Exactly what I was looking for. Thanks!

JP

[Former Member · Accepted solution]

Very useful. Thank you Ethan!