Workflow cube (WorkflowCube) for Microsoft Dynamics AX 2012 R2 and R3
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
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.
.png "Reference")
Deployment Configuration keys Tables and views Measures Calculated measures Key performance indicators Security |
.png "Resources")
Analytics in Microsoft Dynamics AX Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3 Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack |
Deployment
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.
Configuration keys
The Workflow cube does not require any configuration keys.
Tables and views
The Workflow cube uses data from the following tables and views:
WorkflowCubeElementLookup view
WorkflowCubeLookup view
WorkflowCubeTransaction view
Measures
The Workflow cube includes the following measure groups.
Workflow transactions
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. |
Calculated measures
The Workflow cube does not include any calculated measures.
Key performance indicators
The Workflow cube does not include any key performance indicators (KPIs).
Security
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