Benefits OTBI Analysis with Effective Date Parameter Not working — Cloud Customer Connect
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

Benefits OTBI Analysis with Effective Date Parameter Not working

edited Feb 19, 2021 1:46PM in Reporting and Analytics for HCM 2 comments

Summary

Benefits OTBI Analysis with Effective Date Parameter Not working

Content

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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