Showing results for 
Search instead for 
Did you mean: 

How to exclude Saturday and Sunday in Bex Reports for a date char

Former Member
0 Kudos

Hi All,

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,


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ajay,

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.