nQSError: 14025 No fact table exists at the requested level of detail post migration to 11g from version 10

obiee
Uday Shankar picture Uday Shankar · Jun 24, 2016 · Viewed 9k times · Source

the analysis was working on version 10, after migration to version 11, it started giving error

 [nQSError: 14025] No fact table exists at the requested level of detail

Answer

Mark P. picture Mark P. · Jun 27, 2016

11g is more strict that 10g was in terms of a conformed data model. These types of errors almost always stem from something in the BMM being set up incorrectly, so I would start there. There are several things it could be.

Check your levels on the LTS being used. Set any levels to total for things you want the LTS to work with, but that it does not join to. This will force OBIEE to ignore that item in the join criteria, since there is no join. Set these levels on the column as well.

If you have levels set to detail, make sure the physical join actually exists.

Run a consistency check, and look for any warnings where it says no physical join, or logical tables source joins table at incorrect grain (I can't remember the exact wording, but you will know it when you see it).

Related questions

OBIEE Answers not showing results

I recently installed OBIEE 11.1.1.6.0. I imported the repository I had from 11.1.1.5 which was working fine till now. In the administration tool, I can query my data and update the rows, I can connect with the same credentials as the connection …

Read More
kinit(v5): Client not found in Kerberos database while getting initial credentials

I'm working on configuring SSO in obiee 11.1.1.7.14, where in which I'm facing issue in the step while configuring krb5.conf and executing the kinit command. few notes regarding the Active Directory we have more than one domain controller and to …

Read More
How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy …

Read More