You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FAW Extensibility Use Case - Add New Custom Calculated Measures to Existing Fact Folders in HCM Work

Received Response
edited May 2, 2021 7:16AM in Oracle Fusion Analytics 1 comment


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:

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!