I am using text output file from essbase to be imported to HFM using multiload
The separator is tab for records.
It seems i need to use tab separator in row 6 of text file (multiload) for dimension tags because separator should be same as in data records
Is this true?
When i am using Tab as separator for row 6 also ,no data gets loaded using multiload.
But when i convert my file separator and row6 separator as comma then it works.
But i need to use tab separator.
Second point is i need to replace #MI with 0in event ecript
Will i need to create new file(with mi replced with 0) in event script to do the same