fdm multiload using text file
I am trying to load a file having multiple period (in same year) using FDM to Essbase. However instead of loading the data in different period it appends (accumulates) the data in same period which is always start period. There is no error duing load, I think I am missing a period seperator somewhere.
Following is my text file.
CONSOL
ACTUAL
Jan - 2012
2
R,M
1,c,2,3,4,a,v
hsp_inputvalue,E01_101_1110,BAS,Local,Working,509110,1111
Feb - 2012
1,c,2,3,4,a,v
hsp_inputvalue,E01_101_1110,BAS,Local,Working,509110,2111
Thanks.