Loading mixed case hierarchy nodes from BW to BPC

[srikanth_ramachandran]

Hello All,

Am facing a challenge when loading a BW hierarchy to our BPC (10.1) system. The issue is that we have BPC dim set up to allow lowercase letters from the outset. However the BW hierarchy is always set to create values in upper case only (SAP-BW default behavior). I'm using logic in the conversion file to transform the uppercase node to it's corresponding mixed case value. I have successfully used this method before for base members. But it does not work for the hierarchy nodes. Any ideas on what I am missing?

Thanks

Sri

Here is the snapshot of the conversion file logic:

(where ZSAPLE2 is the BW source infoobject )

EXTERNAL INTERNAL
ZSAPLE2*W_BR_ADJ *w_BR_ADJ
ZSAPLE2* *
PARZZSAPLE2* *
0HIER_NODEM_AUSTRALIA m_AUSTRALIA
0HIER_NODEM_JAPAN m_JAPAN
0HIER_NODE* *
PARZ0HIER_NODEM_AUSTRALIA m_AUSTRALIA
PARZ0HIER_NODEM_JAPAN m_JAPAN
PARZ0HIER_NODE* *

[srikanth_ramachandran]

Error is as below:

Member 0314 of dimension ENTITY has an invalid hierarchy parent 'M_JAPAN'

Also tried javascript in the conversion file -

0HIER_NODEM_AUSTRALIAjs:%external%.toString().replace("M","m")

[srikanth_ramachandran · Accepted solution]

Never mind - I was able to resolve this ... was making a mistake in the conversion; missing the statement

PARZZSAPLE2M_AUSTRALIA m_AUSTRALIA (and so on)

[former_member186338]

First - never use "Insert File" instead of correct "Insert Image" - your post is unreadable!

Second - provide full info: transformation and conversion files for both master data load and hierarchy load!

[srikanth_ramachandran]

Adding attachment:

conversion-h.png

[srikanth_ramachandran]

Here you g

Here you go Vadim - the ENTITY_NODENAME sheet is the first screen print. Let me know what else you need.

[srikanth_ramachandran]

And master data load TRFN -

[srikanth_ramachandran]

as above

[srikanth_ramachandran]

Updated transformation to load hierarchy - still doesnt work