Hiring manager issue in Talent Aquisition subject area

Ruvina Khan

Hi All,

While working on Talent Aquisition subject area, I found that hiring manager and recruiter name are missing for some requisitions. I added one fact column - "Facts - Job Requisition - Total Job Requisitions", which resolved the issue.

But then I noticed that addition of this fact column resulted in multiple rows for recruiter name with same person number, for some requisitions (may be historical data)

So, can someone suggest me any workaround or condition that can remove the unwanted row.

Attaching the Screenshot below for the columns that i am using

Thanks.

Sinduja Sekar-Oracle

Hi @Ruvina Khan ,

Please try adding a Time Dimension filter to the report and check.

Time - Year/QTR/Month/Date*

Refer Report Authoring Tips in FAW HCM Analytics:

https://docs.oracle.com/en/cloud/saas/analytics/23r3/fahia/appendix-report-authoring-tips-hcm.html#GUID-BC4E8F24-F348-4810-B164-20C044FAED96

Regards,

Sinduja