I have run the import multiple times: once after unchecking the Delivery Team field in my import settings, then again after checking the field. Then I deleted all of the data I’d imported and tried a fresh import.
But, when I attempt to import data from a spreadsheet & attach to my custom field, it’s not in the list of available Dimensions:
When I try to type in the field & run an import, I get an error:
Dimension “Delivery Team” for “Delivery Team” is not available for import
Dimension “Delivery Team” for “Sentiment (Emoji)” is not available for import
Dimension “Delivery Team” for “Comments for Management” is not available for import
It looks like you’re trying to create a new dimension in the Issues cube by defining an empty custom field and then importing data from a spreadsheet. This is not allowed in the Issues cube, which has built-in integration with Jira and is a protected cube with specific limitations.
What you can do:
Add properties to existing dimensions (that come from Jira)
Add new measures
What you cannot do:
Create entirely new dimensions
Import additional properties for multi-value custom fields
Your options:
Use an existing Jira dimension: If “Delivery Team” is already a custom field in Jira, and it is a single-value field, then it can be imported with separate_table = true setting and properties can be added from the spreadsheet.
Create a calculated dimension: If you need a dimension that doesn’t exist in Jira but can be calculated from other fields, you can create it using JavaScript calculated fields.
Create a separate cube: If your data doesn’t relate to existing Jira dimensions, you can create a new data cube by specifying a different name in the “Cube name” section when mapping data.
Let me know if you have additional questions on this.
I wasn’t attempting to define an empty custom field. I’d already defined the field and used JavaScript as part of the import to create the calculated dimension in Jira. What I wanted to do was then attached properties to that calculated dimension. Based on your response, it doesn’t seem as though I’m able to do this because it’s not actually a dimension that exists in Jira.
Based on your response, I didn’t realize that a new, separate, data cube could be created by entering a different name in the “Cube Name” … I didn’t see any reference to it on the mapping data page you mentioned, but I did try it and it appears to have worked.
One issue I ran into that I’m hoping solve is this: I wanted to call one of the columns from my spreadsheet “Delivery Team” but I was prevented from using that. I’m guessing it may be because my Jira Data cube already has a field with that name. Would that be correct?
Is there any possible way to have the same name for a field across two cubes and treat them like the “same” field on a dashboard? It would be ideal to be able to put a report generated from this spreadsheet together on the same dashboard with reports generated from Jira and make the “Delivery Team” field a Common Page drop-down for the whole dashboard.
Hi,
My apologies for the incorrect assumptions.
Most likely the main reason you could not import additional properties was not because the dimension does not exist in Jira but rather because it is defined as a multi-value custom field. If you can calculate a dimension from existing dimensions and attributes—and this does not affect the level of detail (granularity) at which your measures are analyzed, that calculated dimension is treated the same way as a custom field from Jira.
Just to double-check your case — can a single issue be assigned to multiple Delivery Teams, or is there always only one Delivery Team per issue?
Can a single issue be assigned to multiple Delivery Teams, or is there always only one Delivery Team per issue?
A single issue can be associated with multiple Delivery Teams.
Does that mean because the spreadsheet I’m importing typically only has one team in my column, I can’t re-use the same field across cubes? Ideally, I’d like to have a single common-page Delivery Team drop-down at the top of a dashboard that’s displaying Jira data on one report & data from my imported spreadsheet on another report.
Hi skyros,
If Delivery Teams ir a multi-value field, at the moment it is not possible to import additional properties. We have such feature in our backlog and I will add your vote to it, but there is no straightforward workaround at the moment. Since Delivery Team is dimension in the Issue cube, it is a protected dimension and you can not create another dimension with the same name (as dimensions are identified by name in eazyBI).
One approach you could take is to create a separate cube, for example “CUSTOM”, where you import the “Delivery Team CUSTOM” (different name!) dimension along with the required properties from your spreadsheet.
Next, create a report in the Issues cube that includes the delivery team name and the necessary data (I suggest using custom calculations for unique names and changing the dimension display name as well).
Then either export it as csv or use the report results export API to later import the data from that report as REST API source into the “CUSTOM” cube. Map the report “Delivery Team” column to the “Delivery Team CUSTOM” dimension selecting “Name column” and “Skip missing”. See more details here, where it is done the other way around: Videos: data mapping
While it’s a somewhat limited and cumbersome approach, this way you can create a report that includes both Delivery Team properties and selected measures from the Issues cube. Let me know if you would want a mock-up example how to do that with demo data!
Thanks for adding a vote to the feature request. We’ll have to consider the impact of the options you provided both from a maintainability and usability perspective.
I assume I reply in this topic if I have more questions or want support with what you’ve described?
Hi skyros,
If your question is general, feel free to post it here in the community.
For urgent or highly specific issues, you’ll likely get a faster response by contacting our support team directly at support@eazybi.com.
