You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Add 45 day to Benefit Program Date in OTBI Analysis

Received Response
edited Aug 25, 2021 9:30PM in Reporting and Analytics for HCM 6 comments


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



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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!