Adding a space to the member alias when importing metadata to Data Integration
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