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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Assignment Manager Hierarchy for Direct and All Workers

edited Jan 8, 2019 2:33PM in Reporting and Analytics for HCM 1 comment

Summary

Building an OTBI analysis to use the Assignment manager Hierarchy for direct and all workers based on a prompt

Content

Hello,

I need to be able to prompt on Direct or All workers associated to a manager (who could also be prompted) and include a pivot table using the assignment manager hierarchy. I struggled a bit to get the results but I believe that the attached analysis (xml attached) should get the job done.

I'm prompting for the Performance Document.Name, Assignment Manager List (Unsecured) Manager Name, Legislation and Assignment Status Type. If the manager Name hasn't been provided, or the Type of Report (Direct or All workers) is Direct then I filter on the 1st level of person level otherwise I include all Person Levels from the Assignment manager List Unsecured.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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