Hello, the OA Dimensional Schema has an attribute called 'Is Holiday' in the date dimension. This flag = 1 for any dates that have been defined as a holiday in the Admin workspace. Is this request to expand on that approach?
We are talking about using Data -> Detail (Define) to define a field to calculate the business days between two dates, we expected that the calculation can skip the holiday defined in the admin Holiday table. example as below:
1. in admin holiday table set 2024-01-01 as holiday.
2.To make the testing simple, we hardcode the from date and to date.
3. We expected the value could be 6 instead of 7.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
