Patterns SAP Analysis for Microsoft Excel

[Former Member]

Hi,

We're currently using Analyzer to analyze queries. Now we're rotating Analyzer out and we will use Analysis for Excel. The problem is that we used to filter a variable in a query called 'Notes', in which the customers' comments about our service was given. Analysis for Excel does not support patterns, so if I'm looking for notes containing the word *customer*, it doesn't do anything. I tried using Design Studio, but the issue was the same. Anyone?

[TammyPowlas · Accepted solution]

Hello Justin - Analysis Office does support wildcards - please see Tobias's blog here: https://www.reyemsaibot.com/2016/06/27/analysis-office-variable-operator-contains-pattern/

[Former Member · Accepted solution]

Thanks, I will look into it!