Skip to Content
author's profile photo
Former Member

Contains Pattern issue


I am trying to enable the Contains Pattern option but it doesn't seem to fully work for me.

I successfully enabled CP and !CP in Ao_user_roaming.config by setting <OperatorContainsPattern value=”True” />.

When I connect to a HANA database, everything works and I can use patterns in my prompts.

When I connect to a BW database, the parameters are not available in any case.

Is there any difference between HANA and BW that would explain why I am missing these options?

I am working with Analysis

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Posted on Jun 06, 2019 at 09:14 AM

    HI Fabio - 2.4 is really old; any chance you could upgrade to 2.6 or 2.7?

    Also see SAP Note

    Some limitations per the SAP Note:

    "Note that BW only supports the contains pattern operator for characteristics of type CHAR (not for NUMC, DATS, TIMS).

    In addition, the variable needs to be in selection space (i.e. fix definition for the query on the left side of the Query Designer - as opposed to selection state: set as default value on the right side of the Query Designer)
    Also BW does not support contains pattern operator for filtering."

    Does this apply to your situation?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tammy,

      Thank you for you reply. Yes, I believe that this explains why I was not able to get the operators to show up in BW.