Aggregate actions, and make it consistent across languages

Summary

Aggregate actions, and make it consistent across languages

Content

Hi,

we need to aggregate action and make it consistent across languages in OTBI.

I modify the formula of Action field

CASE 
WHEN "HR Action"."Action Name" = 'Add Contingent Worker' THEN 'Hire' 
WHEN "HR Action"."Action Name" = 'Rehire an Employee' THEN 'Hire'
WHEN "HR Action"."Action Name" = 'Add Contingent Work Relationship' THEN 'Hire' 
WHEN "HR Action"."Action Name" = 'Add Employee Work Relationship' THEN 'Hire' 
WHEN "HR Action"."Action Name" = 'Renew Placement' THEN 'Hire' 
ELSE "HR Action"."Action Name" 
END
"Worker Assignment Details"."Action Name"

and action code:

CASE  
WHEN "HR Action"."Action Code" = 'ADD_CWK' THEN 'HIRE'