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

Hi @Vibha Pandey There might not be the common worker dimension between these two subject areas. You can build the report using logical sql query. You can join the two SA's based on Person Number, Assignment Number etc Raghu

Hi @rrr fyi Raghu

Hi @rrr unzip and unarchive the attached analysis to your instance. Run it and check. I have the logic modified in the Email column. Raghu

Hi @rrr You need to use a pivot view. Person Number will be in rows. Email Type will be in column. Email must be in Value column, On the Email, apply aggregation rule as Min or Max. You will get all Emails of a worker in a single row Raghu

Hi @Victor H happy to announce that HR Help Desk subject area is available in Release 24R2 of HCM FDI. I hereby share a sample dv output for reference. It is in Self-Enablement Preview currently. Raghu

Hi @Martin Lowe i dont see an issue in the formula, here is my version of it , using the HCM - Workforce Core Subject Area Now - FILTER("HCM - Workforce Core"."Facts - Compensation"."Salary" USING "HCM - Workforce Core"."Time"."Date"= @parameter("var_EffDate")(date '2024-03-31')) Then - FILTER("HCM - Workforce Core"."Facts…

Hi @Robinson Ng can you try this attached logical sql query. If this works, you can append the other columns to the respective queries Raghu

Hi @Robinson Ng The common dimension in the recruiting subject area corresponds to the hiring manager and not the candidate. Let me know your reporting requirement, i can suggest a solution/workaround using logical sql Raghu

Hi @SUNIL KOTHWAL-Oracle Please remove the flex fields from your query and post it here . Not every instance can have the flexfields that you have enabled hence will not work for others. Raghu

Hi @Sourav Bose Is it the Investigation Stakeholder that you want to email to? In that case, use the following column in your analysis - "Incident Investigation Stakeholder"."Email" Raghu