Subtract dates in QUERY excluding weekend and holidays (without using HOLIDAY CALENDAR ID)

[Loed]

Hi,

We are using BW 7.4 but not in HANA DB.

We have a HOLIDAY CALENDAR DSO where it contains the holidays every year. We are not allowed to use the FACTORY/HOLIDAY CALENDAR in BW that's why the dates are stored in a DSO.

Then we have a query where user is required to enter a range of dates.

Let's say user entered 20220101 - 20220630.

From the entered dates, we need to get the DIFFERENCE of the TO DATE of the prompt and subtract it to the APPROVAL DATE field in the report (WEEKENDS and HOLIDAYS should not be counted).

So the APPROVAL DATE AS KF was created using a formula variable via replacement path. Just wanted to confirm if there is a way to read a formula variable in CMOD? I'm not sure if this is possible in backend since user needs to enter date but will still try my luck if anyone of you knows how to handle this scenario in backend or query side?

Thanks.

Loed

[abdullahqureshi]

Hi Loed,

Use Number of workdays as per OSS Note# 1136142. I hope that will help.

Thanks & Regards,

Abdullah

[Loed]

Hi Abdullah,

But it cannot consider the holidays from the DSO tables maintained manually, right?

Thanks.

Loed