Oracle Communities

Oracle Analytics and AI

Child Item

What attributes are used to calculate prebuilt metrics in FDI?

I am trying to understand what fields are being utilised to calculate prebuilt metrics in Fusion Data Intelligence Platform. For example, we utilise Legal Employer Seniority Date as our Hire Date so need to understand how metrics such as “Average Tenure”, “Retention”, "Years of Service" are being calculated. I have reviewed Reference for Fusion HCM Analytics but not able to identify the specific field being used.

Subject Areas (oracle.com)

Find more posts tagged with

FDI

Fusion AI Data Platform

Accepted answers

Subha_Tripathy-Oracle

Hi @Scott_Turner_

Please check Data lineage page as well:

https://docs.oracle.com/en/cloud/saas/analytics/23r4/fahia/chapter-data-lineage.html#GUID-69B6BE1A-183B-4F76-B211-7A9295AA1D02

Metric Calculation Spreadsheet contains Fusion Human Capital Management metric calculation details.

Thanks

Subha

All comments

Subha_Tripathy-Oracle

Hi @Scott_Turner_

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Download this ZIP file that contains available subject areas that apply to the current version of Oracle Fusion HCM Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 23R4_Fusion_HCM_Analytics_SubjectAreas.html.

https://docs.oracle.com/en/cloud/saas/analytics/23r4/fahia/chapter-subject-areas.html#GUID-ED66CD8A-2972-4B15-837B-04476355E9B7

Thanks

Subha

Scott_Turner_

Hi @Subha_Tripathy-Oracle

Thank you for your response. Whilst this information is very helpful it does not actually supply which attribute/field is being used to calculate a specific metric.

One of the key problems I have is that I want to know how Tenure is being calculated as a prebuilt metric, specifically which start date is being used. Our company uses Legal Employer Seniority Date for a Team Members start date, but is Tenure calculated from this field or one of the other start dates in Oracle?

Thanks

Scott

Subha_Tripathy-Oracle

Hi @Scott_Turner_

Please check Data lineage page as well:

https://docs.oracle.com/en/cloud/saas/analytics/23r4/fahia/chapter-data-lineage.html#GUID-69B6BE1A-183B-4F76-B211-7A9295AA1D02

Metric Calculation Spreadsheet contains Fusion Human Capital Management metric calculation details.

Thanks

Subha

docmeliss

Hi - was Scott's question ever answered? I'm also looking for same type of detail - not just for tenure but for calculations of time to fill. There are so many date fields, it would be helpful to know which ones are being applied for which of the standard oracle delivered key metrics.

GPOtimization

Right, detailed documentation on attributes/field names/logic/filters highly appreciated. Reverse engineering or data archelogy is not fun…

Gina DiVenti

Specific to the tenure/years of service question, this discussion below might be helpful. Organizations will soon be able to pick which date they want used for the years of service calculation.

Work Relationship Start Date
LE Seniority Date
Enterprise Hire Date
Enterprise Seniority Date

https://community.oracle.com/products/oracleanalytics/discussion/22011/ability-to-change-the-date-the-length-of-service-band-calculation-uses-e-g-seniority-date/p3