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

Hi @Laxmi Ghanta Column Properties > Additional Formatting must work. Check these screenshots below, i have leveraged the column width for absence plan name column Raghu

Hi @Max W does it leave out those records of workers that do not have a single absence transaction? This subject area renders data only when the worker has at least one absence transaction Raghu

Hi @twp07 That seems like an issue in the prompt. Can you unzip and unarchive the attached catalog to your instance in the following path and run the dashboard \\Shared\Custom\Human Capital Management Raghu

Hi @Simran Jariwala try this sample dv Raghu

Hi @CarolineAnderson @Mallikarjuna Kuppauru-Oracle I had a similar calculation built in HCM and it does work. I also validated it against the seeded headcount metric with year as filter. The formulas i had was as below Current HC - IFNULL(FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" USING "HCM -…

Hi @Edwin_Martinez The historical performance and potential rating details are currently available only in Workforce Core subject area. In Release 24R3, we are working on an enhancement to add complete history details of profiles data in the Profiles subject area. Please reach out to me(message/email me) if you need more…

Hi Gowthami, please post this on OTBI customer connect forum. I shall respond to this. https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm Raghu

Hi @Vijay Sridharan Assignment actions like cancel work relationship and reverse terminations will be evaluated for enhancements. Raghu

Hi @Valeriy Gorbunov I acknowledge your request. Will evaluate your ask.

Hi @Sohel.IN-Oracle This question must be posted in the cloud hcm forum - https://community.oracle.com/customerconnect/categories/hcm-performance-management Raghu