TM1 Tutorials.com

TM1 10.2 – Enhancement: Workflow can trigger Processes

In this new version of TM1, 10.2, a new feature has been added to enable the change of workflow state of a node to trigger TI processes.  A preset TI process can be triggered immediate before and immediate after the workflow action.

This feature can be quite useful in a lot of ways, for example, if you have a separate BI report cube setup, when a node is submitted, TI process can be triggered to update the BI report cube without extra actions.  And once all the nodes are locked, then you can be sure that BI reporting cube is ready for reporting, without running extra processes.

Here are few simple steps:

  1. In Application Design mode, double-click on an application that you wish to update.
  2. In the Properties pane, scroll down to select Custom Processes, and click on the Ellipse … to bring up the Custom Processes Settings screen.
  3. Here you can specify which workflow actions can be enabled to trigger a TI process, either immediately before or immediately after the action, as well as the process need to be triggered.

There you go, a very useful feature that requires just a few simple steps.  This feature can potentially enhance and streamline the business planning processes.

Some examples of how this feature can be used:

  • Updating BI Reporting Cube: To ensure the BI reporting contains the latest planning data, TI process can be triggered immediately after a node is committed or submit.  A process is triggered to update a separate reporting cube (it would not matter if it is on the same or different server instance) from the planning cubes.  This would not require separate action to update BI reporting cube (or improve efficiency in case your reporting cube is linked by rules).
  • Import latest actuals from ERP: To ensure the user is seeing the latest and greatest actuals from your ERP, a TI process can be kicked off to import actual financial data from EPR just before user takes ownership.
  • Notify other users when a node is committed: When there are multiple contributors to an application node, can utilise a TI process to notify all relevant users that data is updated, and peer review may be required.
  • Trigger report distribution/printing: When a top consolidation node is locked/submitted against a business unit, it triggers report distribution to all managers for that particular business unit.  If all managers have access to the reporting portal online, this TI process can act as a notification mechanism.
  • Sending reviewer or contributor an email on submit or reject of a node: triggers a process to notify all parties involved.
  • Process to lock/unlock a node: In some cases, the business may want to prevent contributors from updating a node when it has been taken offline.  A process can be triggered to lock access on the server to that specific node immediately after it has been taken offline, and a process to unlock it just before it is brought back online again.

The list can go on and on, it really depends on your business and application, and how this feature may enhance your planning process.

 


Categorised as: IBM Cognos TM1, Performance Modeler, TM1 10.2


3 Comments

  1. Zhanna says:

    Hi
    I would add to your tutorial that TI process has to be configured in a special way first, it should have 4 parameters – pExecutionid, pAppid, pNodeid and pWorkflowAction,, otherwise it will not run.
    Regards,

    • Dan says:

      Thank You Zhanna. I looked a long time for this answer. Had to dig into the pmpsvc.log. I should have come here first

  2. Alladin says:

    Very Nice Post!

    I have define a custom TI Process with 4 PreReq Parameters but I am still getting an error message when commiting the data.

    I am just getting my hands messy with 10.2.2 and have couple of question.

    How should I define those 4 Parameters in advance tab under paraeters? For example as string values or Numeric.

    Also, I am not sure what to put as a default value. I know App ID, but rest is kind of not making any sense to me 🙂

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *