The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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 ...
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
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?
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?
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 ) ?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?
I'm using this BR successfully to export data from staging tables to text file. I'm passing one month at a time to this business rule. I'm trying to pass 3 months instead of one month.
Thanks for your help. I'll award your answer as the solution.