OTBI analysis - problem with left outer join

User_RD03L

Hi,

I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submitted their reported hours or not. Do you also have documentation regarding OTBI joins?

select t1.t
,ifnull(t2.c,upper('wo')) as m
from

(
select all "Time"."Calendar Date" as t
from "Workforce Management - Reported Time Cards Real Time"

)t1

left outer join

(
select all "Time"."Calendar Date" as t
,"Reported Time Cards"."Reported Hours" as n
,cast("Reported Time Cards"."Reported Hours" as character) as c

from "Workforce Management - Reported Time Cards Real Time"
)t2

on(
t1.t = t2.t
)

Thank you in advance

Nathan CCC

Hi,

On page /analytics/saw.dll?IssueRawSQL this SQL execute with success. No error message.

and if you add a sort

NOTE This will tell you in anyone entered a timecard that day but all status of timecards whether they submitted for approval or just saved some time for later without submit for approval.

Here is your user guide

Oracle® Fusion Middleware

Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition

Release 12c (12.2.1.3.0) E80604-01Au gust 2017

https://docs.oracle.com/middleware/12213/biee/BIESQ/toc.htm

JustinLitalien

@Nathan CCC , I've stumbled into this posting due to a similar problem I'm facing with BI outer joins. After struggling with finding the right code to get my two tables to connect, your example was just what I was looking for. It worked! I can't thank you enough, really appreciate this.

Take care,
Justin