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!

5

Hello!

Could we get more info on why this solution works? Is there documentation on the proper syntax when using wildcards?

6

Hi @spamik206 ,

That is a great question. I apologize I didn’t get to it sooner.
The Fix Version dimension calculated member iterates through released versions from a specific project, based on the default hierarchy of the Fix Version dimension Project->Status->Version.
The condition below is responsible for excluding all Versions whose name matches the regular expression:

NOT [Fix Version].CurrentMember.Name MATCHES '^20.*-REL-.*'

This part below is the regular expression:

'^20.*-REL-.*'

It tells the MATCHES operator to look for versions whose name starts with “20” ^20, followed by zero or more characters .*, “-REL-” and again, zero or more characters .*. The NOT operator negates the condition.

You can find some information and simple examples here - Regular expressions.

Let me know if I missed anything and if you have any questions.
Best,

Roberts // support@eazybi.com