Oracle Communities

Oracle Analytics and AI

Child Item

How to create a logical join with two facts and a confirmed dimension?

Karthi_obiee

Hi All,

I am trying to create a logical join with two facts and a confirmed dimension.

However I see this error message when I create an analysis by pulling one column form each table (Fact1, Fact2, Dim1).

State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail:

I am expecting the OBIEE server to generate the query some thing like this, please suggest how to achieve this.

Select

Fact1.column1, Fact2.column2, Dim1.column3

from

Fact1, Fact2, Dim1

where

((Dim1.code = Fact2.code) and (Dim1.code=Fact1.code));

Thanks!

Find more posts tagged with

Accepted answers

All comments

Robert Angel

Can you also show us the physical joins?

Can you also show what has been modelled on the dimension hierarchies in question and the settings on the table source for the fact / dimension relationships in question?

Gianni Ceresa

When you use conformed dimensions and multiple fact tables, your business models require hierarchies and you must set content level based on what fact exists at what level of detail.