Skip to Content
Author's profile photo Tammy Powlas

Contains Pattern

For the longest time, I understood that Analysis Office did not support this feature.

I happened to be reviewing the SAP Help recently, and found that SP4 supports Contains Pattern:


“Contains pattern (for example, all values that begin with A)* A” Source: SAP Help

I tried it as follows:



It seems to find it:


This is a very simple tip from reading the SAP help.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mike Howles
      Mike Howles

      Nice tip.  Would be awesome if it handled regular expressions 🙂

      Author's profile photo James Batchelor
      James Batchelor

      This might allow the filter by member box to be reduced to the Contains Pattern list..but if you simply type in the pattern.. ie =abc* into the variable prompt and hit go..its ignored.  At least in 1.4Sp5.  I just ran a query with a prompt for sub cat=1234*  and got everything back regardless of the pattern I asked.

      the point of patterns is to not need to select every thing.  In my case I need to apply a list of sub categories with the pattern and well...if we add more sub cats with that pattern, they will be missed the next time the query is run, unless I search and select the new list...defeats the point.

      variant creation is the same way.  If I create a variant that needs 123*, 567*, and 987*  then any thing meeting those criteria will be returned.  Currently AAO doesn't do this like bex does.

      Hopefully this comes soon...its holding adoption back at our site.


      Author's profile photo James Batchelor
      James Batchelor

      To update this...and following:

      Re: Syntax for entering values "contains pattern"

      Adding these registry settings did add a CP and !CP to the operator list in the prompt screen.  It appears to the cases I have tested so far.