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

[Former Member]

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.

[former_member360228 · Accepted solution]

Hi,

Just make use of datasource in your case with document number as one of the key-field, it will suppress those two lines into one on the basis of your document number. Let us know if you need further details.

Thanks,

Arminder

[Former Member · Accepted solution]

Hi, Arminder

I can not find how to set the key-field in the Cube, do you mean in the DSO ?

or can you give me further guide?

thank you very much!

xuehui.

[former_member360228 · Accepted solution]

Oh apologies for that i wanted to write DSO instead of datasource. Just create a new DSO with Document Number as one of the key-field, it will compress them into one line. And be careful while mapping in the DSO as your blank values can overwrite other values. So map those fields which you require from each data-source.

Thanks,

Arminder

[Former Member · Accepted solution]

Hi,Arminder

I had followed your mean, It is works.

Thx.

xuehui.