Hi,
I know OBIEE is meant for dimensional tables with Facts and Dimensions. Someone asked me to try setup a model for a relational tables. So I tried to model it like below. The green table contains Account information. The purple table contains Customer information. The blue table is a bridge/relationship table that joins the two.
The join between green and blue is a complex join. In the physical layer, I see a red line. But in the BMM layer, it doesn't show any lines. Is this normal for complex joins? When I run an analyse with columns from the green and purple tables, I get error: [nQSError: 14025] No fact table exists at the requested level of detail.
I removed the complex join and tested with a foreign key join and I was able to see a line in the BMM layer. When I run the analyse, I don't get any errors. Is my error because of using the complex join? I researched the error on this forum and it seems many people has it. Most of the suggestion is to check the Content tab. But, I don't understand enough on what to check and how to fix it. Or am I wasting my time in modeling relational tables?