I am at a clinet location where in the client is having a BW running in the APO DP which contains the Sales related Infocube and the forecast data related Infocube. We are building an Enterprise BW which will now get the Sales data from the R/3 to the Sales Overview infocube. Now we need to establish an interface between the Sales Overview InfoCube in the Enterprise BW and to the DP BW. This means, i need to send the actual data from Enterprise BW's Sales Overview Infocube to APO DP's Sales Infocube and need to get the forecast data from the APO DP's forecast InfoCube to Enterprise BW's Forecast infocube. I would like to know the best modeling approach to handle this. As there is no chance to change the landscape we need to follow in giving the intereface. Please help.
Yours answers would be rewarded.