hi guy!
I have the following case two cubes created in eazybi cloud:
Cube A → is a CSV file with data from Jira Onpremise
Cube B-> connected to a project with the jira cloud instance
Can I create a cube C with this unified data, does this mean joining Cube A with Cube B and making a Cube C?
thank you!
Hi vcsoto,
Welcome to the eazyBI community.
While you can’t directly merge Cube A and Cube B, there could be a workaround to consider:
Create Matching Reports: Design table view reports in both Cube A and Cube B with the same structure, including all the data you want to combine.
Set Up a New eazyBI Account: This new account will host your unified cube.
Use the Report Results Export API: Use the eazyBI Report Results Export API to import the data from Cube A and Cube B reports into the new account by defining a separate REST API data source for each report. (Note: Do not pull data directly from Jira or use the “Issues” cube, as it has limitations that prevent adding new issues.)
Create Custom Mapping: Set up custom data mappings in the new account to combine the imported data into a single custom cube. This new cube would effectively be your desired Cube C.
This method allows you to combine data from different sources (e.g., Jira On-premise and Jira Cloud) without directly merging the original cubes.
Let us know if you have additional questions.
Kindly,
Ilze