Error while Loading data from ODS to Cube

[Former Member]

Hi,

We are trying to load data from ODS to cube.

There is a currency translation/ unit conversion from Document currency to Statistics Currency. We have defined the exchange rate for the same.

While trying to load the cube we are gettig the following error.

"Error in the unit conversion. Error 110 occurred "-An error occurred in the conversion of units. Currency units were converted. The error occurred in routine r0028_ZNETVALU, whilst processing data record 420.

Kindly help us resolve this issue and also let us know how we can check the erroneous record when we are updating from ods to cube.

Thanks and regards,

Sahana

[Former Member]

Check in the TCURR & TCURC table for exchange rates & currency codes and try to compare those with PSA data fior its availability.

Hope it Helps

Chetan

@CP..

[Former Member]

Hi,

Suggestion out here check for the message class and try finding specific note for the same or let us know the message class we can help you out.

Check the whether valid currency translation is maintained. Means when the values are beeing converted the currency translation which you have mainted lies between the valid from and valid to date.

Hope This Helps!!!!

[Former Member]

Hi Sahana,

Semeed be as an specific error on record number 420.

I suggest you go to PSA and see with is the difference unit related, with the record #420 and the others.

Hope this help