Skip to main content
M
Maja
Newcomer
March 8, 2022

Passing the row calculation entity to a data management sequence

  • March 8, 2022
  • 3 replies
  • 1 view
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

    3 replies

    C
    ckattookaran
    Member
    March 10, 2022

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

    M
    MajaAuthor
    Newcomer
    March 11, 2022

    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

    C
    ckattookaran
    Member
    March 11, 2022

    Change your DM step to have a parameter for Entity.

    ckattookaran_0-1646967756620.png

    Adjust DataQualityEventHandler NoCalculate subroutine to the following.

    ckattookaran_1-1646967850789.png

    Here is what I have in the profile

    ckattookaran_2-1646967872416.png

    And here is the task after execution.

    ckattookaran_3-1646967904934.png

     

    M
    MajaAuthor
    Newcomer
    March 11, 2022

    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

    Terms & ConditionsAccessibility statement