How to filter version by name using wild cards

Questions & Answers
,
#1

Hi, I am trying create a report to filter out “versions” based on their names as well as their status.

  • Would like to display only “Released” versions. I got this working, using a calculated member
    [Fix Version].[JIRA PROJECT NAME].[Released].
  • Above items gives me ALL released versions in the JIRA project, and in addition, I would like to remove versions based on their name (using a specific pattern). I am currently using this formula, but the results are the same as the point above
    Aggregate(
    Filter(
    [Fix Version].[IC API Team].[Released],
    NOT [Fix Version].CurrentMember.Name MATCHES ‘20*-REL-*’
    )
    )

Here is the sample data for ALL releases/version

RawVersionNames
RawVersionNames484×523 9.65 KB

This is the result of the first calculated member
FilterOneResult

This is the EXPECTED result
DesiredResult

I have tried solution in Filter Fix version by specific name and a status, but it did not work.

Thanks for your help

#2

Hi have resolved this issue. Using the following formula
Aggregate(
Filter(
[Fix Version].[Version].Members,
[Fix Version].CurrentHierarchyMember.get(‘PARENT_KEY’)= “PROJECT-NAME”
AND
[Fix Version].CurrentHierarchyMember.get(‘Status’) = “Released”
AND
NOT [Fix Version].CurrentHierarchyMember.Name MATCHES ‘20.-REL.’
)
)
And using “Version” as per picture below
SolutionToProblem

#3

Hi @carlos.moran,

I am happy you found the solution on your own. Although, the first iteration seems more efficient and only lacks some minor details to return the desired result. Try the formula below:

Aggregate(
  Filter(
    [Fix Version].[IC API Team].[Released].Children,
    NOT [Fix Version].CurrentMember.Name MATCHES '^20.*-REL-.*'
  )
)

Best,
Roberts // support@eazybi.com

#4

Thank you @roberts.cacus , this works!