Add 45 day to Benefit Program Date in OTBI Analysis

Summary

Add 45 days to Benefit Program Date in in OTBI Analysis filter

Content

Hello,

I need to add a filter to the OTBI analysis. The filter should add 45 days to the Benefit Program date. The analysis will only show employees whose Benefit Program Date was updated 45 days in the past (e.g. Benefit Program Date + 45 days). For example, if the Benefit program date is 7/1/2021 then the person should not show up on the report until or later 08/15/2021.

This is the Date datatype field on which filter needs to be added "Person"."PER_PERSONS_DFF_BNFT_PRGRN_T_".

When I am running a simple SQL query in BI publisher data model: SELECT TO_DATE(sysdate,'YYYY-MM-DD') + INTERVAL '10' DAY from dual   I am getting correct value.