AnsweredAssumed Answered

Help With NSQL Statement

Question asked by venkat1 on Jun 22, 2013
Latest reply on Jun 24, 2013 by another_martink
Hi All,

Please help to complete the code



@SELECT:DIM:USER_DEF:IMPLIED:resource: q.res_id || q.period_id:resperiod@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:q.period_start:Periodstart@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:NVL(q.ts_id,0):tsid@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:(CASE q.ts_status WHEN 0 THEN 'Unsubmitted' WHEN 1 THEN 'Submitted' WHEN 2 THEN 'Returned' WHEN 3 THEN 'Approved' WHEN 4 THEN 'Posted' WHEN 5 THEN 'Adjusted' ELSE 'Not Created' END):timesheet_status@
,@SELECT:DIM_PROP:USER_DEF:stoplight:resource:CASE
WHEN q.period_start > sysdate and timesheet_status = 'Submitted'


THEN HERE I WANT TO OVER WRITE THE VALUE OF q.ts_status WITH 2 (FROM 1)

THEN NVL(q.ts_status,2)
ELSE NVL(q.ts_status,9) END:stoplight@
,@SELECT:DIM_PROP:USER_DEF:IMPLIED:resource:CASE WHEN q.ts_status IN (0, 1, 2, 3, 4, 5) THEN 1 ELSE 0 END:allow_link@

Thanks

Outcomes