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

Nesting Case statements?

edited Jul 10, 2019 3:25PM in Reporting and Analytics for HCM 3 comments

Summary

Is it possible to nest Case statements in otbi?

Content

I am working on a recurring report that requires me to classify people based on certain characteristics.  I am wondering if it is possible to nest case statements.  I'm trying to do something along these lines -- for specific individuals, they should be flagged as senior management, otherwise categorize them into different buckets using Business units.  This is the syntax I'm using:

CASE "Worker"."Person Number"

WHEN '111111' THEN 'Sr Mgmt'

WHEN '222222' THEN 'Sr Mgmt'

WHEN '333333' THEN 'Sr Mgmt'

WHEN '444444' THEN 'Sr Mgmt'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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