Sub query in Case Statement in OTBI

Summary:

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