Nice idea, but attribute outputted needs processed into a less specific String that can be used between my wildcards and I can't work out how to do this as it's not a calculated metric.
eg [ANDREW LANGWORTHY (ADVICE) D]
needs to be translated as [*ANDREW LANGWORTHY*], which I was doing...
Thanks, that's what I feared.
Had this been in MS access then I'd have been fine, but I can seem to get to a point in Microstrategy desktop where I could write the SQL for each of my 200-300 criteria strings.
It would be good if I could amend an exiting MS report in a freeform SQL mode, but I...
Hi, I'm trying get a dataset back from our warehouse that matches any one of a list of text strings, unfortunately I can't guarantee these Strings and Therefore I'm attempting to use wildcards at either end of the text string, so that I capture all results. It's not working.
On the attribute...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.