Can I have one EazyBI cube pointing to more than one data source? I.E., if I have two “identical” jiras in terms of structure, can I pull them both into the same cube for a consolidated report? Further, could I still enable drill down and drill through back to the original Jira system?
Consolidated reporting from different JIRA instances, unfortunately, is not yet supported by eazyBI. Currently, all information in one eazyBI account is synchronized with one JIRA instance from which the import is made.
The technical problems are that two different JIRA instances can have a very different setup with different workflows, statuses and even more complicated - custom fields (custom field references are stored using custom field ID numbers which will typically be different in several instances even if you use the same custom field name).
As a workaround, it is possible to import additional data into main JIRA Issues cube. You may use JIRA REST API which returns JSON results (https://docs.eazybi.com/display/EAZYBI/Import+from+REST+API) or query the other JIRA database with SQL select (https://docs.eazybi.com/display/EAZYBI/Import+from+SQL+SELECT).
Please notice that there are limitations using additional data import: only new measures as well as properties to existing dimensions members could be imported using this import (it is not allowed to create new dimensions or add new members in the existing dimensions).
Ilze / firstname.lastname@example.org
Thank you Ilze. This helps.