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

OTBI analysis with date prompt pulling duplicate records

edited Aug 26, 2019 7:42PM in Reporting and Analytics for HCM 7 comments

Summary

OTBI analysis with date prompt pulling duplicate records

Content

Hello,

I was hoping to get some help with fixing my OTBI Analysis report that is pulling duplicate records.

I have created a SCHEDULED report to pull worker data which includes workers with hire dates 2 weeks prior to SYS date and 2 weeks after SYS date. To get this, I have filtered on hire dates between TIMESTAMPADD(SQL_TSI_DAY, -14, CURRENT_DATE) and TIMESTAMPADD(SQL_TSI_DAY, 14, CURRENT_DATE). I have also used "AsOfDate" prompt with a default date way into the future like this SET VARIABLE PARAM_EFFECTIVE_DATE='2030-12-31'; so that it pulls future hires. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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