Oracle Communities

Oracle Analytics and AI

Child Item

New function that counts only business days in date calculations

When creating date calculations, sometimes including weekends causes the new measures to be inaccurate. For example, when counting the time in between a submission date and an approval date, it is not completely accurate to include the weekend days as no one will be working and approving on those dates.

Perhaps a function called Weekdays() or BusinessDays() could be created to more accurately measure the time it takes for approval.

Find more posts tagged with

Under Review

Function

Oracle Fusion Analytics

FDI

Status: Under Review

Comments

Gabby Rubin-Oracle

Business days is a fluid definition. It might be different from one region to the next and in most industries will require knowledge of specific holiday schedules. Here is an old but still useful forum thread on this topic: https://forums.oracle.com/ords/apexds/post/calculation-of-business-day-in-obiee-1689

Patrick Koob

I have users building custom calculations in DV Workbooks to perform this kind of analysis. It's complex enough of a calculation, that having to repeat it for every single "Weekdays_Between" calculation quickly becomes cumbersome to maintain for a report developer in OAC.

If you can't get an agreed upon definition to implement an Oracle-driven function/calculation to use in DV globally, could you enable some way for users (or even system admins) to add custom functions in their environments?

That would allow us to meet this particular need, as well as add business-specific calculation logic to our environments for whatever our unique use cases are w/out needing OAC upgrades/updates implemented by Oracle.

Patrick Koob

Noting that the separate "Idea" Enable custom calculation functions in OAC/DV — Oracle Analytics could meet the need for this, w/out having to define a global/cross-industry/cross-company definition for "Business Days", by allowing organizations to create their own custom calcs.