Search specific text in Customer

Is there a way to select only a specific type of customers? There names all contains beside a description, also a unique code. 1 starts with “ABC”, the other starts with “DEF”.
eg: CUST1 - Customer1 - ABC1257899
CUST2 - Customer2 - DEF7854232…

I want to exclude those who have “DEF”


It is possible to create aggregated members using the filter and pattern matching.

NOT [Customer].CurrentMember.Name MATCHES ‘DEF.*’

See here for more on how to create and use aggregated members in different dimensions:

Janis, eazyBI support


thank you it works, just changed the “DEF.*” syntax into “.DEF.