_WF Status Cube (Custom Application)

Return to

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 Status (<Workflow Step Dimension>) cube contains the status and complete history of all workflow tasks using the workflow step dimension. The cube consists of the following dimensions:

Dimension Definition

_WF Task This task dimension defines the data sets that workflow control will collect (see full article).

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

_WF Activity This dimension defines the workflow activities (see full article).

_WF Event

Flat list numbers (1, 2, 3, etc.) record the history of events. An event is the processing of a system or user activity and is recorded with user, timestamp, comment, etc. Measures for the current status are ~.

~ : not applicable. Stores measures of the current status.
1, 2, 3, ... : stores measures of the history.

_WF Status_measure

This dimension contains two groups of measures: measures for the current state and measures for the history. Measures from each group show fundamental aspects of the workflow sequence.

Measures for the current status:

Measures for the current status are stored by workflow activity, not an event number.

_WF Event is set the non-applicable element ~.

Element	Definition
`State`	Current status of the activity. Valid values on base level cells are: 0: Activity has not been started 1: Activity is active 1000: Activity has been finished (numeric)
`State (Consolidated)`	When elements of the workflow step dimension consolidate, the `State` values aggregate. This State (Consolidated) dimension breaks up the aggregated value to the codes 0, 1 or 1000. If the consolidated workflow step contains children with mixed states (active and finished) `State (Consolidated)` will always be active. (calculated, numeric)
`Count`	The number of base elements in the workflow step dimension are assigned directly or through an ancestor to a user group. (calculated, numeric)
`Active Rate`	Percentage between 0 and 1 of workflow steps in the active state. Consolidated elements show the average weighted numbers of base elements. (calculated, numeric)
`Finished Rate`	Percentage between 0 and 1 of workflow steps in the finished state. Consolidated elements show the average weighted by numbers of base elements. (calculated, numeric)
`State (String)`	Current status of the activity (see `State` ). If the `State (String)` has been entered on a consolidated workflow step, it is shown on all descendants. (calculated, string)
`Last Event`	The last event which occurred on the activity. Must be a base element of `_WF Event` dimension. (string)

Measures for the history:

Measures for the history are stored by an event number, not workflow activity.

_WF Activity is set to the non-applicable element ~.

Element	Definition
`Modified By`	Username who completed an activity. If the name has been entered on a consolidated workflow step, it is shown on all descendants. (partly calculated, string)
`Comment`	The comment entered by the user when completing an activity. If the comment has been entered on a consolidated workflow step, it is shown on all descendants. (partly calculated, string)
`Modified (Date)`	Timestamp of the last modification. Encoded as an Excel date (one of the number of days since 1^st January 1900). The time component (e.g. fractions of days) is used. Only valid on workflow steps on the base level. (calculated, numeric)
`Modified (String)`	Timestamp of the last modification. Encoded as Excel date which is the number of days since 1^st January 1900. The time component (e.g. fractions of days) is used. If the timestamp has been entered on a consolidated workflow step, it is shown on all descendants. (partly calculated, string)
`Occurred On Step`	The workflow step on which the activity occurred. Must be an element of the workflow step dimension. If the workflow step has been entered on a consolidated workflow step, it is shown on all descendants. (partly calculated, string)
`Activity`	Successor of the completed activity. For the last event, this will show the current activity. Must be an element of the `_WF Activity` dimension. If the activity has been entered on a consolidated workflow step, it is shown on all descendants. (string)

Updated August 25, 2023