Hi OBIEE forum,

in my business model i have 2 fact tables (Fact A and Fact , and 2 dimension tables (Dim A and Dim . Dim A is joined to Fact A and Dim B joined to Fact B. Note: Dim A is neither joined to Dim B nor Fact B and Dim B is also not joined to Dim A or Fact A.

Now when i tried creating a report with 3 columns from Dim A, it works, can see data. But once i added a column from Dim B, i am getting this "nQSError 14025 - no fact table exists at the requested level of detail."

Please throw any suggestions to make this report work.

Thanks in advance.