I try to find in Dundas how I could manage the following scenario:
- a Table A of holidays with start/end
- a Table B of staff with their holidays
- I would like to generate a Table C, which tells for each staff in which ‘holidays period’ their holidays are. For that, the ‘staff holidays’ should be included within the ‘holidays period’.
staff_holiday_start_date >= holiday_period_start_date AND staff_holiday_end_date <= holiday_period_end_date
Table A: Holidays
Table B: Staff holidays
Table C: Resultant table
Bob doesn’t show, because his holidays are not included fully in one of the
holidays of the Table A.
I haven’t found what is the way to achieve that in Dundas datacubes.