Workflow cube (WorkflowCube) for Microsoft Dynamics AX 2012 R2 and R3

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.

Reference

Deployment

Configuration keys

Tables and views

Measures

Calculated measures

Key performance indicators

Security

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