Forum Discussion

usmali's avatar
usmali
New Contributor II
18 days ago

Transformation Event Handler Sample code

Hello there, 

can someone please share a sample transformation event handler code to map an unknown dimension member to a "placeholder" in the same dimension when validation step fails?

Appreciate it!

 

  • usmali's avatar
    usmali
    New Contributor II

    Unfortunately we don't' have the gulfstream application available in our environment. I am trying to understand the methods and objects that exist in the TransformationEventHandler so any guidance/documentation would be a helpful. 

    Also the alternate method without the scripting approach is not going to work for us due to the size of UD1/2 dimensions

    • SimonHesford's avatar
      SimonHesford
      Contributor II

      There are a few  articles on Event Handlers that can be found via an internet search e.g. 

      https://archetypeconsulting.com/blog/unleashing-the-power-of-onestream-event-handlers-enhancing-user-experience-and-efficiency

      Also search in Navigator for courses on Event Handlers; there is some starter material (reserved to Passport subscribers) as well as an episode of "Conversations with IT" ("Data Sequence Management and Use of Event Handlers") showing how to use handlers.

  • Hi, my advice would be to give it a go yourself and then if you have any specific issues with the code you create then ask for help with that rather than just asking somebody else to produce the code for you. This is the best way you will learn some more advanced techniques on the OneStream platform.

    Also the responses to your original question

    https://community.onestreamsoftware.com/discussions/WorkflowDI/re-validation-errors-mapping-to-placeholder/42843/replies/42863

    provided an alternative solution for doing this purely with transformation rules and no scripting. Therefore if you are not up for the scripting challenge you can follow that approach. Yes, it will probably require more initial setup and ongoing maintenance but it also more accessible to your general end user.