on 08-14-2015 1:13 PM
Hi,
Currently we are working on NW BPC 10.0
we are loading ACCOUNT Dimension Hierarchies from BW.
Here ID's coming from BW are Similarly like:
000000010
000023467
00107899
001078998
having different lengths.
In transformation file we wrote like below
ID=*IF(NODENAME(1:4)=*STR(0010) then *STR(AC_)+NODENAME(5:8);*STR(AC_)+NODENAME)
Here 0010 is chart of account and we are using EXTERNAL format while loading the data.
while loading the data we are getting the duplicate records error because of 3rd and 4th records.
Later we used the below conversion file, but we got the syntax error.
Please suggest us how to load the data for varying length ID's.
Regards
Anitha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anitha,
Why won't you replace 5:8 with 5:9 or whatever is the longest ID? Actually it just shows that they have different length, but BW pads them with spaces at the end so it won't get out of string boundaries.
As a rule, it's not a good idea to have members AC_988 and AC_9889 because it can cause some confusion, but if you can't change it in the source system then you have to live with the consequences.
Regards,
Gersh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.