Forum Discussion

Davy's avatar
Davy
Contributor
3 years ago

how to pass multiple months to wfClusterPk = BRAPi.Workflow.General.GetWorkflowUnitClusterPk ?

Happy end of masking!! We are trying to pass multiple months to: wfClusterPkChild We tried to pass Qtr1.base but we get error message. Any suggestions on how to pass M1, M2 , M3 - which are base ...
Admin
Finance
  • Koemets's avatar
    Koemets
    3 years ago

    Frankly, I don't like manipulating wfCluster. I did have certain issues with processing order in the past when manipulating wfCluster. Can you simply execute the BR from Data Management? You can set your Time filter there and simply pull api.pov.time.name as time parameter. 

    But if you are still keen on passing the quarter The pass it without .base extension and stick it into the GetBaseMember

    Dim arrMembers = BRApi.Finance.Members.GetBaseMembers(si, dimPk, memberId_of_Q1, dimDisplayOptions)

    For each member in arrMembers...

    ....

    Next

Koemets's avatar
Koemets
Contributor

Frankly, I don't like manipulating wfCluster. I did have certain issues with processing order in the past when manipulating wfCluster. Can you simply execute the BR from Data Management? You can set your Time filter there and simply pull api.pov.time.name as time parameter. 

But if you are still keen on passing the quarter The pass it without .base extension and stick it into the GetBaseMember

Dim arrMembers = BRApi.Finance.Members.GetBaseMembers(si, dimPk, memberId_of_Q1, dimDisplayOptions)

For each member in arrMembers...

....

Next

Davy's avatar
Davy
Contributor
3 years ago

thanks. I am using a Data management to pass 1 month to this BR. I ended up hard coding - pass it M1, M2 M3 as parameters, then running the same code 3 times.
Thanks for your help. Are you a consultant?

  • Koemets's avatar
    Koemets
    Contributor
    3 years ago

    Yessir, I am. And I am planning to be at Splash too 🙂

    Any particular reason you can't pass the whole quarter as Qtr1.base in data management? Or is it Execute Business Rule Type of a step? There are multiple ways to run this functionality dynamically with easily maintainable artifacts. We should always stay away from hardcoding.