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 - issue with LEFT OUTER JOIN

edited Feb 13, 2017 6:22PM in Reporting and Analytics for HCM 8 comments

Content

Hi,

I tried this query and seemed to be not working. It is throwing error saying ' Invalid SQL statement. ( I am using this query just to test the JOIN. ) What would be the issue with this. Do you have links to more documentation on joins in OTBI ?

 SELECT Q1.PN1, Q2.EMP2
   from  ( 
 ( SELECT
   "Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" PN1
    FROM "Workforce Management - Worker Assignment Real Time"
    ) Q1
LEFT OUTER JOIN 
(SELECT
   "Compensation - Salary History Details Real Time"."Worker"."Person Number" PN2,
   "Compensation - Salary History Details Real Time"."Worker"."Employee Name" EMP2

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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