How to group by Project Components with JIRA and eazyBI

To group all components which match a name, for example “Arte”, we can define a new calculated member in dimension “Project” using function Aggregate(). Aggregate({ Filter( [Project].Members, [Project].[Component].CurrenthierarchyMember.Name MATCHES “(?i)arte”) }) In the screenshot example, we can see a lot of components from all projects called “Arte” or “arte”, to know the Estimated time by…

Read More

How to calculate “Lead Time” or “Real Average Resolution Days” with eazyBI and JIRA

(IMPORTANT UPDATE OF THIS POST: See How to calculate “Lead Time” or “Real Average Resolution Days” with eazyBI and JIRA (Part II)) The default calculated measure of eazyBI “Average Resolution Days” counts until the last Resolution filled ( not until the first value of the Resolution field), then if you set a new Resolution from “Resolved”…

Read More

Two tricks to improve the performance and security of your Jira Server 7.4

There are two tricks to improve the performance and the security of a large Jira Server 7.4 For the first “trick“, we can develop a little Jira plugin, or we can set a “Script Fragment” with the plugin Adaptavist Groovy Scriptrunner. The purpose of the improvement is to avoid problematic JQL queries. In Jira, by default,…

Read More

How to create a general modification in the Jira REST API creating a plugin

Here a fantastic post of Marjan Sterjev from the Company InterWorks. JIRA REST API User Impersonation JIRA is one of the best, if not the best, task management systems on the market. Besides JIRA’s powerful out-of-the-box features, the whole product has rich add-on (plugin) mechanism that can help you customize many JIRA aspects. JIRA exposes REST…

Read More