Hi,
I have the following issue in my universe.
I have a tables that joins to 3 others tables as a mnay to 1 joins meaning that all joins coming to the table are the many part of it.
This is causing a cartesian product. How can I get around that to get the correct result ?
Cheers
gogo (BOB member since 2005-06-03)
Did you try creating Alias for the table?
Raja Saripalli 
(BOB member since 2005-12-14)
Not yet, I guess the question is then how could I break this many to many relationship using aliases ?
gogo (BOB member since 2005-06-03)
Moved from “General Discussion” to the “Semantic Layer” forum, which is where Designer is discussed.
To start, you can read from our Designer FAQ some simple info about fan traps and chasm traps. You might also consider reading up on them in the Designer manual – and in any training material you may have gotten from a class.
Anita Craig (BOB member since 2002-06-17)