OBIEE 11g: Unexpected Results may be Returned When Using "is between" Filter

(Doc ID 2257098.1)

Last updated on APRIL 20, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

You are using OBIEE 11g with Essbase as the data source.
And you have assigned an alias name to each members in an dimension in the Essbase data source.

When using the filter "is between" to limit the members in the dimension, results are not returned even if matching results exist.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms