Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 days ago
Solved

Data Management Step Service documentation missing ?

Hello,

It looks like the data management step service in assemblies is currently not documented in the online Help.

Does anyone have experience, snippets to share in order to leverage this service?

How is it triggered? What can we do with it ?

Regards,

 

Metadata
  • SteveK's avatar
    SteveK
    2 days ago

    I would have thought that you could use DashBoard Parameters to pass that info to the DM Task at the Step or Sequence level, and then get them from the args.NameValuePairs dictionary once in the Service BR.

    For bonus points you can use BRAPi.TaskActivity.UpdateRunningTaskActivityAndCheckIfCanceled to popup a message to them saying what the DM Task is about to do - just delay it so they get a chance to read the message with something like System.Threading.Thread.Sleep(5000)

6 Replies

  • Sergey's avatar
    Sergey
    Icon for OneStream Employee rankOneStream Employee
    3 hours ago

    Thanks both (again) for your valuable inputs !

    For the time being, I will use your open place solution sameburn​ which is what the users wants to see, while I will indeed work with the BR to define the data points to export for a later stage :)

    Regards,

  • Sergey's avatar
    Sergey
    Icon for OneStream Employee rankOneStream Employee
    2 days ago

    Thanks Sam & Steve,

    Could we use it in order to create a "dynamic data management job" ?

    In my case, I would like to let the user define what they want to export, so being able to define the POV but also if they want to remove 0 etc ...

    Can it be achieved with this Data Management Service, or maybe through dynamic dashboards perhaps ?

    Regards,

    • sameburn's avatar
      sameburn
      Icon for OneStream Employee rankOneStream Employee
      2 days ago

      So think of the Data Management service as the ability to run traditional Data Management steps / sequences from within a workspace and do the same thing an Extensibility rule does via a workspace assembly.

      So for your use case if you want to build a dashboard or a dynamic dashboard, you would still need to pass in parameters to resolve these selections via dashboard components to invoke a Data Management step or sequence. It is not possible currently to make a dynamic Data Management step using the dynamic dashboards service.

      So this is nothing ground breakingly new. But it enables us to call DM jobs via the Service Factory and organise and maintain all of our solution elements / code in a workspace / maintenance unit (e.g 1 xml)

      Hope this helps clarify

      Sam

    • SteveK's avatar
      SteveK
      New Contributor III
      2 days ago

      I would have thought that you could use DashBoard Parameters to pass that info to the DM Task at the Step or Sequence level, and then get them from the args.NameValuePairs dictionary once in the Service BR.

      For bonus points you can use BRAPi.TaskActivity.UpdateRunningTaskActivityAndCheckIfCanceled to popup a message to them saying what the DM Task is about to do - just delay it so they get a chance to read the message with something like System.Threading.Thread.Sleep(5000)

  • SteveK's avatar
    SteveK
    New Contributor III
    2 days ago

    I call the DM Service from the DM Step in the Assembly using the BR Workspace.Current.CSL_Test.My_DataMgmtHelpers (assuming it's enabled in the Service Factory for the Assembly), then the main code in the DM service class is:

    Select Case args.FunctionType

    Case Is = ExtenderFunctionType.Unknown

    Case Is = ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep
    Dim strDMSequenceName As String = args.DataMgmtArgs.Sequence.Name.ToUpper
    Select Case strDMSequenceName
    Case "MyDMSeq"
    '<My Code>

    End Select

    End Select

    I'm using the DM Sequence name here in the SELECT Case to decide what to do

    Steve