We are not using OBIEE license.. we are on Oracle Cloud 22A and created an OTBI report.

I added these 3 fields (in the code xml) so that we can see the values of these side by side the derived field(having case condition).

I have added below 3 additionally: <saw:column xsi:type="saw:regularColumn" columnID="c3dd2a9d64f333c0f"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Payables Payments - Payment History Real Time"."- Payment Information"."Check Status lookup Code"</sawx:expr></saw:columnFormula></saw:column> <saw:column…

Can you use this code and show the results you are getting: <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160"> <saw:criteria…

Maarten, please re-check your case condition based on actual values in that particular row. 

Well its working for me for 2 subject areas as well. Please see below code. <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">…

For the statement "Case when A then B else C", can you try printing all A, B, C as well so that we can see the values for each of them that you have.

We have web services available to invoke the reports. These web service outputs can then be consumed in VBCS and displayed as needed.