SAP BOBJ multiple data sources

Two data source which has two table has to be merged with a common dimension,then build the report

For acheiving this result. You should have at least one common dimension in both Data Provider and data type should be the same. Then you need to click on Merge Dimension icon from menu bar and Dilouge box window will open which will give you possible Merge Dimension Object list in windows from both query. select common dimensions form both queries click on Merge and then OK and OK.
You will see in Object panel Merge Dimension is created.
cheers.....lionskashif