How about using the split function, refer Page 272-273 of FDMEE admin guide, check if it helps.
strDelim = ";"
strSample = "a;b;c"
firstPos = strSample.split(strDelim)
secPos = strSample.split(strDelim)
thirdPos = strSample.split(strDelim)
Thanks for the reply,
We are on cloud environment, can you please let me know where can we write this script.
I am not able to see the script editor in cloud.
Scripts are not available on cloud for security reasons. You don't need them, anyway. #FORMAT maps will do exactly what you want.
Given your example where 003-0000-00000-10101-000-000 is the source and 003-0000 is the target entity:
The entity map #FORMAT("????????") returns the first 8 characters, or 003-0000. Have fun.
Thanks for reply,
Where can I write this, is it in Import format Add expression?..there I can see 2 Expression types as Fill and FillL. which one to use.
And how to write for other dimensions in source value 003-0000-00000-10101-000-000
means what should be taken when i am writing for cost account, account is at 16th level , so what should be filled at front parts .003-0000-00000-10101-000-000.
0000 is cost center for target.
10101-is account code for target
000-000 are ICP.
This is done in the mapping, not import format. Look in the admin guide under #FORMAT mapping. That will tell you everything you need to know.
I have been running into the same issue with a new PBCS implementation. I've tried #FORMAT mapping, but there is a bug that prevents it from skipping (#) the first character. Also, if you need to do other mappings on top of breaking apart the account segments, it may be difficult or impossible with #FORMAT.
Instead I wrote a custom GL trial balance report in Fusion Cloud Financials. The custom report,provides each segment in its own column exactly as I need it to map into Planning dimensions.
Thanks for the reply, we had successfully created the #format Mappings in Mappings for Flat file regardless of source fusion configuration.
And now we have created a source configuration and with the same #format mapping rules we are loading data from fusion GL to FDMEE, we have extracted and noted the Process ID which generates from Fusion and loading it through Load rule in FDMEE, but we are able to go forward, getting communication error.
Please let us are we missing some thing.
We are getting below from ODI log.
COMM_LOAD_BALANCES (69501) fails with return code 7000.
ODI-1226: Step FAILED - Invalid Source System fails after 1 attempt(s).
ODI-1232: Procedure COMM Finalize Process execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
Can you please help us.
Any help please.
That's a separate issue. Please mark a Correct Answer in this thread, and then start a new thread.