OBIEE converts the "begins with" filter to an equality

Question

I am using OBIEE 11.1.1.7.150120.  I am trying to use a filter based on a presentation variable - p_org.  I created a filter condition where the column value "begins with" p_org.  OBIEE converts the filter into an equality ("is equal to" p_org) .  The "no results" filter shows it as an equality.  The nqquery.log file confirms that it used an equality filter.  As a test I tried a hard coded value and it also converts that to an equality.  I can't get "is like" pattern matching to work either.

What needs to be done to make either "begins with" or pattern matching to work?

Thanks.

SriniVEERAVALLI · Answer

I would suggest to go with SQL expression using Convert this filter to SQL and there you write "YourColumnName" LIKE 'p_org%'

or

"YourColumnName" LIKE '@{PSvar}%'