Need help with MDX

[nauris.malitis]

Hi @Still_Figuring

For this, you’ll need to define a new custom hierarchy in the Issues dimension to have the Initiative > Epic > etc… hierarchy available in eazyBI as well.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/additional-issue-hierarchies

How to create an additional issue hierarchy

Hi @Dinesh_Kotipalli without seeing your Jira configuration and eazyBI advanced settings, it is impossible to comment why the hierarchy is not working. Please send details about your configuration to support@eazybi.com best, Gerda

When you have the hierarchy set up, you can select the Issue dimension in Rows and select the Initiative level to show the Initiatives in rows.

For measure #1, use this formula:

CASE WHEN
[Issue].CurrentHierarchyMember.Level.Name = "Initiative"
THEN
Sum(
  ChildrenSet(
    [Issue].CurrentHierarchyMember
  ),
  (
    [Measures].[Story Points created],
    [Issue Type].[Epic]
  )
)
END

For measure #2 this formula (it will check if the Epic is in one of the statuses that are in the status category “Done” in your Jira):

CASE WHEN
[Issue].CurrentHierarchyMember.Level.Name = "Initiative"
THEN
Sum(
  ChildrenSet(
    [Issue].CurrentHierarchyMember
  ),
  (
    [Measures].[Story Points created],
    [Issue Type].[Epic],
    [Status.Category].[Done]
  )
)
END

Measure #3:

[Measures].[Measure#2]
/
[Measures].[Measure#1]

And choose the Formatting → Percentage.

Let me know if this works as expected!
​Best regards,
​Nauris