Greetings!
I need to be able to specify to Insight Advisor that when a user is asking for information involving the contents of a field, the expression generated has to use a set analysis-type search in the value of the field, instead of looking for discrete values.
For instance, lets say that I have a master measure called [GrossSales] and I need to let users ask for gross sales of "jewelry", but "jewelry" is not a discrete value of a field, rather it is a sequence of characters that appears in several values of a field, such as "BE-02 Men's Jewelry PBA" or "BE-03 Women's Jewelry PNA".
What I need is to generate a expression similar to {$<ArticleGroup={"*jewelry*"}>}[GrossSales].
Can this be done in Insight Advisor?
Please advise.
++José