In EazyBI, I am trying to create a calculated member that filters the Zephyr Test Cycle Name

[Gary Ammons]

In EazyBI, I am trying to create a calculated member that filters the Zephyr Test Cycle Name down to those test cycles that name starts with "AutoRun". I am not getting any results. I have tried examples from the documentation and altered them slightly, but with no luck. It accepts the below syntax when I create/update the calculated member, but just doesn't return each of the test cycles that begin with the name "AutoRun"

Here is what I currently have:

Aggregate(Filter(
[Zephyr Test Cycle].[Cycle].Members,
[Zephyr Test Cycle].[Cycle].Name MATCHES "AutoRun*"
)
)

What am I missing? Suggestions? Please help?

[Zane eazyBI Support · Accepted solution]

Hi @Gary Ammons 

To make this work, you should fix the structure for Aggregate() and add function CurrentMemeber to validate the cycle name of each cycle :

Aggregate(Filter(
  [Zephyr Test Cycle].[Cycle].Members,
  [Zephyr Test Cycle].CurrentMember.Name MATCHES "AutoRun.*"
))

More information and some examples of how to construct Aggregate() and use function CurrentMember you can see in the documentation:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/aggregate
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/currentmember

@Choon Keat Seet suggestion is correct as well, use a regular expression .* to get all cycles starting with AutoRun (any character might follow AutoRun for many times on none).

Best,
Zane / support@eazyBI.com

[Gary Ammons]

I see if working now after a recent import to eazyBI. Thank you both!!!

[Choon Keat Seet · Accepted solution]

Maybe try ".*" instead of *

https://docs.eazybi.com/eazybi/analyze-and-visualize/regular-expressions

[Gary Ammons]

Thank you, Choon Keat Seet, for the reply. I tried your suggestion, but still no results. I also went to the link you provided for Regular Expressions and tried all of those, and still no luck. So, now I am wondering if it has anything to do with the amount of directory layers the test cycles are at? Puzzling!!