Skip to Content
0
Former Member
Nov 26, 2009 at 04:43 PM

problem: How to make the Data in the InfoCube about two Rows into one Rows

26 Views

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.