OTBI Agent Email Analysis Run As Of Date Derived by SQL — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

OTBI Agent Email Analysis Run As Of Date Derived by SQL

edited Nov 24, 2020 10:15PM in Reporting and Analytics for HCM 13 comments

Summary

Trying to setup existing 'Point in Time' analysis with AsOfDate Parameter as automated agent that uses SQL to derive the last day of the prior month at runtime

Content

I have a basic OTBI analysis with simple real-time assignment & salary details from the below 2 subject areas:

  • Workforce Management - Worker Assignment Real Time
  • Compensation - Salary Details Real Time

I created a version of this analysis as a 'Point in Time' report by adding a presentation variable prompt with a date selector as well as the following SQL prefix on the Advanced tab:

SET VARIABLE PARAM_EFFECTIVE_DATE='@{P_DATE}';

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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