Need help in Calculated member in Epic link

Questions & Answers
1

I am trying to create a report for the status of a specific set of epics. I created a calculated member in the Epic Link dimension to retrieve only the specified epics. However, EPIC-2 is not included in the result because it has no issues or user stories associated with it. I need guidance on how to retrieve all the specified epics, regardless of their issue count. I expect the result to include all the epic values, and I am using the following query:
Aggregate(
{
[Epic Link].[Epic].GetMembersByKeys(‘EPIC-1’),
[Epic Link].[Epic].GetMembersByKeys(‘EPIC-2’),
[Epic Link].[Epic].GetMembersByKeys(‘EPIC-3’)
}
)

2

Hello @kalaiselviv01 ,
This is the expected behavior in eazyBI. The Epic Link dimension only shows epics that have linked issues or user stories. If EPIC-2 has no associated issues, it won’t appear in the Epic Link dimension, even when referenced explicitly in a calculated member.
The Epic Link dimension is designed to show the relationship between epics and their linked issues, so it only displays epics that actually have those relationships.

Alternatively, you can create an aggregate member in the Issue (Issue.Epic) hierarchy like this:

Aggregate({
  [Issue.Epic].[PROJECT NAME].[EPIC-1],
  [Issue.Epic].[PROJECT NAME].[EPIC-2],
  [Issue.Epic].[PROJECT NAME].[EPIC-3]
})

This approach will also include the Epic itself (even if it doesn’t have related stories) and subtasks that are related to stories (if there are any).

Kindly,