Hi @User_LW96B Please use an expression filter criteria like below "HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" = (MAX("HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" by "HCM - Workforce Rewards - Salary Basis"."Basic…

Hi @Lauriane Massin Whitaker did you try adding both the New Hire Headcount and Assignment Count to the report along with the worker category and duration? Did that work? Raghu

Hi @Ruvina Khan As you know, there can be many custom sections that you can create using the seeded content types. We cannot seed all of them, obviously. Hence, we added the 'All Profile Content' folder which can be used to report on all sections across skills & qualifications, and Talent Ratings including custom defined…

Hi @Ruvina Khan This is available for reporting in a new subject area named HCM - Talent Profile Trends. This is part of 24R3 . Should be available end of this month. You can use the All Profile Content folder in this subject area to report on custom sections. Raghu

Hi @Ruvina Khan Is 'Organization Review Data' a section in Cloud HCM Talent Profile? just like other sections, for example: degrees, license and certifications etc? Raghu

thanks, Manju @Manjunath Subramanian-Oracle @Lauriane Massin Whitaker ,fyi use this attached dv, you can modify the year, LE in the report Raghu

Hi @Mike Tytler @Gina DiVenti currently what we have in OTBI is a balance metric. i.e. for a requisition, it provides what is the hired count and openings to be filled. You cannot get a trend of hired count and openings to be filled by various time periods, like quarter/month/year etc. refer the attached screenshot.…

Hi @Mike Tytler please re-check the formula that I have for the column 'Left to Fill' I have tried to mimic the same logic as in OTBI Going by your formula above, is it ok to consider the Job applications in HR phase which are in withdrawn or rejected states also? In my formula, i have excluded them on your comment - FDI…

Dear @Gina DiVenti , @Mike Tytler , @Lea B I am in the process of seeding this openings left to fill measure at the grain of the requisition. This will be a balance metric i.e. as of current, how many openings are yet to be filled for a requisition. I was trying to mimic the same logic that we have in OTBI(in FDI) Can you…

an another version of this can be like below "HCM - Workforce Core"."Time"."Date" BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE) AND CURRENT_DATE

Hi @Vaigu_27 try if you can use this session variable as filter - for example: ("HCM - Workforce Core"."Time"."Month" = VALUEOF(NQ_SESSION.TRAILING_12_GREGORIAN_PERIODS)) Raghu

@Gina DiVenti Right now, 24R3 is going on and is locked. Best case would be 24R4. I can keep you posted.

@Mike Tytler thanks so much for the confirmation. Will get this added. Raghu

@Mike Tytler @Gina DiVenti Just to confirm, your expectation is to have this metric(highlighted in the attached screenshot below) available in OTBI - Recruiting Real Time to be added to HCM - Talent Acquisition subject area Raghu

@Lea B @Gina DiVenti @Mike Tytler @Jamie Anderson-Oracle have you tried using the existing hires column? and use that to compute the openings to be filled metric? I hereby share a sample dv, please import and check if it works for you. Raghu

Hi @Tim Janssen HR Help Desk subject area is available from Release 18.4 i.e. 24R2. It is under Preview, you just need to enable it. Please reach out to me if you need a sample dv that I had created for demo purposes. I shall share the output of that dv here Raghu

Hi @Mike Tytler yes, apologies on the confusion. Added into the documentation before seeding it in the subject area. I shall get these metrics added, also update the documentation by next release. Raghu

Hi @CarolineAnderson @Chris Allies This requirement you have mentioned above does not need the trailing period filter. Workforce Core has a daily snapshot. If you just have the 'Headcount' metric on the dv, it will always show the latest. If you want to be double sure you just need to apply a filter like below…

This feature has been delivered

Hi Vibha, yes you can pivot the data even if the report is created from the logical sql Raghu