How to indicate to Insight Advisor that a NL term requieres the use of a search expression in a field?

diagonjope — Thu, 18 Apr 2024 21:31:16 GMT

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é

Re: How to indicate to Insight Advisor that a NL term requieres the use of a search expression in a field?

rusnakpe — Tue, 21 May 2024 11:21:32 GMT

Hi @diagonjope as master items and temporal fields do not support conditions there is only one way - use synonym for dimension (ArticleGroup in your case) with in/not in condition and select all possible terms from dropdown box which defines jewelry.

Then ask IAC with question = Show me gross sales for jewelry.

topic How to indicate to Insight Advisor that a NL term requieres the use of a search expression in a field? in Insight Advisor

How to indicate to Insight Advisor that a NL term requieres the use of a search expression in a field?

Re: How to indicate to Insight Advisor that a NL term requieres the use of a search expression in a field?