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.