I have a custom field I want to import into a dimension in eazyBI. On each issue, this field contains several values separated by semicolons (";"). I can get these values to split and import into a dimension no problem.
Here is what I need help with. The individual values in my field are City, Country pairs. So on an issue in Jira, this custom field might contain a string like “Zurich, Switzerland; London, United Kingdom; Paris, France”. I want to import these as multi-level values so that they each go into the dimension under City/Country levels. Right now, all I can manage is to import them as a list of single-level “City, Country” strings.
If I add
levels = ["Country", "City"] and
multiple_values = true at the same time, when I run an import I get a syntax error from the database.
This is what I have:
This is what I get on import:
Is this not supported, or am I just doing it wrong?