Find a substring in an Alias and compare to text
Summary:
We have a standard PBCS license (so no Groovy Scripting) and I am trying to analyse member aliases on the Entity dimension to see if there is a matching substring ("MA ") within them, but nothing seems to be working (Needs to include the space in the string). I need to search everywhere in the alias, not just the first characters & if I'm understanding it correctly, the documentation is suggesting that it only allows for one wildcard in the syntax. Is there any way to do this? I've also tried using @LIKE (and @HspStringCompare) but can't get those
Tagged:
0