Assignment Manager Hierarchy for Direct and All Workers
Summary
Building an OTBI analysis to use the Assignment manager Hierarchy for direct and all workers based on a promptContent
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.