Process Builder


Process Builder allows you to:


Run and Schedule Processes


Edit or delete existing Process


Explain the Execution Plan of an existing Process


                       Refreshes the list of processes from the database


               Submits a process for execution by the Process Manager.


               Saves any changes you have made to an existing Process.


               Allows you to create a new process based on an existing Process.


               Deletes an existing Process.


               Allows you to define a new Process.

               Opens the Process Manager window.

               Opens the Workflow Builder window.

                       Opens the FinanceHub Help file.

                       Closes the Process Builder window.


Process Selection


Allows you to choose a process.  Process can be stored in virtual folders to help you group related processes into easy to find Process Groups. Use the  button to search for a process.


Once you have selected a process you wish to execute, you can schedule the process by checking the 'Schedule" box and then using the "Run at this time" Calendar and Clock interface. Check the 'Preserve Schedule Mode' to keep your schedule settings after you run the process, if unchecked the time and date will reset on clicking run.


If you want it to run immediately, you can reset the clock to "now" by just pressing the  button.



Execution Plan

Once you have selected a process you can view Execution Plan for the selected Process or Workflow by pressing the,  button.


The Execution Plan window allows you to see at a glance what is going to be executed by the selected Process.   The viewer also shows you any Limits that will be applied to the Process.


If you are running a program as part of your process, you can highlight a program, and press the  will bring up the OLAP DML program viewer.


Properties


Standard Limits



Standard Limits, allows you to specify any Limits you wish to be applied when the Process is executed.  As well as LIMIT statements you can enter any free-form OLAP DML statement you wish to be executed.  Standard limits are part of the Process and usually are set as persistent.


This Process Limits



This Process Limits, are non-persistent limits and are only executed once when you Submit the process this time.   This Process Limits override any Standard Limits.


Program



Program allows you to View, Edit & Save, Copy to Clipboard a program attached to the selected Process.


Process Properties



Protect Process From Delete


Processes protected from delete can not be deleted until the Lock is removed.  This is designed to stop accidental deletion.  


Program Assigned to Process


This shows you the OLAP DML program assigned to a Process and allows you to change the assigned program, press Save Changes after updating the assigned program.


Folder Process Stored In


Folder Process Stored In, is the name of a virtual Folder which the process is stored in.  All Processes are always stored in the "All" virtual folder.


Create a New Folder


Create a New Folder, allows you to specify a name of a new Folder and assign it to a Process.   If no processes remain in a Folder, the folder automatically is purged.   A folder can be created again and processes assigned to it.


Process Name


The name of the process.  This can not be changed, to change the name of a Process, copy the process, creating it with the desired name and then delete the original Process.


Runtime Information


The runtime information panel indicates which Analytic Workspace the Process or Workflow is designed to be executed within.