I am trying to use the file import to import an excel file that has additional data for our Issues cube.
I have 2 questions.
In eazybi we have a custom dimension for a custom dropdown field that we have in jira called Resource Group. I am trying to import a file that provides additional measures for those resource group options. The problem is that in the data import mapping screen, this custom field dimension is not available for selection. I am not sure if that is simply a limitation of the system, or if something is not configured correctly to allow for me to have it as an option.
During a data import from the file, when mapping, for the dimension, is it required to pick a dimension that already exists in the cube, or can I type in a new name so that it creates a new custom dimension in the cube based on the data in the file?
Please let me know if I have explained these questions well enough or if you need more information.