_WF Task Assignments Cube (Custom Application)

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)

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)

Updated August 25, 2023