How to automatically add a dummy member under parent in MD to load the actuals of the parent while loading the MD from BW infoprovider?

[pankajkumar_gilda79]

Hello BPC Gurus

   I am trying to load the actual from BW info provider. The DMP run with Warning as status message. There were some rejected records when drilled down I found that there are actuals at parent level captured in ECC. To overcome this issue a dummy member has to be added below the parent level of each WBS Parent member i.e. R_FR01_01 should have a dummy member R_FR01_01_DM.  I want this to automate while loading the MD from BW to BPC. As in future the client may add n number of WBS set in real time.

    Can you please advice me on how to do this? Is this has to be done at Transformation > Mapping or at Conversion file.

Look at the WBS structure:

Regards

KMG

[former_member186338]

If there is some logic to separate required parents then you can create additional master data load with conversion file to create extra members...

[pankajkumar_gilda79]

Vadim,

Yes I can separate the parents. But can you show me how in Conversion file I make use so that I can create the extra member.

For Ex:

My parent member is R_R101

New dummy member can be R_R101_D

Thanks in advance Vadim.

Regards

KMG

[former_member186338]

Not extra member - one line - one member!

Even in transformation file you can use something like:

WBS=WBS+*STR(_D)

in Conversion:

JS: %external% + "_D"