We are extracting from a different BW system and the source is Infocube. We are loading it to a DSO. We need to reject all the records which has zero Key figure values before loading it to the DSO. We are extracting around 100 Key figures from the source.
Yes you can delete it by using abap code. it was already suggested by baskar. Just write that code into the start routine of the transforamtion and it will delete the records whose kf values are zero.
We have around 100 Key Figures. Do you mean to say I need to give the AND condition for 100 Key figures in the start routine? Is there any way to simplify the code?
As far as i know that is the best code to delete the records. In order to delete 100 key figures you have to read all the key figures and see it contains value zero or not. There might be another way of coding to delete the records but you will have to read all the KFs to delete. So somehow your code will contain 100 KFs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.