IBM Business Analytics

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


We have this custom table to determine the working days. Simplest assumption is the working days will exclude weekends and public holidays.
Inside the table we only have 2 columns, date and business_day_flag (Y as business days, N as non business days).



From the same data module I have created a report with static date prompt. Please refer to snapshot below for reference. 




I have unlocked the page to create a custom header. Can refer snapshot below as reference.



Is there a way to mapped the date (first of month of date selected until the date selected) to get only the working days? 


Note: the fact table and date table is two separate tables.


Any help is deeply appreciated. 



Thanks and regards,
Aiman