ODS Object Help Please!!!!

[Former Member]

Hi,

Im having the following problem. I have an ODS Object with 80 requests. All the data has been uploaded via excel csv files.

Ive found that request no. 40 is incorrect and I cant delete it without deleting requests 41 through to 80.

How can I :-

1.) Delete request 40 without deleting the above requests.?

2.) Edit request 40 to correct the data.

Note that this was uploaded on Sept 29th and the PSA shows the requests only from 2nd to 4th Oct.

Please Help,

Regards,

Dominic

[Former Member]

Do not delete all the data above request 40. This is a problem many people face and I have done it many times so I can share my experience with all of you here. I will try to give a detailed answer for everyones benifit here.

1. there are two scenerios that you need to keep in mind. From ODS to cube you can have full upload or a Delta upload. From the cube point of view, you can find the corrsopnding request in the cube for that data which corrosponds to the request 40 here and delete it. This will not harm your other request in the cube. So there is no problem here.

2. Now let us look at the ODS which is a tricky area to work. As I said you could have Delta from ODS to cube or a full upload from ODS TO cube.

3. Let us consider the first case when you have a full load from ODS to cube. Either way you need to do selective deletion at the ODS level. In this case find the request no pertaining to request 40 and go to the active table and delete this request based on the same selections.

4. In case you are running a delta from the ODS to the cube, the you need to do the selective delteion in the ODS. here the request id will be ODSRxxx find it related to request 40 in the ODS and do the selective deletion.

5. Now you must have your csv file (fresh) with correct data related to request 40. Load your ODS again

6. Now run the Delta from the ODS to the cube or a Full load from ODS to cube wiht the selection conditions.

7. You are all done.

Cheers !!

[Former Member]

Just to add to my previous note. Also keep in mind in the case of ODS (Delta loads) this request of change log is in the PSA not ODS. Even though you will be working on the ODS but change log data will be deleted form PSA automatically.

Cheers

[Former Member]

Thanks, I used the selective deletion option in the ODS.

[Former Member]

Hi,

Thanks for the points. Anyway, if you already solved your issue, please close the thread (by choosing "Solved it on my own" on your first post).

Regards,

David.

[Former Member]

Hi Dominic,

If you make further delta load from ODS to cube (ODS), then I'm afraid you have no other possibility then delete mentioned requests.

If you didn't clear PSA tables, then all loaded requests are still in the system. To see the other requests - goto -> menu Settings/Display selection for PSA tree - choose time interval you need.

Best regards,

Eugene

[Former Member]

Hi,

I would say that it depends on your data flow.

What do you mean by "request 40 is incorrect"? You mean it is green but it was uploaded with incorrect data, right?

If your ODS is being updated with "overwrite" update, then you only need to schedule a new full upload from your InfoSource to the ODS to correct wrong data.

If that's not your case maybe you can create an ABAP program that corrects wrong data on active table of ODS. But you have to be very careful with this method, cause no change log will be generated, so if you have data targets connected to it you'll probably need to reinitialize them.

Or even create a new csv file that corrects the wrong data on your ODS (if you update it with additions).

Hope it helps,

David.

[Former Member]

Hi David,

Thanks for your reply.

What I mean is exactly what you say. The data has got uploaded fine but the data itself is incorrect.

When I go to the PSA and right click the request and say edit data I cant edit anything. it wont let me change anything.

I uploaded a new file setting all my KF's to 0 and then uploaded the correct file but in the query display it is showing both the request which had 0 values and the correct request.

the problem is the incorrect data which had been updated is a characteristic.

any other suggestions would be much appreciated.

regards

[Former Member]

Hi Dominic,

Do you mean that you're executing a query and you get both a wrong row (with zeroes as key figures) and a correct row?

If that is your case you can solve it by:

- Compressing data on your InfoCube. That will suppress your rows with no values (now, your wrong rows have 0 as key figures). But be careful with this, cause if you compress data you won't be able to manage old requests (you won't be able to delete them individually).

- On query properties, set flag "suppress zero values". That way you won't see your wrong values on the query.

Regards,

David.