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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Adding Case Statement to Existing Data Model

edited May 28, 2020 12:22PM in Reporting and Analytics for HCM 9 comments

Summary

Need assistance with case statement

Content

I am in need of assistance with the following: (1) case statement syntax and (2) adding a case statement to an existing data model

My goal is to create a new field in an existing data model named ‘Score’. The values in this field (Green, Yellow and Red) depends on the total score (see case statement below).  The Total Score field is already in the existing data model. I then want to use this new field ‘Score’ as a parameter.

Here is the case statement - there is something wrong with the syntax:

SELECT TOTAL_SCORE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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