Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE converts the "begins with" filter to an equality

Received Response
11
Views
1
Comments

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

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    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}%'