You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!