HR Analytics: Fact Table

User_ZZQJ0

We are conducting a fit gap analysis for HR Analytics and we would like to add the following metrics:

HR to Staff Ratio

Human Capital Cost

Total Earnings

Total Earnings

Average Earnings

Average Earnings

What fact table can we to add these metrics to if they dont exist.

Thomas Dodds

What fact table depends on a good deal of analysis on what is there OOTB and how you intend to use the metrics:

Do all the components/measures/columns for your metrics exist in the physical tables - at grains that can be combined?

Are you looking to add these to the physical tables or in the logical models?

Do you need the metrics at a different grain than base fact tables in the OOTB model?

Do you need these metrics at a different 'velocity' than the base fact tables in the model?

Knowing the OOTB model really well and making decisions to extend an OOTB  fact versus building new comes with a great deal of experience.  Also - ALL customizations need to follow Oracle's prescribed method or you will be in trouble come upgrade/patch time.

If you've never done a customization/extension of OBIA - I strongly urge you to seek the aid of an implementer who has.  This forum isn't the proper way to walk you through a complex and involved process as OBIA extension/customization ... don't trust a pat answer of "just do it in 'x_fact'" ...

John_K

HR to Staff Ratio - Probably Workforce Deployment.

Human Capital Cost - Depends on what your definition of this is.

Total Earnings - If you're using Payroll and an 11.1.1.x version of BI Apps then you'd just configure a payroll balance in EBS for this.

Total Earnings - As above.

Average Earnings - Average over what? Again, probably a logical column in Payroll with a different aggregation rule.

Average Earnings - As above.