sure, let me check with the engineering team and get back to you on this

Hi @ClaudiaManea are these candidates that turned into employees or still the candidates with job application? There is this age band dimension available but that is wired to the worker age. In TA subject area, the candidate is not same as the worker. So, only a custom calculation created based on the candidate age can be…

Hi @ClaudiaManea The candidate dob is not available in HCM - Talent Acquisition subject area. Unless the dob value is available, we cannot build the report using custom age bands and the candidate counts. Raghu

Hi @pwc123 No, what i meant, you can arrive at gains and losses using the grain of the worker. i.e. a worker moves from Department A to Department B. The grain of the record here is worker You can aggregate by BU/Department/Location/Country/Manager etc using this data This is in OTBI, for your validation This aggregation…

Hi @pwc123 The short answer to your question is no. A more detailed explanation is below. “Gains” and “Losses” are not native constructs in Oracle Cloud HCM, and therefore they are not directly available in OTBI as standard metrics. Instead, these values are derived from worker HR transactions, often referred to as HR…

Hi, can you try using datasets? You can have separate datasets coming from Workforce Core and the GL subject areas. Join them based on this column, and build the workbook Thanks Raghu

Hi @pwc123 Validating it from OTBI requires logical sql queries. In the attached example I have the validation for FTE Loss for a specific Department named 'Facilities Prg UK' in the Year 2020. You need to do something similar for other workforce structures like Job, Grade, BU etc. There is a similar post in OTBI, you can…

Hi @User_AYOKV by Salary Code, you mean Salary Basis Code which is part of the HCM - Workforce Rewards - Salary Basis subject area? Import this attached dv, modify the filter on Salary basis Code and test. Thanks Raghu https://us.v-cdn.net/6037859/uploads/T6UPQB52EBGW/fte-by-salary-basis.dva

Hi @Juan This is taking longer than anticipated. This is in the roadmap but not in Apr-26. We will surely deliver this OOTB. Thanks Raghu

Hi @Stefano_Mazzocca "mean for each year, for each person number" the formula for mean is (sum of all data points)/(Count of data points) how can this change for each person? can you help us understand so that we can provide an answer Raghu

Hi @KeerthanaBaskaran These changes i.e. From and To are tracked at the Assignment grain. Please add Assignment Number to your query. It will show different values in both records. Any changes that happens on same assignment will appear in a single row. Thanks Raghu

Hi Gina, thanks for your feedback. Can you log this in the idea lab. Also anything additional you may want to see in this subject area. Raghu

Hi @KeerthanaBaskaran can you add the following attributes to your query and provide the results Time.Date HR Action.Action Type HR Action.Action Name Thanks Raghu

Hi @User_HLD1R The subject area HCM - Employment Contracts is designed to fetch history records. Can you build a report like this and test? Raghu

Hi @User_HLD1R have you enabled the Employment Contracts subject area ? Raghu

@Sam Reinhart @Krish1323 @Riti Malhotra Hi Heather, and others on this thread, Can we meet to go over this requirement in detail? As i mentioned above, this is beyond just adding the Time dimension to the subject area I would like to get your perspective clearly Thanks Raghu

Hi @Krish1323 This metric is in the daily snapshot of the requisition. You should pull up the Time. Date, Total Openings, filled and remaining openings metric to see the trend I have a sample report shared with you through the message since i could not attach it here The first viz does not honour the requisition filter on…

Hi @VkDe It does, there is a fully functional Position Hierarchy available in the subject area Raghu

Hi @Mayron Are you referring to the tables in Cloud HCM?. FDI uses different set of tables and has not changed since the first release. Yes, FDI supports only the Next Gen HR Help Desk Raghu

Hi @Gina DiVenti what i gather from the above is, Report on requisitions and their history of openings filled and remaining openings. Also display the various states that the requisition undergoes during this. These changes are all limited to requisitions in Open Phase where state <> (canceled, filled) I have a sample dv…