The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Keyser_Soze's avatar
Keyser_Soze
Contributor
2 years ago

Transformation Rules Order

Hello there, I made an Event Handler capable of retrieving all 'Transformation' & 'Validation' rejects in order to treat these irregularities automatically. The script creates a 'List' type of trans...
Import
Transformation
Workflow
AndreaF's avatar
AndreaF
Contributor III
2 years ago

Hi, why are values from the One-to-one mappings been added to the list of rejected elements in the first place? If a one-to-one mapping exist, they should not cause a validation issue, therefore they should not then be added to the List transformation rule. Why do you have overlaps?

Keyser_Soze's avatar
Keyser_Soze
Contributor
2 years ago

Thanks for your response,
Well in case you have a validation error saying that the member 'X' is invalid for input, when I add a new transfo list containing the member it would be ignored & I would still get the validation error ... The purpose of the script is to complete the import/validate process no matter what, and then a mail is sent containing all the audit details and modifications applied 
Same goes for error type: 'Member is not within constraints for ...' 

  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    Ok, I see, you would like to essentially ignore all errors and load anyway. Maybe you can use a derivative rule to map all members giving error to a working member (eg. Member_To_Be_Ignored), and then add the "Member_To_Be_Ignored" in the one-to-one mappings, set it to Bypass, making sure it comes before all other one-to-one mappings by using a lower order number. You would then need to edit the script to populate the derivative rule instead of the transformation List rule.