Filter in update Rules

Question: Hi gurus,

I derive company code from master data of costcenter in update rules into infocube. But now I have to filter by compcode, becouse only want data for some companys.

Haw can I implement this filter?

I know I can filter in query but I don't want this dummy data in my infocube.

thanks in advance.

Answer:
restrict the infopackage to the company codes which you require within the 'select data tab'. However i dont think standard BC has company code wihtin 0COSTCENTER

Answer:
You could also create a start routine in your update rules. Put in some ABAP code to loop at each infopackage, refer to the relevant company code in the cost centre master data, and remove the items that you do not require.

Hope you find a solution

Answer:
Hi,

My understanding is that if the result field is 0, then the record is added. Else it is abandoned. So you can always manipulate this field to decide whether to take or leave the record ..

Answer:
Hi,

Deleting from the data package using the start routine as described earlier is one option.
Alternatively you can set the return code to 4 for a characteristic or key figure routine.

Both solutions does the job. The former will in general give you better performance. The later will allow you to differentiate between different key figures.

I hope this helps.

Cheers

Jorgen Bonde Rasmussen
_________________
______________________________
Jorgen Bonde Rasmussen
jbrasmussen@mail.dk
Copyright ?2007 - 2008 www.jt77.com