Routing

The Routing cube shows the number of work items taking a given route between two connected steps in a workflow. It contains the following dimensions and measures.

If a field available to you is not listed in the table below, it is a user-defined data field.

Table 1. Dimensions of Routing cube
Dimension / Levels Description
Route
Isolated region
Workflow
Version
Map
Step
Destination
The routes between the source step (Step) and the destination step (Destination), broken down by specific workflow definitions at a specific version.
Table 2. Measures of Routing cube
Measure Description
Route Count Route Count shows the number of work items taking a given path from the source step.
Route Percentage At the destination step level, Route Percentage shows the percentage of work items taking a given path from the source step.
Tip: The route percentage measure will have a value of zero when the Route dimension is not drilled down to the destination step level.

For example, a company might be interested in analyzing the number of errors that occur in customer orders, as represented by the following workflow diagram. The Error step is the destination for both errors in orders and errors in shipping. The user-defined fields Customer and Shipper are exposed in the workflow database and as dimensions for Case Analyzer.

Example workflow diagram

Using the Case Analyzer Route Percentage Report the business analyst can see:
  • What percentage of the orders have an error
  • Which customers have the most errors in their orders
  • What percentage of the shipped orders have an error
  • Which shipper has the highest percentage of errors