Passing the row calculation entity to a data management sequence

Maja
New Contributor II
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
1 ACCEPTED SOLUTION

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

View solution in original post

4 REPLIES 4

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

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.

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

 

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