Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Retrieve only managers with at least one report having a specific legal entity
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
Answers
-
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.
0 -
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.
- 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.
- 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.
0
