OA cannot retrieve the Holiday table in order to calculate accurate business days

[peteyim]

My client (on 23.x) having the following suggestion on the OA.

It is suggest to add the function in OA so that the bank holidays defined in the Holiday table can be used:

[findern]

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? 

[MelanieZhu]

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.

[namarnani]

Is this an existing issue or newly identified one? If the issue still persists in your version then please raise a service ticket on it.

[Gigi.Ng]

This is a product idea and not an issue. The client would like to have the holiday table that is already configured in Chorus to be automatically be usable in the operation analytics.