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

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” to “Close” statuses, the value will be measured until “Close”. EazyBI counts the resolution time till the last resolution. This is…

Read More

eazyBI plugin settings [Advanced settings] best values for mondrian OLAP

The performance seems better with this values More info in: https://github.com/rsim/mondrian-olap/issues/28 https://docs.eazybi.com/display/EAZYBIPRIVATE/Custom+schema+definition+-+Aggregate+tables https://docs.eazybi.com/display/EAZYBIJIRA/Installation+and+setup#Installationandsetup-Databaseconnection Values info: http://infocenter.pentaho.com/help/index.jsp?topic=%2Fperformance_tuning_guide%2Fconcept_mondrian_properties.html

Read More