Blind Spot in Framework Manager?

[srinu1253]

Hi guys,

Can any one explains what is a blind spot in Framework Manager?
How does it formed...etc

[cognostechie]

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.

[blom0344]

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..

[cognostechie]

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..