Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to get data for Manager's indirect reports.
Answers
-
@Gianni Ceresa Thank you very much. Appreciated your help.
Please can you provide some guidance on how to it in Dataflow?
0 -
If you know the maximum level of your hierarchy, in the dataflow you will need to build a "bad looking", but technically valid, dataflow starting with "manager", "employee" from the dataset itself. Then union all to the same dataset joined to itself with a condition d1.employee = d2.manager and retrieving d1.manager and d2.employee.
And so on for as many times as you need.
You are practically resolving the hierarchy by linking each employee to all its managers, doesn't matter how high up in the hierarchy they are.
0 -
@Lalitha Venkataraman-Oracle Thanks for providing info.
- Downloaded plugin. It is working fine. Issue is with download file Button. Since number of rows are more, I can't navigate to down to end to click on "Download File". If the button is on top, it will be good.Still I am finding ways to download file. Export is not working correctly.
- I am unable to download the OA Desktop. I am getting error below.
0 -
@Gianni Ceresa We are handled in database using SQL with recursive.
Thanks for sharing info.
0 -
I am unable to download the OA Desktop. I am getting error below.
Best to open a new thread for separate issues.
In this case, you can try without the Oracle Download Manager.
To download directly, just click on the vXXXXX.zip link instead of download button0
