Data load from DSO to cube fails

[Former Member]

Hi Gurus,

The data loads have failed last night and when I try to dig inside the process chains I find out that the cube which should be loaded from DSO is not getting loaded.

The DSO has been loaded without errors from ECC.

Error Message say u201DThe unit/currency u2018source currency 0currencyu2019 with the value u2018spaceu2019 is assigned to the keyfigure u2018source keyfigure.ZARAMTu2019 u201D

I looked in the PSA has about 50, 000 records .

and all data packages have green light and all amounts have 0currency assigned

I went in to the DTP and looked at the error stack it has nothing in it then I changed the error handling option from u2018 no update,no reportingu2019 to u2018valid records update, no reporting (resquest red)u2019 and executed then the error stactk showed 101 records

The ZARAMT filed has 0currency blank for all these records

I tried to assign USD to them and the changes were saved and I tried to execute again but then the message says that the request ID should be repaired or deleted before the execution. I tried to repair it says can not be repaired so I deleted it and executed . it fails and the error stack still show 101 records.when I look at the records the changes made do not exist anymore.

If I delete the request ID before changing and try to save the changes then they donu2019t get saved.

What should I do to resolve the issue.

thanks

Prasad

[Former Member · Accepted solution]

Hi Prasad....

Error Stack is request specific.....Once you delete the request from the target the data in error stach will also get deleted....

Actually....in this case what you are suppose to do is :

1) Change the error handling option to u2018valid records update, no reporting (resquest red)u2019 (As you have already done....) and execute the DTP......all the erroneous records will get sccumulated in the error stack...

2) Then correct the erroneos records in the Error Stack..

3) Then in the DTP----in the "Update tab"....you will get the option "Error DTP".......if it is already not created you will get the option as "Create Error DT".............click there and execute the Error DTP..........The Error DTP will fetch the records from the Error Stack and will create a new request in the target....

4) Then manually change the status of the original request to Green....

But did you check why the value of this field is blank....if these records again come as apart of delta or full then your load will again fail.....chcek in the source system and fix it...for permanent solution..

Regards,

Debjani......

[Former Member]

Hi Prasad,

Where did you assign the unit as "USD". If the amount/quantity fields having reference units & the ref unit doesn't bring in any data, then usually we face this error.

Its better to take care of such things at staging level. So maintain default value like "USD"(as per your requirement) in the transformation from DS to DSO.

Or since you have alreday loaded the data to DSO, you can write a fields level routine for ZARAMT in the transformation from DSO to Cube.

RESULT = SOURCE_FIELDS-/BIC/ZARAMT .

IF SOURCE_FIELDS-CURRENCY = ''.

UNIT = 'USD'.

else.

UNIT = SOURCE_FIELDS-CURRENCY.

ENDIF.

Delete the red request from the cube & reload from DSO to Cube.

Hope it helps!

Regards,

Pavan

[anindya_bose]

HI..

You have "valid record update, request red"---> when you next time run this DTP with this setting all erroneous records will come to error stack. I think that you already did. But after this did you run the Error DTP?

Error DTP needs to be created from the Standard DTP. Under "UPDATE" tab you will get the option of creating error DTP.

It is the responsibility of Error DTP to bring the record from error stack to Cube. Once that is done change the QM status earlier red request to Green manually. Because that request has all the valid records.

Hope this helps

Regards

Anindya