Skip to main content

Hi ,

We crated Data load run definition for IFS_EMPLOYEE_ANALYSIS Tabular model and getting below error.

SSIS LOG

We noticed that the ID defined in the DIM is created with Company^Structure ID^Code^Valid To.But IFS oracle database can have multiple records  for above combination and this caused the error in Data load run.

Can we add parent_org_code into the below ID to make this a unique record?

Tried to add Parent_ORG_CODE using below window and it is not available to add  as the 5th Dimension ID

 

Many thanks for your inputs on this issue.

Best regards,

Uvini

Hi ​@EntUviniG,

This should be something investigated from the relevant RnD Product team (HCM) as this is on the dimension model level. Please create a support ticket.

Could be a data setup issue or a bug with the ID definition.

The ID can’t be modified from the application as a configuration. It has to be a model level change.

Best regards,

Subash 


@subashfestus  Thank you for the response .


Reply