HR Analytics: Fact Table

Question

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

Average Earnings

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

John_K · Answer

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.

Thomas Dodds · Answer

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'" ...