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
Getting the Workflow Profile Text1 attribute value using BRApi
I am trying to get the Text1 field value using a Business Rule and put this value in a cube view that is being used as Form.
Does anyone have done this before? Is it possible to get the Text1 value...
Yes it is ugly. I could not get this piece working properly:
GetAttributeValue(BRApi.Finance.Scenario.GetScenarioType(si, args.SubstVarSourceInfo.WFScenario.DimId).Id
I replaced with:
Dim wfClusterPK As WorkflowUnitClusterPk = si.WorkflowClusterPk
Dim wfScenarioTypeID As Integer = BRApi.Workflow.General.GetScenarioTypeId(si, wfClusterPK)
Dim sVarStep2 As String = BRApi.Workflow.Metadata.GetParent(si, args.SubstVarSourceInfo.WorkflowUnitInfo.ProfileName).GetAttributeValue(wfScenarioTypeID, 18000)
It brought the correctly value.
JackLacava
OneStream Employee
OneStream EmployeeIf you're in a XFBR, you should be able to use args.SubstVarSourceInfo.WFText1 .
Unfortunately the Text1 field I need to get the information from is not at the ".Forms" level.
Thank you for the help.
Hi,
A few months ago I used the recommended solution of
Dim wfClusterPK As WorkflowUnitClusterPk = si.WorkflowClusterPk
Dim wfScenarioTypeID As Integer = BRApi.Workflow.General.GetScenarioTypeId(si, wfClusterPK)
Dim sVarStep2 As String =BRApi.Workflow.Metadata.GetParent(si,args.SubstVarSourceInfo.WorkflowUnitInfo.ProfileName).GetAttributeValue(wfScenarioTypeID, 18000)
And it gave me the correct value I was expecting, however, since moving to 7.3.1.14520 my cubeview BR will not retrieve the Text1 value from the WF.profile. Has the "18000" id value changed in this version ?
If I hard code my WF.Text1 value into my BR I can still pull my UD4.Textx value which alters by time and scenario, so unusual that the WF profile Text1 is not pulling through. I have tried recompiling as well as amending the variable names to see if that will kick it back to life.
Any thoughts as to why it will not work ?
Regards
Mark
- JackLacava
Have a look in the backend database tables, they should tell you if that ID has changed.
Hi,
I tried searching through the database tables, but could not find anything relevant. I don't understand why the code worked to retrieve the Text1 field value a few months ago but does not work now. Nothing has changed in the Business Rule.
Finally got this to work when I realised that it will not drive from "CubeViews" unless the particular sub profile of the entity profile has been activated in the workflow. I was "trying" to test it by running it from the cubeview menu and couldn't understand why sometimes it displayed my results when i changed entity and sometimes did not. Eventually I realised that it needed in this case to have the BS Analysis profile activated otherwise it would not retrieve the value in the Text1 field.
