I have a requirement to exclude Saturday and Sunday from Bex Report created on cube. I need to know if someone has written User exit for this or there is a option to exclude it in BEx Analyser. I am working on BW 3.1 ver.
Thanks & Regards,
In the BEx Query designer, using a customer exit and checking the factory calendar, I believe you may be able to accomplish this. I am not an ABAP developer, so can give you a tip. You might want to take a look at the function module DATE_CONVERT_TO_FACTORYDATE and determine the actual working days.
Hope it helps, if so remember to award points by clicking a star next to the response.