Categories
A column with a moving number of working days OBIEE 12c
Hello,
I would like to create a column with a moving number of working days. The working days will be calculated based on the selected period time from the Dashboard Prompt. For example from 2025week03 to 2025week40 or from 2025/01/01 to 2025/03/14. It is possible?
Number of working days will be part of the formula.
Best regards
Answers
-
Hi,
Do you have a fully defined business meaning of "working day"? Because out of the box, in the product, there isn't something for that because a working day is different in each region, country or even just from a company to another. Because the "business day" is a business definition, you need to have a definition of it first. Then you can look at the best way to implement it.
Usually for this kind of requirements, a time dimension is what you use to solve it: you can add an attribute to each date to say if it's a working day or not, and then you can simply count the rows having that attribute in the period you are interested in.
0
