Excel import fails with ORA-01722: Invalid Number

I would like to import the attached Excel file, containing the release dates for our Fix Version.Releasedate%20Excel%20file

I configure the import as follows:

  • Cube: Issue
    . Field Name Fix Version
    • Datatype: String
    • Dimension: Fix Version
    • Level: Version
    • Advanced options: Noting selected: Due to limited user doc, I’ve tried my best.
  • Field Release Data
    • Datatype: date
    • Rest is empty

However, when I start importing the data, I aways get the error message mentioned above.

Hi Daniel,

The first column should say that there are Names by which the Fix Versions can be found. Further the Date column should be mapped to the same Fix Version level and specify the Property name. See screenshot below

Here is another documentation page about property import to check out if you did not find that yet.

Please let me know if you have further questions regarding this!
Lauma / support@eazybi.com