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

Sub query in Case Statement in OTBI

Received Response


Hello ,

I would like to know if we can use subquery in case statement using OTBI Reporting subject areas .

For Input Value , 'Payout Date 3' , I need to get the Input Value 'Payout Amount 3' . Both Payout Date 3 and Payout Amount 3 are in the same "Input Value"."Input Value Name" sub folder.

Hence , would like to know , how to map it .

Content (required):

CASE "Payroll - Element Entries History Real Time"."Input Value"."Input Value Name"

 WHEN 'Payout Date 3'

 THEN ( select "Element Entry Value"."Displayed Input Value"  

 where "Input Value"."Input Value Name" 

 IN ( 'Payout Amount 3' )

 ELSE null END

Howdy, Stranger!

Log In

To view full details, sign in.


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