1 / 2

EazyBI main concepts (cubes, dimensions, measures and members)

EazyBI is a powerful report, chart, and dashboard app for Jira. It uses a straightforward drag-and-drop tool for analysing and visualising your JIRA issue data. You can analyse Jira issues by standard built-in fields ( , , etc) as well as custom issue fields which your JIRA Summary Priority Due DateAdministrators may have set up for you. You can identify trends and top/bottom performers or start from a summary overview and drill into details. You can create pivot table reports, visualise your data with many chart types, and publish eazyBI reports as gadgets on JIRA dashboards or in Confluence pages.

EazyBI also supports JIRA Software (Agile) custom fields (Sprint, Epic and Story Points), Jira Service Desk custom fields (with SLA metrics), Tempo Timesheets custom fields and work-log attributes. You can import additional data from CSV or Excel files, as well as from SQL and REST API data sources and combine them in reports and charts with Jira data.

Overview

Most people are very familiar with two-dimensional data. A good example of two dimensional data is a spreadsheet, which contain rows and columns.

However, EazyBI can have , not just two. Data stored in EazyBI, which is many different dimensionsmulti-dimensional, is therefore visualised most easily as a cube. In fact, JIRA project data that is imported into EazyBI is imported into a datacube or simply a  . Your cube contains all of your Cubedata for the JIRA projects contained in your import.

In the example above, we are looking at the issues cube and looking at the  ,   and Project Priority Time dimensions.

Measures

At the intersection of these dimensions there are data cells which store fact data. This fact data is called a  .Measure

Measures typically hold (integer, decimal etc). These can be accessed either at numerical valuesthe detailed dimension member level or can be aggregated at higher dimension levels. Typical measure examples could be , , , etc.Sales amount Units sold Cost amount Transactions count

As mentioned, the measures stored at each cell in the cube contain fact data. In the example above, I, and arssues which have been created Issues which are due Issues which have been resolved 

e accessible for any priority in any project over any time period.

Exploring EazyBI's demo will give you a account

flavour of what reporting is possible in EazyBI. Explore the dashboard tabs and check out the reports on each tab. You can even click the link in the header of each report in order to understand more about which dimensions and measures each report uses.

2 / 2

Although we are viewing this multi-dimensional data as a cube in three dimensions, we are not limited to three dimensions in EazyBI. Visualising 4 or more dimensions, however, is very difficult to visualise!

Dimensions

Typical cube dimensions are Time, , , Customers Products Locations, , etc. Use Employees Projectsdimensions that are best suited to your business domain.

Each dimension can either just detail all dimension members, or you can define a hierarchy with several levels. For example, a Cus

dimension could have tomers Co, and untry State Customer Name

levels.

All measures are automatically aggregated (typically as a sum of detailed level values) in upper hierarchy levels. E.g. looking at the Sales amount measure at Country level will give total sales amount for this country.

Members

Any item in a dimension is a member of that dimension. Each dimension also has a default member, called All Members, that includes all dimension members (its children).