Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Logical SQL is not recommended? — 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

Logical SQL is not recommended?

Accepted answer
edited May 18, 2021 6:04PM in Reporting and Analytics for HCM 12 comments


If Logical SQL isn't the answer what is the recommended approach?


Hello Everyone,

I've been told through a recent Technical SR that Logical SQL is not a recommended approach to building analyses in OTBI.

While I agree that using the subject areas as designed is best, I've found that there are cases where logical SQL seems unavoidable. The example that was being refuted through the SR was trying to connect "Human Capital Management - Transaction Administration Real Time" to "Workforce Goals - Goal Plan Assignments Real Time". I don't believe there's a way to have an analysis show information about the goal plan and derive the current task the assigned to the worker in goal setting without Logical SQL.


Howdy, Stranger!

Log In

To view full details, sign in.


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