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
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 a comment