Need a Fast Formula - compensation default and override to populate manager hierarchy

Summary:

We have an OBIEE report that has 5 levels of manager hierarchy. We would like to have similar columns in our workforce compensation bonus plan. Assuming we can create a FF to gather. Does anyone have an example of the below results from OBI in a workforce comp sheet?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

OBI SQL / DM Snippet

      select ppnf1.display_name

            from per_manager_hrchy_dn PMHD ,per_person_names_f ppnf1

            where PMHD.ASSIGNMENT_ID = paaf.ASSIGNMENT_ID

            and ppnf1.person_id = pmHD.manager_id