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 level children of Qtr1 ?
Here's our code:
wfClusterPk = BRAPi.Workflow.General.GetWorkflowUnitClusterPk(si, profileName, scenarioName, timeName) where timename is 2022M1
Dim wfClusterPkChild As New WorkflowUnitClusterPk(profileInfo.ProfileKey, wfClusterPk.ScenarioKey, wfClusterPk.TimeKey)
---
where timename is 2022M1 - it works great.
However, when we tried to make timename = Qtr1.base, we get error message.
When we try to display using wfClusterPkChild.ToString, we see this "ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000"
wfClusterPkChild= ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000),
wfClusterPk.TimeKey = 2022003000
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
