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

You can't pass the .base there. I'd suggest you execute

BRApi.Finance.Members.GetBaseMembers(si, dimPk, memberId, dimDisplayOptions)

Where memberID is you Qtr1 member id and run the loop for each member in that array assigning it to the WfCluster.

Davy's avatar
Davy
Contributor
3 years ago

Thanks. 
Another question: 
What is WFCluster? 
Another question:

 I have been using this statement to debug and view the contents of  WFCluster.

BRAPI.ErrorLog.LogMessage(si,"line 66" & wfClusterPkChild.ToString   )       

it displays wfClusterPkChild.ToString, we see this "ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000"     

Are there  other ways to view wfCluster?

  • Koemets's avatar
    Koemets
    Contributor
    3 years ago

    Ok, let me thread carefully there, When you said you need to manipulate it, then I assumed you need it for certain purpose. Can you please specify that purpose?

    • Davy's avatar
      Davy
      Contributor
      3 years ago

      I'm sorry , I'm not manipulating. I just want to know what is WFCluster contents. ?
      Also, do you have a better way to see it's contents than using BRAPI.ErrorLog.LogMessage(si,"line 66" & wfClusterPkChild.ToString   )  ?

      • Koemets's avatar
        Koemets
        Contributor
        3 years ago

        Nah, I do the LogMessage all the time, really. That's the best way 🙂

        By manipulating I meant "passing" a certain date there, that you are trying to do. Why do you need to know the WorkflouUnitClusterPKs for those periods? What are you trying to achieve?