Skip to Content
avatar image
Former Member

Contains Pattern issue

Jun 06 at 08:20 AM | 92 Views | Last edit Jun 06 at 08:13 PM 2 rev.

Hello,

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 2.4.3.69599

SAP Analysis for Microsoft Office
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Tammy Powlas
    Jun 06 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 https://launchpad.support.sap.com/#/notes/1920589

    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
      Jun 06 at 11:09 AM

      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.