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.

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…

From (Doc ID 2372726.1) SOLUTION /My Folder/Temp or /My Folder/Drafts are used internally by BI and are volatile, these folders should not be used to save reports. All contents in these folders get purged after 25 hours. A new folder could be created under 'My folders' directly to save the content to it. Once the task(s)…

Nice to learn after losing hours of work to be redone. I have work stored in 'My Folder/Drafts from Feb 2024 - Jun 2024. And I'm just now experiencing my more recent work getting 'purged'. Not good.

Hi Arjun, From FAW reporting side. @Sumanth V provided the direction needed. Thank you both!

Thank You Nathan CCC! Was able to download Rel13_24A_HCM_OTBI_Database_Mapping_with_ViewObjects.xlsx From this I filtered on column "SUBJECT AREA" and located "Workforce Profiles - Person Profile Real Time". Then Filtered column "PRESENTATION_TABLE" for value "-Licenses and Certifications". This Subject Area appears to be…

I believe Andrew is looking for employee License detail for an OTBI report. I am looking for the same. Any help pointing us to the subject area that contains this data would be appreciated.