Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Prefix - set effective date using SQL Expresssion — 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

Prefix - set effective date using SQL Expresssion

edited May 4, 2018 10:53AM in General Transactional Reporting (OTBI) 2 comments


Hello - I'm hoping someone can help me with this please.

I have an OTBI analysis that I want to schedule on the first of each month that will show changes in the previous month. One of the 'changes' could be that the record has been ended but because the because the subject area is a Real Time one (Payroll - Element Entries Real Time) the record is no longer current when the report is being run so it will not report the change. 

Therefore, I am wondering if I could include the SQL expression below (to get to the 1st of the previous month) in the prefix to set the effective date to be the 'first of the previous month'. 

Howdy, Stranger!

Log In

To view full details, sign in.


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