Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
3 years ago
Solved

Data management sequence as workflow step

Hi,

is there an easy way to setup a workflow step to run a data management sequence?

I have an existing data mng sequence and I'd like users to run it from a workflow profile.

Thank you

Workflow
  • SamRichards's avatar
    SamRichards
    3 years ago

    Hey Afone, 

    100% agree with Henning, that is a very common way to do it and I would say if you were using a form workflow then 100% go with Henning suggestion. If it is an import workflow, then you can use an extender rule to and put the DM sequence name in the filter and then when the workflow processes it will kick off the Dm sequence. Let me know if you want the extender rule and I can put it in here.

    Thanks,

    Sam

  • AndreaF's avatar
    AndreaF
    3 years ago

    Mine is an import workflow, so what I did is to set the form step of the workflow to workflowtype = "preprocess, form input", and its calculation definition to No Calculate, with filter value equal to the name of the data mng sequence.

    I have then found and added to the application extensibility rules a Data Quality Event Handler rule, which  execute the DataMgmt Sequence that was specified in the filter value.

    The DataMgmt Sequence now runs when I press Process cube from the form step of the workflow.

8 Replies

Sort By
  • SamRichards's avatar
    SamRichards
    Contributor
    3 years ago

    Hey Afone, 

    100% agree with Henning, that is a very common way to do it and I would say if you were using a form workflow then 100% go with Henning suggestion. If it is an import workflow, then you can use an extender rule to and put the DM sequence name in the filter and then when the workflow processes it will kick off the Dm sequence. Let me know if you want the extender rule and I can put it in here.

    Thanks,

    Sam

    • AndreaF's avatar
      AndreaF
      Contributor III
      3 years ago

      Mine is an import workflow, so what I did is to set the form step of the workflow to workflowtype = "preprocess, form input", and its calculation definition to No Calculate, with filter value equal to the name of the data mng sequence.

      I have then found and added to the application extensibility rules a Data Quality Event Handler rule, which  execute the DataMgmt Sequence that was specified in the filter value.

      The DataMgmt Sequence now runs when I press Process cube from the form step of the workflow.

    • WernerN's avatar
      WernerN
      Contributor
      4 months ago

      SamRichards 
      Hi Sam,
      I know this dialog is 2 years old but may i come back to your kind offer of the extensibility rule.
      I understand from the Des&Ref Guide that we create an DataQalityEventHandler that reads teh sequence name and calls DM?
      I was hoping to use your rule as a short cut to the event (I will also dig thru the API Guide after sending this reply).
      Thanks in advance,

      • SamRichards's avatar
        SamRichards
        Contributor
        4 months ago

        Hey Werner, 

        If you have access to the GolfStream application it should be in there. The Extensibility rule is DataQualityEventHandler. The process that AndreaF is calling is the No Calculate function. This function is set up to run via the calculate step in the workflow. You define an entity and set it up as a No Calculate calculation type, then you define the DM sequence in the filter value for the rule to run. When the workflow is processed that will kick off the DM sequence.

        Thanks,

        Sam

  • Henning's avatar
    Henning
    Valued Contributor II
    3 years ago

    Hi Afone, there are several ways. An easy way is to create a button in a dashboard that executes your DM sequence and add that button/dashboard to the workflow.

  • AndreaF's avatar
    AndreaF
    Contributor III
    3 years ago

    Thank you both, I will have a look at your suggestions and let you know how it when once done!

  • WernerN's avatar
    WernerN
    Contributor
    4 months ago

    OMG, that was fast!  thank you so much.  Going to GolfStream now.

    • WernerN's avatar
      WernerN
      Contributor
      4 months ago

      Thank you Tom for not encrypting code in 2013. And thanks again Sam for pointing me to Golfstream. That should have been my first place to look at.