Hi,Experts I am a beginner in BI. I create a InfoCube about purchasing item data and Invoice Verification , so use two DataSource 2LIS_02_ITM and 2LIS_06_INV, as you know there are same field (purchasing document no) both in 2LIS_02_ITM and 2LIS_06_INV, so I create 2 Transformation and load data from this two DataSource into the Cube. then the data in my cube as below: companycode | purchasing doc no | vendor | purchasing org | currcy | Order unit | net value 4500017174 1000 ST 0,00 1000 4500017174 1000 EUR 159.991.50 How can I compress this two Rows data into one Rows data by purchasing doc no in Cube ? or any other way to do like this, as below. companycode | purchasing doc no | vendor | purchasing org | currcy | Order unit | net value 1000 4500017174 1000 1000 EUR ST 159.991.50 everybody know my means?
hope you all can help me.