data load into ods

[Former Member]

A simple question. I don't have that much idea in BW that is why asking this simple question. experts please help me.

we are in BW3.5. loading data into ODS from a lagacy system. it will load around 1000 records. based on some conditions I have to delete some records when it loads. I don't want that data into the ods. How can I achive that. and were I have to do the coding part for it. also. I have to remove first character of each field. how . please advice me

[Former Member · Accepted solution]

u can do using start routine or when mapping instead of inoobject maping write a routine

[Former Member]

Hi.....

You can achieve this by Update rules......Update rule is defined between Communication structure and InfoProvider. Here you define how data coming from Communication structure should go into InfoProvider........

Check this :http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a64fae07211d2acb80000e829fbfe/frameset.htm

Hope this helps.....

Regards,

Debjani......

[Former Member]

Hi,

You can delete the records either in the Start routine or in the End routine. Assign the Source package in to an internal package by writing the select code in the start routine for the condition which you don't want to delete and assign the internal package to the source packge.

Hope this helps you.

Regards,

Venkat.S

[Former Member]

Hi Mat,

you can achive this is in what is called a start routine.

In the rules taht you define for each field, there is also an option to create a routine, whcih filters out data based on the criteria.

There u need to add your code.

see this:

http://help.sap.com/saphelp_nw04/helpdata/en/21/894eeee0b911d4b2d90050da4c74dc/content.htm