In MDX, How to search for a sub-string using something similar to LIKE operator in SQL?
here’s an example using Contoso Sales Cube, please use this to get started for your scenario:
Note the use of INSTR function.
[Geography].[Region Country Name].[Region Country Name]
,instr([Geography].[Region Country Name].CURRENTMEMBER.MEMBER_CAPTION,'United')>0)
if you are looking for NOT LIKE then replace >0 with =0 and you should get the desired results.
In this post, you saw how to write a MDX query that does sub-string search for you similar to LIKE and NOT LIKE operators in SQL.