OBIEE 11g: Error: "[nQSError: 14023] None Of The Fact Sources For [COLUMN] Are Compatible With The Detail Filter" when Running a Report
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.10 and later
Business Intelligence Server Enterprise Edition - Version 18.104.22.168.10 and later
Information in this document applies to any platform.
You are using OBIEE 22.214.171.124. 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:
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:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms