nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Clarifications regarding EazyBI

Prameesha Samarakoon

Hi,

I'm using EazyBI with JIRA database and projects, I have a few questions that need to be solved

- How can I know the properties for each dimension

- How can I know the field name, table name of the database that is mapped for each dimension/property

- Is it possible to use more than one source for a single report

- How can I specify the hierachy for each dimension

Any help would be much appreciated

Thanx.

Accepted answers

Raimonds Simano1

- If you expand Measures / Calculated members then in "Issue properties" and "Other properties" groups you will see all calculated measures that get available properties for Issue dimension and other dimensions

- All standard eazyBI dimensions use the names as standard JIRA fields, custom dimensions and properties use the same name as corresponding JIRA custom fields. eazyBI does not access JIRA database tables directly - it uses JIRA API to retrieve issues and then stores imported data in eazyBI database which is optimized for reporting needs.

- In single report you can use just one Issues cube in one eazyBI account. If you want to compare different JIRA projects then you need to import them in the same eazyBI account.

- In each dimension there are just standard predefined hierarchies - if you expand dimension and expand "All hierarchy level members" then you can see which hierarchy levels are available.

If you need help with creation of some specific reports then please contact eazyBI support.

All comments

Raimonds Simano1

- In single report you can use just one Issues cube in one eazyBI account. If you want to compare different JIRA projects then you need to import them in the same eazyBI account.

- In each dimension there are just standard predefined hierarchies - if you expand dimension and expand "All hierarchy level members" then you can see which hierarchy levels are available.

If you need help with creation of some specific reports then please contact eazyBI support.

Prameesha Samarakoon

So assuming that I have Issue Dimension in rows and Measure dimension in columns, if I want to have the Key and some custom properties of JIRA called severity Level , SSIR , TBDIR related to a issue how could I access them, or write a calculated member for that? How can I know the property name of it for me to access that through the Properties method?

Raimonds Simano1

For all available JIRA standard fields there are already corresponding calculated measures defined and if you will import additional custom fields as properties then corresponding calculated measure will be defined for it as well.

See example detailed issues report with couple standard property fields and couple custom fields selected.

Nicole Gosling_hjfw3r

Raimonds,

In regards to your statement "eazyBI does not access JIRA database tables directly - it uses JIRA API to retrieve issues and then stores imported data in eazyBI database which is optimized for reporting needs." Is the imported data stored in dwh... tables?

The reason I am asking is I consistently get errors related to dwh tables when I click on 'Analyze' in eazyBI (e.g. Invalid object name 'dwh_13.jira_issues_measures'.) and I can't figure out why. Also, our data analytics team is temporarily pulling data from these tables rather than a direct hit to the Jira production tables to do PowerBI reporting. We do expect to have a data warehouse up in running in the near future.

I am new to the Jira Admin role, so forgive me if there are very basic questions. I was unable to find a support article to answer these questions.

Thanks,

Nicole

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira