Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Selective deletes from ODS and Cube

Hello,

I have an ODS, which has 4 key fields - Material, Plant, Date, Type.

During a delta update, I want to be able to go up to the ODS and Cube and delete all of the records for all Material/Plant combination that are found in the Delta load.

However the incoming delta does not have the full key combination of the records that need to be deleted. Another words it is not a one to one key match. As a result I can not simply move "D" to 0recordmode indicator!

I also want all the records for a the Material/Plant combination in the ODS and Cube to be deleted, before the received delta data is posted.

Is there a way to do it? Please let me know.

Thanks

Cerish Chemparathy

Former Member
Former Member replied

Cerish,

You are loading data into a standard ODS object. Correct.

When you load data, it goes into New table or activation queue. When you activate the data, it moves into active data and changes are then logged into Change Log table.

check this link for more on this

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

If your ODS is enabled for "Automatic actiation" disable it by right click-> change-> Settings-> remove the check mark for automatic activation.

Gova

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question