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

Redirect target value in one dimension as a source value in another dimension in DM

Received Response
31
Views
4
Comments

Summary:


Content (please ensure you mask any confidential information):

Hi Everyone,

Using Data management, we are retrieving the member description through SQL mapping. Eg: P001_LE01_CC01. Additionally I have mentioned the SQL code below.

(SELECT DISTINCT DESCRIPTION

FROM AIF_TARGET_APPL_MEMBERS

WHERE DIMENSION_ID=(SELECT DIMENSION_ID

FROM AIF_TARGET_APPL_DIMENSIONS

WHERE APPLICATION_ID=(SELECT APPLICATION_ID 

FROM AIF_TARGET_APPLICATIONS

WHERE APPLICATION_NAME='Vision')

AND TARGET_DIMENSION_NAME='Category')

AND MEMBER_NAME=UD4 )

Member description: P001_LE01_CC01

Then we have a requirement to split that member description based on the delimiter "_" into a few other columns using the "Split" mapping expression available in data integration. To achieve this, it seems we need to redirect the target value "description" as a source value for other dimensions. How we can achieve this? Do we have another way to accomplish this task? Appreciate your answers on this.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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