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

Updated: July 3, 2012

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.

The Workflow cube does not require any configuration keys.

The Workflow cube uses data from the following tables and views:

  • WorkflowCubeElementLookup view

  • WorkflowCubeLookup view

  • WorkflowCubeTransaction view

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 does not include any calculated measures.

The Workflow cube does not include any key performance indicators (KPIs).

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).

Community Additions

ADD
Show: