Multiprovider data problem

Hi All,

I have a multiprovider which is based on two cubes.There are some characterstics which are simliar in cubes like sales doc,item,ship_to,sold_to.The scenario is as follows:- The key figure on which I am reporting is from Cube2 and there is mix of charecterstiics from both the cubes used in the report,The problem is that cube 2 is not having SHIP_TO party informtion for all the sales doc,items but Cube1 always has ship_to info.So while reporting for some records blank value is coming for ship_to which coild be avoided if the report always take ship_to from Cube1.How it can be achieved?