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

WillVitale's avatar
WillVitale
Contributor II
7 months ago
Solved

Business Rule within the Import Step

Hello,

We have a custom business rule that does some account reversing we run centrally at the end our month end process. using a dashboard We're putting in a new lease process within OneStream and was wondering, is there a way instead of giving the front end user more steps within their workflow, that I can attach the business rule to the import step and once they run the "Load and Process" portion of the import step, the business rule will run?

Thanks,

Will

  • Yes, you can call your custom BR from a Data Management Sequence.  And that DM sequence can be called on the "Process" step of a workflow so it runs when the user hits "Load and Process" or "Process Cube".

    To allow the DM sequence to be called from the "Process" step, you need what is called a DataQualityEventHandler BR.  There are examples of this Extensible BR in the Blueprint or GolfStream sample applications.  This BR allows you to call a DM sequence from a workflow calculate step as follows:

     

     

     

3 Replies

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee

    Yes, you can call your custom BR from a Data Management Sequence.  And that DM sequence can be called on the "Process" step of a workflow so it runs when the user hits "Load and Process" or "Process Cube".

    To allow the DM sequence to be called from the "Process" step, you need what is called a DataQualityEventHandler BR.  There are examples of this Extensible BR in the Blueprint or GolfStream sample applications.  This BR allows you to call a DM sequence from a workflow calculate step as follows:

     

     

     

    • sameburn's avatar
      sameburn
      Icon for OneStream Employee rankOneStream Employee

      I agree with T_Kress​ , there is also an old blog post that details exact setup steps for this

      https://blackdiamondadvisory.com/library/no-calc-to-calc/

    • WillVitale's avatar
      WillVitale
      Contributor II

      Thank you for the solution! This worked out great.

      Will