Design to Report on 2 conflicting Objects in the Same InfoCube
Hello,
Please I have a problem with developing a suitable data model that can give me my desired data out.
This is my scenario:
Sales Data Line:
Company Code: Country: Country of Final Destination: Amount
001 GB GB 100
001 GB FR 100
001 GB FR 100
002 CH FR 100
002 CH CH 100
002 CH GB 100
Legend:
GB (Britain)
FR(France)
CH(China)
There are 2 views to this data set. The Country view (Sender) and the Country of Final Destination (Receiver).
Sender view for GB sales is = 300
Reciever view for GB sales is = 200.
Question:
How can I in one query report 300 and 200 at the same time. I am also interested in the difference of 100.
So I want to see the Sender View and the Receiver View in the same query?