_WF Task Assignments Cube (Custom Application)

image_pdfimage_print

Return to Workflow Building Block Overview

Workflow stores some of its data using a so-called Workflow Step Dimension. Two cubes use the workflow step dimension to store workflow-related information. This article describes one of them.

The _WF Task Assignments (<Workflow Step Dimension>) cube contains assignments of the workflow tasks that share the same step dimension. These tasks are assigned to various user groups. E.g. the cube _WF Task Assignments (Region) contains workflow tasks with the Region dimension as their step dimension; the Region elements of this task are assigned to user groups. Key users assign workflow activities to single or multiple user groups. End users within these groups are then responsible for the activity’s execution. See Assigning Activities to User Groups.

This cube consists of the following dimensions:

Dimension Definition
_WF Task This task dimension defines the data sets to be collected under workflow control (see full article).
step dimension

The workflow step dimension combines with the workflow task to create work packages.

_WF Activity This dimension defines the workflow activities (see full article).
#_GROUP_ This system dimension contains all user groups.
_WF Task Assignments_measure

This dimension contains the below measures:

  • Assigned:  1 If the workflow activity of the workflow step in the workflow task is assigned to the user group of dimension #_GROUP_. Empty otherwise. (string)
  • Active:  1 If the workflow activity of the workflow step in the workflow task is assigned and also currently active. 0 Otherwise. (calculated, string)
  • Read-Write:  1 If the workflow activity of the workflow step in the workflow task is active and defined to be read-only. 0 otherwise. (calculated, string)
image_pdfimage_print