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 FEBRUARY 03, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.10 and laterBusiness Intelligence Server Enterprise Edition - Version 11.1.1.6.10 and laterInformation 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.