Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 272 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI 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
