Use more then 2 Insight Schemes

Hello togehther,

We are using Jira Service Management in Cloud.
right now there is a maximum of 1 Insight scheme per Account.

  1. Is there a plan to raise this maximum and make it possibly to use more then 1 scheme?

For the moment is there any workaround to get my use case fixed?

My Use Case:
We have 2 schems. First one is an Insight schema with all organizational information like Sites and Employees. Second one is a scheme for all different types of Licenses.

Now i want to use Eazy Bi as Tool to made monthly reports of
How many Licenses are Used at the side and which users have which license.

At the moment i see no chance to made this report.

Maybe you can help me out with your ideas.

Best Regards and thank you.

Lukas

Hi @lmersich ,

Unfortunately, there can only be one Insight schema per account for now.

The possible workaround for your situation is to import Insight data into two separate intermediate accounts and, in each of them, create reports that give out the available data required for the final report.
Then you might export eazyBI report results in CSV format using REST API (Report results export API). And use this REST API as a data source for some other eazyBI account, marking that the content type is CSV (Import from REST API).

You would need to use the same IDs of a common dimension in both initial reports to allow data mapping in the resulting data cube.

Regards,
Oskars / support@eazyBI.com

Hi @oskars.laganovskis
Your proposal is interesting, but where should I start? E.g. I have an object schema X (“Servers” object type) with attribute type “Object” (object Schema Y). So I need to create a separate account for Object Schema Y and do what?
I tried to narrow my import from object schema Y with AQL to something like “object having inboundreferences(“Name” = “Server”)”. Then I should export results in csv format.
Then I should import this results as new data Source in the first account and do what? How can I match rows with server objects in schema X to Users from schema Y?

Thanks in advance!

Hi @KAbdulina ,
The starting point is to define the requirements of the final report.
Then, you need to create the intermediate accounts and build reports that allow the data mapping between objects - you might use Object properties as object keys.
Then, you might import the results of these reports to the actual reporting account and map the data using the Object keys from different object schemas.
That means building a custom data cube for your reporting needs.

A full description of the existing object schemas and the required reporting needs is required to see the required further steps.

Please contact eazyBI support directly over e-mail with more details.

Regards,
Oskars / support@eazyBI.com