Hi @Job21 fyi. I have used the 'Time.Date' column. If you are using any other subject area to create this parameter ensure you have a filter on some metric in the query to fetch default value. Raghu

Hi @User_6H96B In the link that you have shared above, there is a section related to Employee Configuration. The Job category gets that data from there. Refer the following screenshot from the cloud application Raghu

Hi @Raesah Kachwala which subject area you using? Raghu

Hi @Mykol Sutton can you please archive and share your analysis here? Raghu Note: Please post your questions on OTBI in the following forum. - https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm

Hi Richard, we do not have the benefits module as yet in FAW. It is in the roadmap of FY24. Raghu

Hi @Mykol Sutton which subject area are you using for this? You can actually use the headcount column and filter it by respective assignment status type along with the month column, it will give you end of the mpnth headcount value. for ex: Filter(Headcount USING Assignment Status Type IN (Active, LOA)) Raghu

Hi @Mykol Sutton is this in FAW or OTBI? Can you provide the name of the subject area and if possible, please archive and post the analysis here? Raghu

Hi @Raesah Kachwala These data reside in two different subject areas Create a report with person number, assignment number, assignment start date, assignment type. Have a filter criteria like below Count(Distinct Assignment Number BY person number) = 1 and Assignment Type = 'P' You can pass this person number obtained in…

Hi, you can use the below formula TIMESTAMPDIFF(SQL_TSI_DAY, <Task Assigned Date> ,CURRENT_DATE) Raghu

Hi @User_0RJUC please post this in OTBI forum https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm Raghu

Hi @LipLooi Try the following HCM - Workforce Core -> Worker -> Manager Information -> Manager Name HCM - Workforce Core -> Workforce Headcount Facts -> Facts - Workforce Person Count -> Worker Count Raghu

Hi @User_0RJUC You must post this question in the OTBI forum , link below Raghu

Arpita, you should post this ask in the OTBI forum, link below Raghu

Hi LipLooi, thank you for testing this and reaching out to me. I think you might be missing something here. I created a similar report where a specific requisition has gone through 'suspended' state twice with different intervals. Against the requisition, the cumulative suspended duration value is displayed(the viz on…

Hi @User_2XRUB Can you please illustrate your requirement with an example, screenshot or mock up? Raghu

Hi @Melody Herbert We can plan to enhance the Workforce Core subject area to include this column. Until then you can bring it into the subject area through augmentation. Raghu

Hi @Melody Herbert This requires you to create a custom column in the dv and use it for reporting. You can use the subject area HCM - Workforce Core Raghu

Hi Ruvina, can you share what attributes did you use in the query? If possible, attach the dv output here Raghu

Hi @CAMIL_Q you are right, this column is not exposed in the Workforce Performance - Performance Task Status Real Time. Can you please add this to the idea lab? I can try and add it to the OTBI roadmap Raghu

Hi, glad it's working now, you can continue with the Rank, i was trying to understand the use case Raghu