Adding HCM fields to FDI

User_FJF92

Our customer has requested us to add the following HCM fields to the FDI semantic model:

Contract Level

Contract Type

Qualification

Part Time information

Worker number

We have found a workaround by importing the fields through a combination of data augmentations / OAC data flows and linking the new information through the assignment ID by extending the Assignment Details dimension. We have created a view that contains all these fields and extended the Assignment Details dimension through a simple join.

The issue with this approach is that we have found that linking the new fields with the semantic model through a complex join generates an error. When creating a workbook on OAC that includes both the extended dimension and another dimension the query is not generated when the extension is done through a complex join.

Other than including the indicated HCM fields in the standard FDI semantic model, fixing the complex join issue is also necessary because in other use cases it might not be possible to find another workaround.

Farivar Javanbakhti-Oracle

Thanks for submitting this idea. Would you please share the error message you mentioned?

User_FJF92

The error message we get when creating the workbook is the following:

nQSError: 14025 - No fact table exists at the requested level