OBIEE 11g: Error: 'Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request' (Doc ID 1614017.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

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

Symptoms

You have installed OBIEE 11.1.1.7.1.

In the repository, you have three facts and four dimensions.

The facts are:


The dimensions are:


All three facts join to the dimension Dim - Site.
Fact - Adjustment only joins to Dim - Team.
Fact - Pay only joins to Dim - Pay Type.
Fact - Prorate only joins to Dim - Prorate Type.

You have set up hierarchies and the content level sets in the Logical Layer, and have set all hierarchies and dimension keys.
You have set the content levels for the metrics in the logical fact total for any dimensions that are non-conformed. This allows the metric to repeat when used in a query with a non-conformed dimension.

When running queries using these facts with a non-conformed dimension, some work and others fail with the following error message:

Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request

An example of a successful query is:

Examples of failing queries are:

You followed the instructions in <Note:1563251.1> - OBIEE 11g: Error: "[nQSError: 14023] None Of The Fact Sources For [COLUMN] Are Compatible With The Detail Filter" when Running a Report (Bug 11850704) - but they did not help.

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