OTBI get name from Person Number in an analysis
Summary:
Hello, is there a way to get an employee's name from a field that stores their person number? For instance, "Feedback Response"."Created By" in the Workforce Performance - Requested Feedback Real Time subject area is a field that lists who created the feedback but it lists their person number, is there any way to make the field say their name as the "Created By" name isn't in the subject area?
Without using logical sql. I mean a Case When statement or something to that affect that leaves the subject area usable for the next developer.
Thanks