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 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 ~.
|
||||||||||||||||||||||||||||||
_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.
Measures for the history: Measures for the history are stored by an event number, not workflow activity.
|