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 https://us.v-cdn.net/6037859/uploads/0JJV6BP5AT2B/recruiting-lsql.txt

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

Hi @Ruby Hui Alternatively you can do that using case statements. i.e. you will have 3 columns with 3 different headers. for ex: Benefits Rep, HR Rep, Payroll Rep. In the column formula you will display the name only if it matches the corresponding name i.e. Case When Rep Name = 'HR Rep' THEN employee name else null end…

Hi @Ruby Hui unzip and unarchive the attached catalog. Modify the query to use your representative names. Raghu

Hi @Ruby Hui can you illustrate using a spreadsheet? refer the attached spreadsheet Raghu

Hi @Dinky Dudeja import this dv into your instance. Modify the viz filter to point to the manager for whom you need to see the directs and indirects. I have 3 flavours of the requirements that you have asked. You can choose the relevant one Raghu

Hi @Leanna Kirkland yes, this is in the roadmap and must be available in the 24R2 release Raghu