You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Adding a space to the member alias when importing metadata to Data Integration

edited Aug 7, 2023 7:58AM in EPM Platform and Freeform 4 comments

Summary:

The product alias is a combination of the product code plus the product description. Both are in a separate field and I want to concatenate those with: space hyphen space, within data integration.

Content (required):

We have a product dimension where we have product codes as a member names and the corresponding alias is: "product code - product description". This dimension needs to be updated periodically and automatically. We've created a data integration which combines the product code column and the product description so that the alias gets populated. This is done through data integration. On the page Map Dimensions in the integration we have two sources which link with a single target; the alias column. The product code has no source expression and the target expression is copysoure(). The second row, which picks up

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!