Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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