Hello Experts,
I have a problem using a LOOKUP function within script logic.
Following scenario:
I need to multiply two base cubes using a combination of DESTINATION_APP and LOOKUP function and I want to write the result into a target cube.
Concerning my base cubes I have the challenge that I don't have a direct matching dimension to get values via LOOKUP function.
Let's say I have cube 1 with dimension called "PRODUCT" and member-ID "PD_123456". For this record I want to get another value from cube 2. The challenge is that I have no dimension called "PRODUCT". Instead, I have a dimension called "MATERIAL". Member-IDs of this dimension equal dimension PRODUCT except the prefix.
Though, for product "PD_123456" I want to lookup a value from another cube by matching material "MA_123456".
If I don't want to change my data model, is it possible to get values via lookup, e.g. by using TRIM or LTRIM functions. I have searched and tried several possibilities, but nothing worked.
Could anybody help me how to use LTRIM within a lookup function?
Best regards,
Stefan