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

YanSavinsky's avatar
YanSavinsky
New Contributor III
2 years ago
Solved

Running DM package from the BR and completing the workflow step

I would like to give my users the ability to launch the DM sequence from the workflow step. I have the dashboard with the button that passes the parameters to the DM package and launches the package....
XFBR
  • MikeG's avatar
    MikeG
    2 years ago

    Create 1 Dashboard Extender rule with 2 functions - one to Complete and one to Revert.  Do not do this by way of a DM Sequence.  There is no API for Refresh Application.  Take 1 step back to take 2 steps forward.

    Hope this helps!

  • FredLucas's avatar
    FredLucas
    2 years ago

    Hi YanSavinsky,

    I believe the following solution will give you what you are looking for with minimal changes to your existing logic:

    1. Remove the last step from your DM Sequence - EPU_Complete_WF
    2. Create a Dashboard Extender Rule that triggers the DM Sequence and updates the WF Status in case of success (see snippet below)
    3. Update the button to trigger this dashboard Extender Rule instead
    Case Is = DashboardExtenderFunctionType.ComponentSelectionChanged
  If args.FunctionName.XFEqualsIgnoreCase("ProcessDMSequenceAndUpdateWFStatus") Then
    '{REP_SolutionHelper}{ProcessDMSequenceAndUpdateWFStatus}{}
    Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()
    selectionChangedTaskResult.IsOK = False
    selectionChangedTaskResult.ShowMessageBox = True

    'Launch data management sequence
    Dim customSubstVars As New Dictionary(Of String, String) 'You can use this dictionary to pass on parameters to your DM Sequence
    Dim objTaskActivityItem As TaskActivityItem = BRApi.Utilities.ExecuteDataMgmtSequence(si, "Workflow EPU Process IFRS", customSubstVars)
    objTaskActivityItem = BRApi.TaskActivity.GetTaskActivityItem(si, objTaskActivityItem.UniqueID)
    If (objTaskActivityItem.HasError) Then ' -- If there were errors 
      selectionChangedTaskResult.Message = "Process completed with errors."
      Return selectionChangedTaskResult
    Else ' -- If DM sequence runs ok
      selectionChangedTaskResult.IsOK = True
      selectionChangedTaskResult.Message = "Process has completed successfully."
      ' You can paste and adapt your existing WF Status Update code here

      Return selectionChangedTaskResult									
    End If
  End If

     

    I hope this helps.

    Thanks,

    Fred

Pawel's avatar
Pawel
New Contributor II
2 years ago

Hello gentlemen,

I struggle with quite similar issue, the button executes the Dashboard Extender rule, it starts the DM, waits for the end, i can see the result message but the application does not refresh

What could be wrong?

FredLucas's avatar
FredLucas
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi Pawel 

Can you share your code, have you included this last part at the end?

'Complete the workflow step if and when DM sequence completes sucessfully
						BRApi.Workflow.Status.SetWorkflowStatus(si, wfToUpdate, StepClassificationTypes.Workspace, WorkflowStatusTypes.Completed, "Auto completing Workspace", _
						"Error autocompleting Workspace", "Auto completing", Nothing)						
					    ' You can paste and adapt your existing WF Status Update code here
						selectionChangedTaskResult.WorkflowWasChangedByBusinessRule = True
						selectionChangedTaskResult.IsOK = True

		      				Return selectionChangedTaskResult
  • Pawel's avatar
    Pawel
    New Contributor II
    2 years ago

    That was the final piece I was missing! Thank you!