Nesting Case statements?
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'