OBIEE 11g: The Criteria Column is Not Included in the FILTER Expression (Doc ID 2116539.1)

Last updated on MAY 03, 2016

Applies to:

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

Symptoms

On 11.1.1.9.0 version of Oracle Business Intelligence Enterprise Edition (OBIEE) , the below scenario is noticed:

FILTER("Base Facts"."1- Revenue" USING filter_expressions)

-It is expected that the Column Formula section would show the following:-

-That is, the FILTER expression is not overwriting the original measure Column, and the "expr" place-holder is not replaced by the original measure column.

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