Workflow cube (WorkflowCube) for Microsoft Dynamics AX 2012 R2 and R3 [AX 2012]
Updated: July 22, 2014
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
The Workflow cube for Microsoft Dynamics AX provides data that can help you track the performance and degree of automation associated with business processes in your organization, which will enable you to identify processes that have become inefficient. This article provides details about the cube.
The Workflow cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX project—and the cubes that it contains—see Deploy the default cubes.
The Workflow cube includes the following measure groups.
This measure group is based on the WorkflowCubeTransaction view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Workflow transactions count | Not applicable | Count | The number of workflow transactions, such as work items processed and work items past due. | WorkflowCubeElementLookup Workflow cube lookup Workflow transactions Date (end date) Date (start date) |
| Duration | WorkflowCubeTransaction.Duration | Sum | The duration of workflow transactions, for example, the workflow instance processing duration. | |
| MinDuration | WorkflowCubeTransaction.MinDuration | Min | The minimum duration of workflow transactions, for example, the minimum workflow instance processing duration. | |
| MaxDuration | WorkflowCubeTransaction.MaxDuration | Max | The maximum duration of workflow transactions, for example, the maximum workflow instance processing duration. | |
| Workflow tracking status | WorkflowCubeTransaction.TrackingStatus | Count | The number of workflow transactions, for example, a count of the activated, completed, pending, canceled, stopped, and unrecoverable workflow instances. |
The Workflow cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.
-
Accountant
-
Accounting manager
-
Accounting supervisor
-
Accounts payable manager
-
Budget manager
-
Chief executive officer
-
Chief financial officer
-
Compensation and benefits manager
-
Compliance manager
-
Customer service representative
-
Field service technician
-
Financial controller
-
Human resource assistant
-
Human resource manager
-
Information technology manager
-
Product designer
-
Project accountant
-
Project manager
-
Purchasing manager
-
Receiving clerk
-
Sales manager
-
Treasurer
-
Vendor account manager
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
