I’m trying to import data with the REST Connector.
I’m facing the problem that I have several fields with multi enum (array) values given and I didn’t found any way to map them as a dimension to the cube. All other String, Date and so on field are no problem.
Any idea how to solve this?
If you would like to import this as multiple values dimension, you will need to multiply one data entry into several rows where each row contains a single value of it. You can use an underscore.js library function _.map for this.
Here is an example with this function used for REST API import described in our documentation for this.
Please note, multiple value dimensions will cause multiplication of values. This might make it harder to analyze data by distinct count especially when used with custom data import. Consider an option to concatenate array values as one string value as an alternative option as well.
Daina / firstname.lastname@example.org