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.
_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:
||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.|
||This dimension defines the workflow activities (see full article).|
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 ~.
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.
Measures for the history:
Measures for the history are stored by an event number, not workflow activity.