_WF Status (Customer) Cube
Return to Sales Model Overview
The _WF Status (Customer)
cube contains the status and the complete history of all workflow tasks using Customer
dimension as workflow step dimension. All measures for the current status are stored by workflow activity, but not by an event number. All measures for the history are stored by the event number but not by the activity. The cube consists of the following dimensions:
- Dimension
_WF Task
: See the article _WF Task dimension. - Dimension
Customer
: This is the workflow step dimension which is shared with the fact cube. - Dimension
_WF Activity
: See the article _WF Activity dimension. - Dimension
_WF Event
: Flat list of numbers 1, 2, 3, etc. to record the history of events. An event is processing of a system or a user activity and is recorded with user, timestamp, comment, etc. Measures for the current status are stored on the~
.
Element |
Definition |
~ |
Not applicable. Used to store measures for the current status. |
1, 2, 3, … |
Used to store measures for the history |
- Dimension
_WF Status_measure
containing two groups of measures:
Measures for the current status is stored by workflow activity, but not by an event number –_WF Event
is set to the not-applicable element~
.
Element |
Definition |
State |
Current status of the activity. Valid values on base level cells are: 0: Activity has not been stared 1: Activity is active 1000: Activity has been finished (numeric) |
State (Consolidated) |
On consolidated elements of the workflow step dimension the (calculated, numeric) |
Count |
Number of base elements in the workflow step dimension directly or through an ancestor assigned 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 by 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 (calculated, string) |
Last Event |
The last event which occurred on the activity. Must be a base element of (string) |
Note: Measures for the history is stored by the event number but not by the activity and _WF Activity
is set to the not-applicable element ~
.
Element |
Definition |
Modified By |
User name 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 Excel date (number of days since 1st January 1900). The time component (fractions of days) is used. Only valid on workflow steps on base level. (calculated, numeric) |
Modified (String) |
Timestamp of the last modification. Encoded as Excel date (number of days since 1st January 1900). The time component (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) |
Occured On Step |
Workflow step on which the activity has been proceeded. 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 active activity Must be an element of the (string) |
Updated August 25, 2023