Benefits OTBI Analysis with Effective Date Parameter Not working
Summary
Benefits OTBI Analysis with Effective Date Parameter Not workingContent
Team,
I have a Benefits enrollment details OTBI analysis which is working fine without prompt.
I am trying to add an Effective Date Prompt to check between the Enrollment period start and end date. It is erroring out.
Could you check and help me to fix this report.
Some key points highlighted below:
Filters added:
and CAST (Enrollment Period Start Date AS DATE ) is less than or equal to 01/01/2021
and CAST (Enrollment Period End Date AS DATE ) is greater than or equal to 01/01/2021
Prompt used:
cast("Time"."Date" as date)