Workflow cube (WorkflowCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack

Applies To: Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The Workflow cube 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.

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