Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
HR Analytics: Fact Table
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.
Answers
-
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'" ...
0 -
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.
0