Categories
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.
Comments
-
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
1 -
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.
0 -
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.
0
