_WF Status (Legal Entity) Cube

Return to Financial Consolidation Model Overview.

The _WF Status (Legal Entity) cube contains the status and the complete history of all workflow tasks that are using Legal Entity as a 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:

Element

Definition

~

Not applicable. Used to store measures for the current status.

1, 2, 3, …

Used to store measures for the history

  • _WF Status_measure containing two groups of measures:
    Measures for the current status are 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 started

1: Activity is active

1000: Activity has been finished

(numeric)

State (Consolidated)

On consolidated elements of the workflow step dimension, the State values will aggregate. This 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 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 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)

Note: Measures for the history are stored by the event number but not by the activity and _WF Activity is set to the not-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 Excel date which is the number of days since 1st 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 1st 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 on. 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 _WF Activity dimension. If the activity has been entered on a consolidated workflow step, it is shown on all descendants.

(string)

Updated August 28, 2023