Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE converts the "begins with" filter to an equality

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.
Answers
-
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}%'
0