Skip to Content
1
Former Member
Feb 14, 2011 at 08:57 AM

How to use TRIM / LTRIM within LOOKUP function

95 Views

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