Trying to import string from google sheet

I am trying to import the string of “Sheet URL” to eazybi to include it in the weekly report that shows other factors … but I cannot import that link … I tried to import it as a dimension or property but neither succeeded.

The following picture shows the data mapping of the columns in Google Sheets, and I hope to help me with this issue.


The missing thing is to have a dimension in the Jira Issues data cube to which you can map each row from your data source. Import of properties create a new attribute to dimension members, so you should have separate member for each row.

If there is no such dimension in Jira, you might need to consider creating a custom data cube, as described here: Data mapping

Janis, eazyBI support

Thanks a lot for your helpful reply.
I created a new cube for the imported data and it seems that the problem has been solved :pray:
If I have another question
Can I import this column as link to lead back into the original google sheet ?


There are two options how to enable the imported link:

  1. It is possible to create the link if you add the property with the name URL to a dimension member. In this case, you need to create a dimension from the column, duplicate the column and map the duplicated column as a property (with the “URL” name). Then clicking on the dimension member should show the Go to source option:

  2. You can wrap the property in a custom measure, generate a correct HTML and apply respective formatting:

The report could look like this:

Janis, eazyBI support

Dear Janis,

Sorry for the late reply.
But I want to thank you very much for your practical and detailed reply.
This works very well for me.

1 Like