How to display Name given Person Number.

Summary:

We have a DFF tied to Department that has the Person Number of the Executive overseeing the department. The name of the executive (not just Person Number) is often requested on OTBI reports. 'Case When' works but has to be updated on every report that has this field each time there is a change on the Executive team. Is there an alternative to using Case When for this?

Content (please ensure you mask any confidential information):

This is a sample, with info masked.

Case When "Department_XYZ Department Information"."Department_ORG_INFORMATION_EFF_XYZ_DEPARTMENT_INFORMATION_ecMember_v" = '1234567' THEN 'John Smith' When "Department_XYZ Department Information"."Department_ORG_INFORMATION_EFF_XYZ_DEPARTMENT_INFORMATION_ecMember_v" = '7654321' THEN 'Jane Doe END