Retrieve only managers with at least one report having a specific legal entity

Oriana L.

Hello experts, we would like to create an OTBI report with a list of managers (only managers name and person number). In particular we would like to retrieve only managers having within their team at least one member/report with the Italian Legal Entity.

Do you know if this is feasible? If yes, could you please share us some details on how to achieve this purpose?

Thanks a lot

Best regards

Oriana

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/26971/retrieve-only-managers-with-at-least-one-report-having-a-specific-legal-entity

Hi Oriana,

There is no direct way of getting this information in OTBI. You can either make use of LSQL if you really want to use OTBI or write a BIP query to get this data.

Thanks.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26971/retrieve-only-managers-with-at-least-one-report-having-a-specific-legal-entity

Hi @Oriana L.

This might be possible using OTBI but needed multiple reports. Final Report will be calling another report as a filter.

Please find below high level steps which might be helpful to achieve the Report.

1. First Report which will be used as Filter: Define an OTBI Analysis which will contain following fields: Person Number, Person Name, Manager Person Number, Manager Name. Now filter this report to active employees and also legal entity = Italian LE and Manger Person Number is NOT NULL.
2. Final Report (which will give manager Name & Number): Define another report and here choose the Person Number, Person Name. Apply the filter Person Number = Manager Person Number of the Report1.

Hope this help.

Thank you.