Master Data Load from Infoobject - use BW attribute as target ID value

[srikanth_ramachandran]

I have the following situation in my master data load :

Source InfoObject:

ID (Line of Business 4 char)

Description

Attr 1 (Line of Business 3 char)

Attr 2 (Line of Business 2 char)

Attr 3 (Line of Business 1 char)

An example of the source data would be

ZAAB, Support LoB, ZAA, ZA, Z

BPC Dimension:

ID (LoB)

Description

Attr 1

Attr 2 etc.

I need the source data loaded as

ZAA, Description, Attr 1, Attr 2, etc.

Note how the Attribute value Attr 1 is to be mapped to the target ID.

Hope I have explained the scenario clearly enough.

There are two issues I am trying to get past:

1. There are multiple records for the Attr 1 attribute in the source since many 4-char IDs have the same 3-char Attr 1 (e.g. ZAAC, ZAAD, ZAAE, etc.)

-- so we are trying to use the BADI routine to delete adjacent duplicates for Attr 1.

2. Not figured out the correct statement in the transformation file to map ATTR1 to ID. - we are still getting the 4-char values in the BADI interface.

If we use ID = ATTR1, transformation file validation fails with "Duplicate member" error. Since at that point the multiple values situation exists. (I'm guessing)

Any help is appreciated.

Thanks.

Sri

[former_member186338]

Sorry, but not clear! Can you provide data samples?

[srikanth_ramachandran]

Good to hear from you Vadim! Here is a data sample -

Source

ID Descr Level 3 (Attr1) Level 2 (Attr2) Level 1 (Attr3)

ZAAB Credit Admin ZAA ZA Z

In target dim I want to load ZAA as the ID value and not ZAAB.