Forum Discussion

Omkareshwar's avatar
Omkareshwar
Contributor II
3 years ago

Destination Data Units

I am passing 2 Entities in the Data unit for Calculation as Entity is different in both the destinations  So what i was expecting is that it will run as a for each loop with both the entitie...
Admin
  • ChristianW's avatar
    ChristianW
    3 years ago

    Now I did test it and DM jobs are running the filtered entities in parallel and therefore no order is possible:

     

  • ChristianW's avatar
    ChristianW
    3 years ago

    You can call the custom finance business rule for each entity (in the right order) from an extensibility rule:

     

     

    BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule(si, brName, functionName, nameValuePairs, timeType)

     

     

    With nameValuePairs you can pass the pov members.

     

     

    Dim povInfo As New Dictionary(Of String, String)

povinfo.Add("Cube", cubeName)
povinfo.Add("Scenario", scenarioMemberName)
povinfo.Add("Entity", entityMemberName)
povinfo.Add("Consolidation", consolidationMemberName)
povinfo.Add("Time", timeMemberName)

brapi.Finance.Calculate.ExecuteCustomCalculateBusinessRule(si, "Your_BusinessRules", "Your_Function", povinfo, CustomCalculateTimeType.MemberFilter)

     

     

     

Omkareshwar's avatar
Omkareshwar
Contributor II

 

 

 

I ran it again and saw the same behavior but after a while it was working fine 

I think it is a bug in the application

ChristianW's avatar
ChristianW
Valued Contributor
3 years ago

I don't think the entity member filter is supposed to honor the order of the entities. I didn't test it, but it might even be, that the data management job is running the calcs in parallel using different processors.

  • ChristianW's avatar
    ChristianW
    Valued Contributor
    3 years ago

    Now I did test it and DM jobs are running the filtered entities in parallel and therefore no order is possible:

     

    • Omkareshwar's avatar
      Omkareshwar
      Contributor II
      3 years ago

      Thanks Christian for the clarification 

      So that means to run it in order i have to create different DM steps and run it in a sequence ?

      • ChristianW's avatar
        ChristianW
        Valued Contributor
        3 years ago

        Yes, I think, that is the easiest set up.