Skip to Content
0
Former Member
Dec 02, 2011 at 07:25 AM

remove 1000 prefix before hier nodenames while loading master data

66 Views

Hi experts,

I am loading the master data for profit center dimension in bpc from 0profit_ctr in bw. The attributes are loading fine but the hier nodenames are starting with 1000 which i want to remove. Unless they are removed, there will also be a problem when i next attempt to load the hierarchy. I used suppresscharacter=1000 before the *Mapping section, but that does not work. Though it shows in the package detail that the records have been loaded but when i check the dimension i find that the Hier nodenames are totally skipped.

Kindly note, that i used the approach used in the following thread:-

Conversion: Remove first 4 characters and then ParseINT.

N.B : the attributes don't have 1000 before them , so they should be loaded as it is, infact they are getting loaded properly.

I only need to remove the 1000 prefix from Hier nodename. i have also tried using an if statement in mapping section as

ID(1:4)=*STR(1000) THEN ID(5:14)

but this approach is also not working as the hier nodenames do not have any fixed length and while validating it fails to get to the end of the record, the 5:14 thing isnt effective probably as the lengths vary.

Please help.

Edited by: debchandra on Dec 2, 2011 8:25 AM