Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.