Custom field dimension not available in excel import

Hi everyone,

I was trying to import a measure using an Excel Import:
image

The “Team” Dimension is imported as a custom field from Jira:

The “Capacity Sprint 9” field should be imported as a new measure.

I have uploaded the Excel File to eazyBI and assigned the correct Dimension/Measure:

However, upon trying to import the data, I receive this error:
image

I also had to input the “Team” dimension manually, as it was not available in the suggested list of dimensions:

Can you maybe help me out here?

Hi @ghahn,
For the single select field to be available for the additional data import you need to add additional parameters to custom field definition in eazyBI advanced settings:

[jira.customfield_NNNNN] 
data_type = "string" 
dimension = true 
separate_table = true

Use custom field ID instead of NNNNN in the definition above. Add the updated custom field definition to eazyBI advanced settings or ask the Jira administrator or eazyBI admin to do this for you. eazyBI advanced settings are common for all accounts and only Jira and eazyBI administrators have access to them. After that run an import in the account where this custom field is selected for import as dimension. You should be able to select this custom field for additional data mapping after import.
See the related documentation here: Additional data import into Jira Issues cube

best,
Gerda //support@eazyBI.com