Issue :: Duplicate records in cube against a single record in DSO

[former_member226000]

Hello experts ,

I am facing an issue in reporting cube contents through BEx. I have below data in DSO and subsequent cube.

DSO Contents-

                         Field A     Field B     Field C     Amt1     Amt2     Currency

Record 1          A               B               C          100          100          D

Cube contents-

                         Field A     Field B     Field c     Amt1     Amt2     Currency

Record 1          A               B               C          100          0          D

Record 2          A               B               C           0            100       E

I have checked transformation between DSO and Cube and there is no routine between these amount fields. Please help me in getting a similar data record in cube as well.

-Mandar

[Former Member]

Hi Mandar,

As already  told by others in this thread, it seems due to the currency mapping.

both KFs are having same currency unit assinged it seems, whiel creating KF. but your amounts are coming different currency.

so. create the second amount KF with differnt currency object. and in infocube , map the correct curreny field.

Regards,
Sakthi

[former_member226000]

Sorry Sakthi. I didn't get it. Can you please elaborate ?

[Former Member]

Hi Mandar,

I thought you are having 2 currency fields in source as below:

Amount_KF1 , Curr_field1, Amount_KF2, Curr_field2.

Your both amount KFs have the same currency/uom (lets say 0DOC_CURRCY) assigned . So while mapping  in the infocube, respective currency fields mapped to the same target(0DOC_CURRCY). I thought this could have caused some issue.

But you already confirmed, you have only one currency in your source, so you can ignore this.

Regards,

Sakthi.

[KodandaPani_KV]

Hi,

it should in one records in cube.

how many request in cube one or two?

delete all reqeust form cube put it in the one request in cube.

then check the data in cube.

Thanks,

Phani.

[former_member226000]

Hi Phani ,

As I have informed through data , there is only 1 request in the cube. Data shows two rows having different currencies.

-Mandar

[KodandaPani_KV]

HI,

in DSO how many currencies is showing in active data table?

check the psa and dso active data table and cube data for specific record.

Thanks,

Phani.

[former_member226000]

Hi Phani ,

In DSO Active table , only one currency is appearing.

-Mandar

[RamanKorrapati]

at cube transformations please check if any rule groups exist.

[former_member226000]

Thanks . There is neither Start/End routine nor field routine for amount key figures.

[RamanKorrapati]

I asked about rule group have you checked.

Based on rule group same record can be splited and assign amount values to another key fig.

please check about rule group at your transformations.

[anshu_lilhori]

Apparently it seems the issue with the currency object.Please check if the same keyfiugre infoobjects are used in DSO And cube or not.

Regards,

AL

[former_member226000]

Thanks Anshu for quick reply. I am new to SAP BW currency conversions. Can you please tell me how to check this ?

-Mandar