Filtering from ODS to InfoCube

I would imagine the best place for this is the Start Routine in the update rules from the ODS to the cube.

I usually add the following ABAP:

delete from data_package where <something> = <something>

This will remove any data before the update rules are processed and is usually the most efficient way.

alan

Hi,

I can think of two ways in which you can restrict your data loads.

1. You can do that by implementing a start routine in the update rules that feed data from ODS to Infocube.

You have access to the whole data package in the start routine. There depending on some condition you can exclude certain records by writting a abap routine.

2. If your condition is simple then you can even write a simple routine in the update rule, where depending on the option make the RETURNCODE field not equal to 0. This will help you to skip the record from getting updated to the data target.

Hope this helps you. If not, then can you please explain your scenario, so that we can come up with some solutions.

Thanks

Prashant

Message was edited by: Prashant Singh

HI,

You don't need to know the infopackage name for writing the routine. Whenver you would execute any load to the data target, the start routine will execute. So just write the condition based on which you will delete the records from the datapackage.

Hope it helps. Please asign some points if our answers really helped you.

Thanks

Prashant

Hello Roberto,

this HowTo paper could give you additional help to understand how it works.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to aggregate data in the update rules for performance.pdf

Kind reg.

Michael