Hi @User_2NDAD You can do that using max function on the hire date for the worker. Apart from detailed reporting, do you have any other requirements on this column? Raghu

Hi @User_50AGP When you say history, do you mean archived ones or all the ones that are active? it may have been created anytime in the past and you can report on trends of those if they are active. btw, please up vote above Raghu

Hi Ummesh, these are tables in SCM.

Hi @JP_UKHSA We are planning to enhance a few subject areas with an additional dimension that houses a few worker assignment attributes based on the latest assignment of the worker. The planned attributes include the following. Hope this works. Latest Assignment Number Latest Assignment Type Latest Assignment Status Latest…

Hi @Ruben97 This is being tracked as part of the below idea post Raghu

Hi Shiva, the others except Top Manager, Department and Organization hierarchies already exist in the subject area today Raghu

Hi All, based on the request, is the following solution acceptable Adding of 2 flags as below Hispanic Flag - Y if the worker has one of the ethnicities as 'Hispanic or Latino' else null Two or More Races Flag - Y if the worker has minimum 2 ethncities. A) If a worker has only hispanic then only the Hispanic Flag will be Y…

Hi @SathishKS We reviewed this request internally. What we found was, the latest reviewer ratings are stamped on the HRR_DASHBOARD table after the meeting configuration (setup) is submitted. In OTBI, it fetches the latest reviewer ratings from the Talent Profiles table in real time. Due to this, it was designed in FDI to…

Hi @mgoswami You can do this through custom calculation. We do not want to create multiple sets of bands for Age and Tenure since they are actually user configurable.

Hi @Shivaranjan - I assume you are referring to the below ones Department Hierarchy Organization Hierarchy Thanks Raghu

Hi @User_2NDAD - can you answer if option 1 or 2 is what you mean Option 1 Are you referring to any specific column in the Fusion Application? Do you find the same column in OTBI subject areas? Option 2 in FDI, you want to calculate the latest hire date of the worker if the worker has been rehired multiple times Thanks…

Hi Jared, on your ask related to lineage, i can check and get back. Raghu

Hi Avik, I acknowledge your ask regarding Worker Location Hierarchy. This will go into our FDI roadmap items. Thanks Raghu

Hi @KrishnaSanga The issue mentioned by you alludes to the compute logic behind a seeded metric. We publish documentation on the metrics and the logic used in its compute. You can always refer that. Lineage Document -…

Hi @User_BR9YB This data is leveraged from the Talent Profile data of the worker. One way of validating it is checking if the data exists using one of the OTBI subject areas named Workforce Profiles - Person Profile Real Time. This subject area has separate dimension folders related to performance and potential. You can…

Hi @User_BR9YB yes, it should

Hi @User_BR9YB This is coming from the Talent Profiles data of the worker. However, the Workforce Core functional area itself sources this data from Profiles, you do not have to refresh other functional areas. Thanks Raghu

Hi All, Does a standalone Approvals subject area help here? Please note, if the approval records are not retained after 30 days, and if you do a reset of the warehouse, you may lose out on this data in the warehouse too. Is that acceptable? Thanks Raghu

Hi All, Generally, we have seen customers using Parent Position Hierarchy, which we added in FDI. But is the request specifically for Position Tree hierarchy? Also, for Worker Location Hierarchy, do you expect a tree or a hierarchical dimension? Thanks Raghu

Hi @ClaudiaManea I checked internally, and there is no equivalent table for this in ADW