Upload of Master data(Attributes,Texts and Hierarches) from BW to BPC 10.1

[Former Member]

Dear All,

I have a scenario where I am uploading the Master data (Attributes, texts and hierarchies) of GL account from BW.

When I am uploading the master data it also uploads Text nodes with 1st 4 digits as FSV and when I am uploading the hierarchy it is uploading the same  text nodes as parent in Hierarchy column which is I think is correct as 0GL_Account is having attribute as text node.

I have attached 2 docs of the master data I have uploaded in BPC where I can see IDs with WSFV1*(WSFV is FSV) .

Another document is of Hierarchy in BW.

My query is can we remove 1st 4 digits of FSV while uploading attributes and texts and would the same reflect in hierarchy upload also.

Appreciate if anyone has document on how to upload the GL master data from BW to BPC.

Regards, VM

[Former Member]

Hi VM,

the BPC terms you are using is very confusing. do you mean that the ID is used as parent node in the hierarchy?

you can remove the first 4 characters, you just need to make sure you do the same in both transformation files.

Andy

[Former Member]

Hi VM,

You can try this..........

http://scn.sap.com/docs/DOC-35363

http://scn.sap.com/docs/DOC-35364

Regards,

Raju.

[former_member186338]

Please show your transformation and conversion files to load master data and selection screens.

Vadim

[Former Member]

Hi Vadim,

Thanks for your prompt reply.

Please find files for transformation and conversion files with set selection for both master data and Hierarchy loads.

Regards,

VM

[Former Member]

....Continued

[Former Member]

....continued

[former_member186338]

In the conversion file you can use JavaScript to remove WSFV... and use the same conversion file for master data and hierarchy load...

Vadim

[Former Member]

Hi Vadim,

Could you please suggest JavaScript for removing the WSFV?

Regards,

VM

[Former Member]

Try using the javascript in the external field as %external%.replace('WFSV','') in your conversion file while loading the account hierarchy

Varsha

[former_member186338]

Please, do something yourself! Open any online JavaScript tutorial and read about replace!

Vadim

[former_member186338]

Hi Varsha,

"conversion file while loading the account hierarchy" - not only hierarchy load, but also master data!

Vadim

[Former Member]

oops.. yes Master data as well..