Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI 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