You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
37
Views
0
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!