I have a issue in OBIEE 11g here ,
I am trying to query two columns from 2 different fact tables F1 and F2
the join between these tables is F1 - D - F2 , where D is the confirmed dimension.
so when i am querying for
f1.c1 , d.c1 , f2.c1 , its throwing me up with error
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request
Can you please help me with this issue , am i doing the correct join ??, can we query two columns from two diff fact tables?
Thanks in advance.
do you have hierarchies in place - If so set content level for that.
As work around,
Try applying agg like (sum, or AVG) for f1.c1 and f2.c2 in RPD or in answers & check it. If your requirement is that simple it works well Else follow the above link.
By using complex join in both physical and business model layer
Better to create a single fact in your BMM layer with two facts (f1 and f2). after that join the fact to the dimension (complex join)
Thanks for your responses , I have tried creating hierarchy dimension and assgned levels to the fact sources but i still see the error
Combining 2 facts will resolve the issue but its not the case here as each fact table has about 25 dimensions connected to it , but there are only 2 confirmed dimensions between both facts and the problem here is user wants to see both the fact tables in the same subject area
I have been trying but unable to get the solution.
Can you guys please suggested any other way of achiving this task
Thanks a lot