Master Data loading in BPC 7.5 with prefix

[former_member1147219]

Hi Gurus,

I need a help in master loading in BPC 7.5

Currently we are loading GL account with prefix of A and controlling area(COA1)

BI:0000600000

BPC: ACOA10000600000

I have maintained logic in the transformation file as below. Z001 represents the hierarchy Node.

ID=IF(ID(1:4)=STR(Z001) then STR(A)+ID;STR(A)0CO_AREAID)

Now client has came with new requirement as below

BI BPC

GL Acc 0000600000 A_600000

GL Node Z00113 Z001_13

GL Node Z00213 Z002_13

For the above requirement i have maintained the logic in the transformation file as below. when running master data load package i got the error as

Line 755 :Command failed ; end position is out of record index

ID=IF(ID(1:4)=STR(Z001) then STR(Z001_)+ID(5:12);STR(A_)+ID(5:12))

I need your help in modifying the logic in the transformation file for handling the above requirement.

And also for handling two hierarchy Z001 and Z002.

Thanks

Mahesh

[boo_yenli]

In my case, I made use of the conversion file to achieve that as I had the same error previously as you are having now.

[Former Member]

Hi,

Your command should like:

ID=*IF(ID(1:4)=*STR(Z001) then *STR(Z001_)+ID(5:6);*STR(A_)+ID(5:10))

Hope this helps.

[Former Member]

Try this....

ID=IF(ID(1:4)=STR(Z001) then STR(Z001_)+ID(5:6);STR(A_)+ID(5:12))

Hope this helps and fix your issue.