Hi guys,
Can any one explains what is a blind spot in Framework Manager?
How does it formed...etc
Let's say you have 3 Query subjects:
1> Customer
2> Order Header
3> Order Line
The join will be like this:
Customer <--> Order Header <--> Order Line
If you make a report that has Customer Name (from Customer QS) and Order Amount (from Order Line QS), then the join may not work properly because you are not involving Order Header here. Since the join is thru the Order Header, the result of the query might be inaccurate. Since Order Header is not visible here, it is called a Blind Spot.
Check out a discussion from some 3,5 years ago:
http://www.tek-tips.com/viewthread.cfm?qid=1352313&page=62
as you may notice, some of the regular Cognoise participants where around to give their 2 cents..
By the way,
Customer <--> Order Header <--> Order Line
would be pretty much like a snowflake with no problems..
Maybe I gave a wrong example ?
Product <--> Order Details <--> Order Header <--> Sales Staff <--> Sales Target
Make a report showing:
Product Name Revenue Sales Target
-------------- -------- ------------
Product Name is from Product
Revenue is from Order Details
Sales Target is from Sales Target
In this case, Order Header is in a Blind Spot !! Result will be that the Revenue will be inflated..