The amazing world of IBM ODM and more

The amazing world of IBM ODM blog - Angello Manrique Vigil
  • HOME
  • ABOUT ME
  • CONTACT ME

Editing business rules in Microsoft Office

Sunday, 04 June 2017 by Angello Manrique Vigil

IBM ODM Decision Center Business Console provides a powerful web-based decision table editor. Since V8.8.1, this includes exporting a decision table to Excel. But what if we are working in previous versions? or what if the business users still want to use Microsoft Office tools like Excel or Word to create/edit the rules? That is when Rule Solutions for Office comes in handy.

Rule Solutions for Office enables you to edit business rules in Microsoft Office documents called RuleDocs. You can update and share rules with RuleDocs, which can also provide supporting documentation and information such as the original policies for the rules. It works in conjunction with Decision Center, which serves as a workspace for business users to collaborate on authoring, editing, organizing, and searching for business rules.

In this tutorial I will you show the steps to set it up correctly and start editing your business rules in Office!


Steps:

  1. Go to <Your ODM Installation Path>\Rule Solutions for Office and install the plug in.Rule Solutions for Office
  2. Login to your Decision Center Enterprise Console, you will need to have the Decision Service project already synced with Decision Center.
  3. Tip: Click here to learn more about synchronizing with Decision Center from the Rule Designer.
  4. Select the Decision Service that contains the rules you need to edit.
  5. Tip: Remember to Select the Rule Project too.IBM ODM Decision Center Rule Project selection example
  6. Now select the package with the Decision Table or Rule Action you want to edit. You will notice there is no option to edit the rule in Microsoft Office:IBM ODM Decision Center rules sample
  7. That is because we need to add configuration parameter to enable the Rule Solutions for Office editing:
    • Go to Configure and click “Installation Settings Wizard”
    • Tip: you will need to be logged in with a user that has the rtsInstaller and rtsConfigManager role to see this option.
    • Click “Step 5: Set Configuration Parameters” and click “New”
    • Search for “Enable editing in Rule Solutions for Office” option and type “true” in the value textbox:IBM ODM Decision Center configuration parameters example
    • Click Apply and Exit
  8. Go back to your rule package in the “Explorer” tab and now you should be able to see new options:IBM ODM Decision Center Rule Solutions for Office options sample

Results:

Now you are able to edit the rules in Word/Office! Explore the options that the Rule Solutions for Office provide, remember that the Rule will remain lock until you finish the editing. I hope this article helps you, please feel free to contact me with any feedback or questions! Thank you!

DecisionCenterRuleSolutionsForOffice
Read more
  • Published in Decision Center, Rule Solutions for Office
No Comments

Recent Posts

  • RPA – UiPath: Working with Excel

    In this blog post we will talk about working wi...
  • ODM on Docker!

    If you are a DevOps enthusiast like me you prob...
  • RPA: UiPath and ODM integration

    In this technical tutorial we will have a look ...
  • Populating Decision Tables with external data sources

    One of the most used artifacts in IBM ODM is th...
  • Decision Composer, integration with Rule Designer

    In this post I will show a new way to start you...
  • Connecting to external Database with ODM API

    The IBM ODM Decision Center and the Rule Execut...
  • Custom log file with ODM API

    Given the positive feedback from previous post ...
  • Working with the Decision Center API

    In many IBM ODM rules implementation projects w...
  • Automating deployments with Ant tasks

    To deploy RuleApps to Rule Execution Server, au...
  • Editing business rules in Microsoft Office

    IBM ODM Decision Center Business Console provid...

Categories

  • Ant Tasks
  • Bluemix
  • Cloud
  • Database
  • Debug
  • Decision Center
  • Decision Operation
  • Decision Table
  • Decision Warehouse
  • Docker
  • Domains
  • Java
  • ODM API
  • RPA
  • Rule Authoring
  • Rule Designer
  • Rule Execution Server (RES)
  • Rule Solutions for Office
  • Ruleflow
  • UiPath

Recent Posts

  • RPA – UiPath: Working with Excel

    In this blog post we will talk about working wi...
  • ODM on Docker!

    If you are a DevOps enthusiast like me you prob...
  • RPA: UiPath and ODM integration

    In this technical tutorial we will have a look ...
  • Populating Decision Tables with external data sources

    One of the most used artifacts in IBM ODM is th...
  • Decision Composer, integration with Rule Designer

    In this post I will show a new way to start you...

Recent Comments

  • Mastan on Debugging a simple Ruleflow in Rule Designer
  • Angello Manrique Vigil on ODM on Docker!
  • brian on ODM on Docker!
  • Angello Manrique Vigil on Populating Decision Tables with external data sources
  • Pramod on Populating Decision Tables with external data sources

Subscribe

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

All rights reserved. Made by Angello Manrique Vigil.

TOP