Skip to Content
0
Former Member
Oct 31, 2011 at 09:58 AM

master data automation issue

26 Views

Hi ,

I have automated master data which pushes member data from BW infoobject to BPC member sheet. Now i have a requirement to add 300 rows which are constants or fixed members and the constant valuess are available only in first 3 columns ie

ID EVEDESCRIPTION PARENTH1

My issue here is , I have few transformations in transf file which adds a prefix to the company code say for ex :US01 to be added as G_US01 in member sheet. I have constant values at the end of other dimension members and the G_ is shown up in the respective company code column, I wanted to know if we can hardcode in transformation file so that i dont need to manually add these members to master data dimension manually.

I am using IMPORT_IOBJ_MASTER & HIER for loading master data and hierarchy data.

Awaiting your early response. thanks in advance.

Regards,

Sanjeev