CASE WHEN in BI Publisher — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

CASE WHEN in BI Publisher

edited Oct 18, 2018 11:31AM in Reporting and Analytics for HCM 10 comments

Summary

Using CASE WHEN in BI Publisher SQL and not getting results

Content

Hi all, I have been writing a BI Publisher data model with SQL to bring back employees along with their ethnicity as well as other fields, my report works and everyone comes back it is just when i go back into my SQL code and try and clean the data up that i am having problems. 

As an example we have data coming back for White-British as A1, so i am trying to write a CASE WHEN Statement to say when ethnicity = A1 then ethnicity = White-British. However the A1 is not changing.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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