How to Fetch Employee level details from comp worksheet and budget details in an OTBI report

Summary:

We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manager

I saw below said subject areas but nothing helped

Compensation - Workforce Compensation Budgets Real Time

Compensation - Workforce Compensation Real Time.

Attached snippet for your reference.

How to extract details of #of Direct Reportees and his related details in the same OTBI analysis.

Any leads will be really helpful

Regards

Varsha

Content (required):

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

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