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.
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