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

Look Back
How to do MAX Date Logic less than Prompted AsOfDate in Analysis — 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

How to do MAX Date Logic less than Prompted AsOfDate in Analysis

79
Views
1
Comments
edited Jun 14, 2017 6:25PM in General Transactional Reporting (OTBI) 1 comment

Summary

Trying to get the maximum Salary Change Date in OTBI Analysis

Content

I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less than or equal to a prompted AsOfDate in an OTBI Analysis.  Here is the filter I am using:

 

"Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" =
SELECT MAX("Compensation - Salary History Details Real Time"."Salary Details"."Salary change date")
 FROM "Compensation - Salary History Details Real Time"
WHERE "Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" <= '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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