I am getting this error message when trying to export data to Essbase using FDM.
Error - Duplicate members from same dimension on data records.
Though this error looks quite straight forward, I could not find any thing in the data file to indicate the same. I even tried loading a single row data, but still got the same message.
What other things I should be looking at to fix this issue?
There are one or two previous threads on this, but this might give you some help to start with as it links to an esssbase document which gives suggestions for the error message: Error in dataload- Duplicate Members From Same Dimension On Data Record
another thread indicated that the first record had a blank in it and by re-sorting to have the first records with all fields populated resolved the issue (not sure on this one).
from the FDM side:
1. Are the dimensions correctly mapped in the Essbase adaptor?
2. Are the dimensions in the correct sequence for loading to Essbase.
3. Does the same value appear In more than one field (Can't remember but i think essbase didn't use to allow the same member name across dimensions).