Calculated member that filters Epics which contains a parent

Questions & Answers
1

Hi everyone, would you help me to fix this issue. I wish to create a calculated member that returns only epics which contains the issuetype Macrotema as parent.

Here’s what’ve done so far:

Added that below on the advanced scripts:

[jira.customfield_macrotema]
name = "Link Macrotema"
outward_link = "part of macrotema"
issue_type = "Macrotema"
dimension = true

…

and tried the following code:

Aggregate(
  Filter(
    [Issue].[Issue].Members,
    [Measures].[Issue type] = "Epic"
    AND
    [Measures].[Issues created] > 0 
    AND
    Not IsEmpty([Link Macrotema].CurrentMember)
  )
)

Unsuccessfully so far… I keep getting “Aggregation is not supported over a list with more than 10000 predicates” or “No data found”

2

Hi @stefano.matos

Thanks for the details!

In this case, you should avoid creating a new member in the Issue dimension as the number of members aggregated is very likely to exceed the Aggregate limits.

Instead, you can create a new measure in the Measures dimension with a formula like this:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    (
      [Measures].[Issues created],
      [Issue Type].[Epic]
    ) > 0
    AND
    NOT IsEmpty([Issue].CurrentHierarchyMember.GetLinkedMember('Link Macrotema'))
  )
)

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