Forum Discussion

Maja's avatar
Maja
New Contributor II
4 years ago
Solved

Passing the row calculation entity to a data management sequence

Hi OneStream Gurus, I have a workflow profile with multiple rows (assigned entities, parent node....). One calculation definition executes a data management sequence. I am using the WF text to pass the entities to the DM sequence and this works fine.. But I was wondering if there is a way to pass the entity from the calculation definition row to the DM calculate sequence or the data quality event handler business rule. As expected if I use the E#Root.WFCalculationEntities in the DM calculate it runs for all entities defined in all rows. Thanks Maja
  • Celvin, you are a legend I was missing the piece on how to create dm parameter in the BR. 

    I really appreciate your help.

    Thanks and have a nice weekend.

    Maja

  • You could change the event handler NoCalculate piece and pass the dataunitNames.EntityName as a parameter to the DM sequence.

  • Maja's avatar
    Maja
    New Contributor II

    Thanks Celvin thanks for this, I have been trying to do this, but struggling with the code. Do you have an example for me?

    thanks Maja

    • Change your DM step to have a parameter for Entity.

      Adjust DataQualityEventHandler NoCalculate subroutine to the following.

      Here is what I have in the profile

      And here is the task after execution.

       

  • Maja's avatar
    Maja
    New Contributor II

    Celvin, you are a legend I was missing the piece on how to create dm parameter in the BR. 

    I really appreciate your help.

    Thanks and have a nice weekend.

    Maja