Hi Experts, I hope this post will be pretty exhaustive to you all to read. but excuse me.
Few Clarification have been noticed with respect to desginer.
I have gone through the designer guide and particularly in the session “Resolving Join Problems” it’s mentioned about there are three Join Path Problem
.loops
.chasm traps
.fan traps
I have clarifications with respect to Chasm Traps. where in the guide meniones with the
example of Beach Universe(Club Database).
Consider only the following tables
Service
Reservation_Line
Invoice_Line
The links between the three tables is a better example of chasm traps.It can be also referred from the guide on Page 239.
and discusses the issues like when
an object(Number of guests) is drawn individually for a seperate query for the join between Service table and Invoice_line Table, the count with respect to the Service of type ‘Sports’ for the corresponding object shows 145
an object(Number of Future guests) is drawn individually for a seperate query for the join between Service and reservation_line table, the count with respect to the service of type ‘Sports’ for the corresponding object shows 8
But in case of the scenario when we try to run the query that includes both paid guests and future guests:
the count will shows for the object No of Guests 188
the count will shows for the object No of future Guests 96
Whereas when i tried to include both the objects in the same query without creating any Contexts to resolve chasm traps i am getting the same result as when we tried to run the query for Individual
Object
means 145 for no of guests & 8 for no of future guests
no cartesian products have been incurred between them
Pls refer page 241 on Designers Guide and try on your individual.
I am using B.O. V6.1
Can anyone help in this regard. I am totally confused that why chasm traps doen’t reflect any issues 
ChasmTraps.doc (47.0 KB)
Testchas.unv (19.0 KB)
karlak 
(BOB member since 2006-11-01)