Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 254 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 94 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
I have an analysis created from Subject Area: Workforce Management - Worker Assignment Real Time an
I have created an Analysis from Subject Area: Workforce Management - Worker Assignment Real Time. And need the Employee's Manager / Alternate ID. Can someone help me? I have added secondary Subject Area: Workforce Management - Person Real Time with the hope that I can use the Manager / Person ID to get the Manager's Alternate ID value. I have also included Measure attributes from each subject area as required. But not able to get the needed Alternate ID field values. What am I missing?
Best Answer
-
Hi Dave,
One option is to use LSQL. Please check out the below example:
Workers and Managers Position Report — Cloud Customer Connect
Thanks.
0
Answers
-
Hi @Dave Whitson,
Please find below the xml which will give Employee & Manager and their Employee Numbers using the 'Workforce Management - Worker Assignment Real Time' SA.
Hope this help.
Thank You!
0 -
Thanks for the reply! However the XML provided is unfortunately not what I need. I'm looking for the Employees, Manager's AlternateID. If you search for AlternateID, it is not provided in the Worker > Manager folder of SA: Workforce Management - Worker Assignment Real Time. So I'm looking for a solution to look up the value on a secondary SA: Workforce Management - Person Real Time
0 -
@Dave Whitson This forum is dedicate to FDI HCM Analytics related queries. Since your query is on the Fusion OTBI side, please reach out to out Fusion Community for more accurate responses.
0 -
I am looking for a solution to combine (Join) two subject areas in FDI HCM Analytics. The solution, be it kind of clunky is LSQL. I will also need to join a third SA go get a needed field value for the request I have been working on. Hopefully this will be doable.
0 -
Please check if below helps:
How to join 2 subject areas in Oracle FDI using "Create Dataset" approach
Thanks.
0
