We have two DataSource: 1. SQL 2. Universe
From SQL we fetch data containing Columns Start Date and End Date. We want to find Number of Holidays between Start Date and End Date for all the rows.
To Know the list of Holidays we have universe which has a Date Column and a Column to Mark "Y" for Holiday and "N" for not a holiday.
Note: We want to do the calculation in Webi only and Not at the universe level.