I am using BPC NetWeaver 7.0 SP6
Has anyone discovered a way to import data form a delimited file where account data is stored in their own column? Or are we stuck with the verticle approach?
For instance, I want to import data for multiple accounts from a file that looks like this:
CATEGORY DEPARTMENT TIME DATASRC ACCOUNT1 ACCOUNT2 ACCOUNT3 ACCOUNT4 ACCOUNT5
ACTUAL 123 2009.JAN GLSYS 25 700 566
ACTUAL 123 2009.JAN GLSYS 97 568 544 9
ACTUAL 123 2009.JAN GLSYS 257 897 488 2
ACTUAL 456 2009.FEB GLSYS 958 6
ACTUAL 456 2009.FEB GLSYS
ACTUAL 456 2009.FEB GLSYS 365 12300 1200 14
I know you can use MVAL for the multiple time periods, but I do not think that will work for accounts.
Any assistance anyone can provide would be much appreciated.