conditions update
You can add conditions between tables by adding  even number of  keys 

for example if i want to add condition between contractdetail and contractmaster tables 
you can add in conditions box two fields ContractDetail.CustomerID  and ContractMaster.CustomerID 
which will be in the sql command result : 
{ Where ContractDetail.CustomerID=ContractMaster.CustomerID }

notice : the table will give you the last and right result of cube when you fill the four boxes
 
Let me Know if You Have Any Questions
Regards ,
Emad