Data model

eazyBI accounts

In eazyBI plugin you can create one or several accounts. One eazyBI account contains set of imported Jira projects data which can be accessed by eazyBI account users (access to eazyBI accounts data is managed separately from Jira security schemes).

If you have few Jira projects and there is no need to limit access to eazyBI reports by different Jira user groups then you can use just one eazyBI account and import all Jira projects in this account.

If you have large number of Jira projects and large number of Jira issues (more than 100,000) then it is recommended to have several eazyBI accounts and import related set of Jira projects in each eazyBI account. As each eazyBI account stores imported Jira data in separate database scheme tables then it could help also for eazyBI reports performance optimization.

 

Data cube

eazyBI stores imported Jira data in a multi-dimensional data cube. Cubes contain fact data that are divided by dimensions and each detailed fact “cell” contains measure values about that fact.

This is example of Issues cube that has ProjectPriority and Time dimensions and has measures Issues createdIssues due and Issues resolved. Each detailed cube “cell” contains number of issues created, due and resolved for particular project, priority and time period.

 

It is easy to illustrate cube with three dimensions but in real eazyBI issues data cube you will have many more dimensions and many more measures which will be described below.

Each dimension has either just detailed level of all dimension members or has hierarchy with several levels. For example, Project dimension has Project and Component levels.

All measures are automatically aggregated (typically as sum of detailed level values) in upper hierarchy levels. If issue can belong to several level members (e.g. issue can have several components) then measure value at upper hierarchy level will not be as sum of detailed level measure values.

Typically each dimension has All level with one All member which aggregates all dimension members.

Time dimension will have two hierarchies - one with YearQuarterMonth and Day levels and another Weekly hierarchy  with YearWeek and Day levels. You can add also Fiscal time hierarchy with Fiscal year, Fiscal Quarter, Month, Day and define the first month of the fiscal year.