FAW Extensibility Use Case - Add New Custom Calculated Measures to Existing Fact Folders in HCM Work
This post covers following high level steps for adding new custom measures/metrics to out of the box (seeded) HCM subject areas.
A. Identify custom measures
B. Construct the formula
C. Extend Semantic Model
D. Publish, test and merge Semantic Model
E. Version and Promote to production
1. Identify custom measures that are frequently used by your business users. Let’s consider an example, “APAC Headcount”.
2. Construct, validate and test your custom formulae in OAC projects:
FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" USING "HCM - Workforce Core"."Location"."Country" IN ('India', 'Philippines', 'China', 'Singapore'))
Few more examples: