eazybi comparing values inside string with multiple value

Its about reporting with EazyBi. The source is  a "Grid Table" in Jira, a complex estructure not compatible with EasyBi.

 

looking for simulate a  table data structure importing a text plain  values separed with commas (cols) and pipes (rows). 

 

My problem is how to get the sala and compare with other of the same "type", example:

 

field one: "col1,col2,col3|col1',col2',col3'|..."

field two: "col1,col2,col3|col1',col2',col3'|..."

 

So, question is how to compare  value in field one, first row col2 with field two, row 1 and col 2  or.... how to get a better way to represent "table values" in EazyBi. 

 

Thanks.

1 answer

1 accepted

By default, eazyBI does not support import of Table Grid values. eazyBI uses JIRA API for data import but Table Grid values are not represented via JIRA API. 

However, it is possible to import additional data to Issues cube with SQL source from Table Grid tables. 

The Table Grid add-on is creating an additional table in JIRA (or any other database you have specified in custom field configuration) and saving the table values in this table. You can find the database table configuration at the top of Table grid custom field configuration, it should be something similar to this: 

gd.columns=isummary,iassignee,isbudget,idue  
gd.tablename=actions  
gd.ds=jira


In this case data from Table Grid add-on is saved in JIRA database table name 'actions' (there is an ID suffix to the table name as well). This means that the values could be queried with an SQL statement from the database, imported to eazyBI via SQL and mapped to JIRA issue cube.

So you need to create your SQL statement according to measures, properties you would like to import additionally to your existing eazyBI issue cube. Measures ad properties should be mapped to current issue cube dimension's members.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

64 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you