Is it possible to write Routine at DS level ?

[Former Member]

Experts !

What i understood, that we can write Start / End Routine at Transformation level. So you can filter records from PSA to Data Tarrget.

Can we do the same when data comes from DS to PSA ?

i want to delete those Data where Field ='ABC' . if its possible then i dont have to worry at Transformation level.

Thanks

[Former Member · Accepted solution]

Hi,

You can do it at the Infopackage level only if that particular field is in data selection.

If the field is a selectable field in the Datasource,then go to Infopackage >"Data Selection" tab>go to "Type" column -->F4 and choose 6 for ABAP Routine.

More Details at :

<<http://help.sap.com/saphelp_nw04/helpdata/en/a3/4f8f3b294a7f2de10000000a11402f/content.htm>>

If you dont have that particulat field in datasource selection,then you can also do it at DTP level(this is after data comes into PSA) . Go to DTP>Extraction Tab>Click on Filter and then define a routine against the field.

Thanks,

Divya.

Edited by: Divya Nambiar on Feb 23, 2011 1:36 PM

[Former Member · Accepted solution]

Divya, Honar

Pull out the DS in question:

Tab select - mark M or X

Tab u201Csel optsu201D - pick one

That field will become selectable then proceed as Divya has suggested in the first paragragh.

Jen

Edited by: Jen Yakimoto on Feb 23, 2011 7:57 PM

[Former Member · Accepted solution]

thanks a lot,

But i am not able to edit infopkage to enter "Type"

at the bottom, there is "+" sign to add rows, but its all grayed out.

can we do it on 7?

[sven_mader2]

Hi,

No - not from DS to PSA.

But, you can delete data in the customer exit of the datasource.

=> see the ABAP ZXRSAU01 in your ERP.

Sven

[Former Member]

HI.

You can include in the data flow an Infosource. The data flow is: DS --> Infosource --> DSO.

In the transformation between the DS and infosource you can create a Start Routine.

Note: Infosurce is optional en BI 7.0, but you can use for this.

Regards !!!!

[MartinMaruskin]

In old 3.x data flow style it is possible to use InfoSource and the such a coding in here (start routine).

In BW 7.x the purpose of PSA is different. According Enterprise DWH PSA serves as inflow layer of raw data e.g. for historical purposes.

[Former Member]

Martin,

I tried to get your point but Iu2019m not sure I got it. You mean the dynamic selection (abap routine, not start routine) should not be used in BI 7 to screen out unwanted records ?

Jen

[MartinMaruskin]

Jen, I meant it purely from architecture point of view. Even in BW 7.x you can still model your data flows in 3.x fashion and by that use IPackage's ABAP routine to filter out records before data gets into PSA.

It is just up to you if you building corporate memory according principles of Enterprise DW or according some other architecture style.

[Former Member]

Iu2019ve been using both static and dynamic selection to eliminate unnecessary records (BI7) whenever I could. The reason is for better load performance. Should do it at this stage rather than later at transformation level.

Frankly I didnu2019t take into account the architecture point of view. I might need time to think it over.