OTBI Analysis - Show Managers Direct and Indirect Structure

Question

Summary:

Content (required):

I am looking to show a manager's indirect structure, for example, I like to know everyone working for Manager X. Manager X has 10 Direct reports and 50 indirect. Within OTBI please recommended best was to show this

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

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

Andrew_Schmitz · Answer

I believe I found this on here before previously (I guess I cannot attach a catalog file) XML: "Assignment Manager List Unsecured"."Manager Name" "Assignment Manager List Unsecured"."Person Name" CASE WHEN "Assignment Manager List Unsecured"."Person Level" = 1 THEN 'Direct' ELSE 'Indirect' END Assignment Manager List Unsecured Direct/Indirect Report? "Assignment Manager List Unsecured"."Person Level" COUNT(DISTINCT "Assignment Manager List Unsecured"."Person Name") Assignment Manager List Unsecured Count "Assignment Manager List Unsecured"."Manager Name" DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Assignment Manager List Unsecured"."Manager Name")

Gaurav Bharadwaj-Oracle · Answer

Try this : Difference Between Secured and Unsecured Assignment Manager Folders in Workforce Management - Worker Assignment Real Time (Doc ID 2240566.1)

Use the unsecured assignment manager folder to pull the columns.