Oracle Communities

Oracle Analytics and AI

Child Item

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?

Find more posts tagged with

OTBI

Analyses

Fusion HCM Analytics

Subject Areas

Accepted answers

MandeepGupta

Hi Dave,

One option is to use LSQL. Please check out the below example:

Workers and Managers Position Report — Cloud Customer Connect

Thanks.

All comments

Bhaskar Konar

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.

XML - EMP MGR.txt

Hope this help.

Thank You!

Dave Whitson

Hi @Bhaskar Konar

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

MandeepGupta

Hi Dave,

One option is to use LSQL. Please check out the below example:

Workers and Managers Position Report — Cloud Customer Connect

Thanks.

Ashish-Oracle

@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.

https://community.oracle.com/customerconnect/

Dave Whitson

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.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/64880#Comment_64880

Please check if below helps:

How to join 2 subject areas in Oracle FDI using "Create Dataset" approach

Thanks.