Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to Identify relative column on OTBI side for an FDI Column

Question
5
Views
0
Comments
User_MN734
User_MN734 Rank 1 - Community Starter
edited Oct 2, 2025 5:17PM in Oracle Fusion HCM Analytics

Trying to test latest release updates on Oracle HCM .

HCM - Talent Acquisition subject area has these enhancements:

  • New Metrics - New metrics related to openings filled, openings to be filled, requisitions with and without active offers on it, and days since a requisition is open is added to the Facts - Job Requisition folder.

How to determine OTBI columns that are related to these measures. Here is what the Data metric calculation shows. Does not give exact columns though? How do I verify if these new columns are giving the correct results?

Openings Filled

Count(Job Application ID) Where Phase = HR and State Not IN (Rejected, Withdrawn)