Need a Fast Formula - compensation default and override to populate manager hierarchy
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?
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
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