OBIEE 11g: Error: "[nQSError: 14023] None Of The Fact Sources For [COLUMN] Are Compatible With The Detail Filter" when Running a Report (Doc ID 1563251.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

You are using OBIEE 11.1.1.6.  You have two fact tables (FACT_TABLE_1 and FACT_TABLE_2) and four dimension tables.  The dimension tables are split into two conformed tables and two non-conformed tables.  The former (CONF_1 and CONF_2) are each joined to a fact table, similarly with the non-conformed tables, NON_CONF_1 joined to FACT_TABLE_1 and NON_CONF_2 joined to FACT_TABLE_2.

You create a report using the following tables:

CONF1_NAME
NONN_CONF1_NAME
NONN_CONF2_NAME
VAL_F1
VAL_F2

You add the following filter:

NON_CONF_F2_NAME is equal to / is in 4


But when you run the report, you get the following error:

Error
     View Display Error
     
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14023] None of the fact sources for CONF_1.CONF1_NAME are compatible with the detail filter [NON_CONF_2.NON_CONF_F2_NAME = '4']. (HY000)
SQL Issued: SELECT 0 s_0, "NonConfDim"."Cols"."CONF1_NAME" s_1, "NonConfDim"."Cols"."NON_CONF_F1_NAME" s_2, "NonConfDim"."Cols"."NON_CONF_F2_NAME" s_3, "NonConfDim"."Cols"."VAL_F1" s_4, "NonConfDim"."Cols"."VAL_F2" s_5 FROM "NonConfDim" WHERE ("Cols"."NON_CONF_F2_NAME" = '4') FETCH FIRST 65001 ROWS ONLY

However, a report with the same tables, but a different filter:

NON_CONF_F1_NAME is equal to / is in 4  

works without error.
 

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