Forum Discussion

LeAnnTDang's avatar
LeAnnTDang
New Contributor III
5 months ago

DM job to run the one business rule for multiple sets of source and target parameter

Hello,

We have a DM that receives one set of parameter inputs and runs the business rule for a target entity. We would like to convert this DM to run on multiple sets of inputs for multiple sets of target entities. What is the best setup? 

In the example below, users usually select one set of "SourceScenario=|!dl_LAPScenarios!|, SourceEntity=|!dl_LAPEntities!|, SourceUD3=|!dl_SourceLAPParcelForFcstCopy!|, Inflation=|!dl_LAPInflation!|" and select one "E#|!ml_InactiveNoStatus_WF_Entities!|", then launch the job through the dashboard button. We have a situation where they have to run multiple sets like this several times during the month, so we would like to set up an automation so that they can select multiple source to pair with multiple targets, and launch one button to trigger the job for all pairs of source and target. 

Thank you,

LeAnn

 

Data Management
  • TheJonG's avatar
    TheJonG
    Contributor III
    5 months ago

    Does each set of selections (source and targets) have their own parameters and selections? Have you tried multiple DM Steps within one DM Sequence? 

  • LeAnnTDang's avatar
    LeAnnTDang
    New Contributor III
    5 months ago

    I have. However, the multiple sets of selections will not be used in all scenarios. If I preset 20 DM steps, and only 10 are being used, the job erred out at step 11, while subsequent steps need to be run after this step as well. Is there a way to bypass blank parameters for DM steps?

    • TheJonG's avatar
      TheJonG
      Contributor III
      5 months ago

      Yes you can bypass blank parameters. What is the error you are getting? You can use the args.CustomCalculateArgs.NameValuePairs.XFGetValue to return a default value if the parameter is blank.

      Dim myParameter As String = args.CustomCalculateArgs.NameValuePairs.XFGetValue("MyParameter","Blank")

If myParameter = "Blank"
'Dont do anything
Else
'Do something
End if

       

      • LeAnnTDang's avatar
        LeAnnTDang
        New Contributor III
        5 months ago

        The error message was "Summary: Error processing Data Management Step 'CopyDataFromLandAcqProforma'. Invalid parameter. Entity Filter, E#|!ml_InactiveNoStatus_WF_Entities!|."

        Is your recommendation for namevaluepairs still aplicable for this error message? I don't believe this entity filter is being read as a parameter in the business rule. 

  • LeAnnTDang's avatar
    LeAnnTDang
    New Contributor III
    5 months ago

    I'm not following entirely. So in this example, it's true that I didn't specify the |!ml_InactiveNoStatus_WF_Entities!|, which is the targetted entity filter. When we run it for multiple sets of source and target, we will also have sets that don't have "|!ml_InactiveNoStatus_WF_Entities!|". In the example earlier where we have preset 20 steps, the first 10 will have input for "|!ml_InactiveNoStatus_WF_Entities!| ", while the 11th will be blank. How can we bypass this error at the 11th set?