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)

     

     

     

Cosimo's avatar
Cosimo
Contributor II
3 years ago

Hi  Omkareshwar,

In your finance calc rule, can you add an api.logmessage("curEntity=" & api.pov.entity.name) and then re-run? I would then review the error log to see these two entries and note if both were executed on the same app server. I also suspect that the data units you are referencing are cached and maybe LRU is being used regardless of left-to-right listing of entities in your DM. Another thought: are you using more than one app or cons server for running DMs? 

 

Curious to know what's happening also!

 

  • Omkareshwar's avatar
    Omkareshwar
    Contributor II
    3 years ago

     

     

     

    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: