Error: Invalid Key - Element name(key) whey running TI load process

[SteveOv]

I am trying to load data that was created from an Essbase export.
the file that I'm loading looks like what I describe below. There are quotes around each element except the data value in the last column.

these are my dimensions:
Case, Unit, Division, Geography, Location, Account, Period

the Export I am trying to load looks like this:

"Budget" "Apparel" "Girls" "001" "LA" "1000100" "SEP" 500.00

I created a process to load this however when I run it, I get an error that says:

"Budget Apparel Girls 001 LA 1000100 SEP 500.00",Data Source line (2) Error: Data Procedure line (4): Invalid Key: Dimension Name: "geography",Element Name(key):""

It seems like it doesn't like the " " around the geography member name for some reason. I did try to reload just one line of the file and take the " " off of every item in the file, and by doing that the process did complete successfully. However,
the file is huge I can't do that for every record in the file.
I'm trying to understand why I am getting that error and how I can fix it so it accepts the data export file in the format that it is currently in.
Does anyone have any ideas on this? Appreciate the help.

[MichelZ]

Hi,

Looking at the errormessage I think that your datasource settings are not correct - f.i. field separator. According to the errormessage your data input lines are interpreted as 1 column strings - resulting in a mismatch in the input->cube mapping.

Michel