Workflow Administration Report

Return to

Model Overview

The workflow implementation for this model helps users to collect planning data. The workflow restricts the write access to reports in a timely manner. Users can only enter and modify planning data within workflow activities. Outside of these activities, the modification is inhibited. This enables a workflow administrator to gain control of modifications and ensures data integrity.

This report is intended for the process owner of the workflow. The purpose of the Workflow Administration report is to set up, administrate, and monitor the workflow process.

The following forms are part of the Workflow Administration report:

Follow the steps below to set up a new workflow task:

  1. Create a new element in _WF Task Dimension (via Modeler).
  2. Select a dimension as your Step Dimension from the cube which should be controlled and create new Workflow Cubes (_WF Status (Name of Step Dimension) and Task _WF Assignments (Name of Step Dimension)).
  3. Edit due dates.
  4. Assign workflow steps to user groups (Workflow Assignments).
  5. Start your process (Workflow Administration).

Report Heading

The screenshot below points out the heading area of the Workflow Administration report. The logo can be changed in Administration; see Configuring Design Elements for more on report design.

Workflow Status Control Panel

The state of the data collection process can be controlled from this menu.

The available options and visualizations are described below:

Field Description Implementation
Task (Combobox) Select the workflow task (e.g. the Cost Center Mid-Term Planning report for 2019) to set up a plan for. This is related to the reports where users will enter planning data (e.g. Cost Center Mid-Term Planning report). Selection of elements which start with the prefix of a Model name (e.g. Cost Center) of dimension _WF Task , additional elements can be added to the dimension to represent other workflow tasks. To ensure that it is working with planning reports define the element name as described in the _WF Task Dimension article.
... Opens the Workflow Task form to define step dimension and workflow type for the workflow task, create workflow cubes and edit due dates and assignments Opens the //Models/<Model Name>/Reports/Detail/<Model Name> Workflow Task.wss report.
Reset (button) Stops workflow process that is underway and clears the status and the history. Deletes all state and history information from the _WF Status (Name of Step Dimension) cube. The properties of the workflow task stored in the _WF Task Definition cube and the assignments stored in the _WF Task Assignments (Name of Step Dimension) cube will stay intact. The operation is encapsulated by the workflow_reset_task() function in the workflow.php library.
Start (button) Starts a workflow process from the beginning or starts a paused or stopped workflow process again. Sets the State and other measures in the _WF Status (Name of Step Dimension) cube.
The operation is encapsulated by the workflow_start_task() function in the workflow.php library.
Pause (button) Pauses a running workflow task. The paused workflow process activates cell protection in the planning reports. A paused workflow process can be started again with the Start button. Sets the State and other measures in the _WF Status (Name of Step Dimension) cube.
The operation is encapsulated by the workflow_suspend_task() function in the workflow.php library.
Stop (button) Stops a running or paused workflow task. A stopped workflow task can be started again with the Start button. A stopped workflow process removes any workflow-related cell protection and blocks the progress of the workflow. Cell functions will work as stated within the cell locking section of the planning report articles e.g. in the Cost Center Mid-Term Planning report. Sets the State and other measures in the _WF Status (Name of Step Dimension) cube.
The operation is encapsulated by the workflow_disable_task() function in the workflow.php library.
Workflow Status Summary (diagram) See the status of the workflow process for various activities (e.g. Data Entry, Review, and Revise). Shows the share of activities on the root step of the workflow step dimension. The shares are read from the he Active Rate measure for all user activities and the Finished Rate measure for the final system activity in the _WF Status (Name of Step Dimension) cube. These are taken from the the ~ (Not applicable) element in the Event dimension. The root step of the workflow step dimension is encapsulated by the workflow_root_step() function in the workflow.php library.

Workflow Step Table

The columns displayed in the report are shown below:

Below are descriptions of the columns in the Workflow Step table.

Column Description Implementation
Step Dimension Displays the elements of the workflow step dimension Elements of the step dimension
Step Dimension Name Displays the name of the workflow Step Dimension element Name attribute of the step dimension
Last Activity Displays the name of the last workflow activity Reads the Activity measure in the _WF Status (Name of Step Dimension) cube. This is taken from the most recent element for this workflow step in the Event dimension on the ~ (Not applicable) element of the _WF Activity dimension.
The access to this measure is encapsulated by the workflow_history() function in the workflow.php library.
Modify, Modified By Shows the date, time, and user of the last modification of the workflow step Reads the Modified (Date) and Modified By measures in the _WF Status (Name of Step Dimension) cube. These are taken from the most recent element for this workflow step in the Event dimension on the ~ (Not applicable) element of the _WF Activity dimension.
The access to these measures is encapsulated by the workflow_history() function in the workflow.php library.
Information symbol The symbol is shown only, when a comment has been entered for the last activity. This comment is shown as a tooltip when hovering the mouse cursor over the information symbol. Reads the Comment measure in the _WF Status (Name of Step Dimension) cube. This is taken from the most recent element for this workflow step in the Event dimension on the ~ (Not applicable) element of the _WF Activity dimension.
The access to this measure is encapsulated by the workflow_history() function in the workflow.php library.
Current Activity Displays Name attribute of the element in the workflow step dimension Identifies the element of the _WF Activity dimension that has the value 1 on the State (Consolidated) measure in the _WF Status (Name of Step Dimension) cube. This is taken from the the ~ (Not applicable) element in the Event dimension.
The access is encapsulated by the workflow_get_current_activity() function in the workflow.php library.
Due Date Displays the Due Date of the workflow activity Due Date measure of the _WF Task Definition cube
Traffic Light Shows a red traffic light when the due date of the current activity for that workflow step is overdue. Shows a red traffic light when the day specified in the Due Date measure of the _WF Task Definition cube has completely elapsed.
Assigned Displays the group(s) to which the workflow step has been assigned to Identifies the elements of the #_GROUP_ dimension that have the value 1 on the Assigned measure in the _WF Task Assignments (Name of Step Dimension) cube.
The access to this measure is encapsulated by the workflow_activity_assignements() function in the workflow.php library.
... Opens the Workflow Detail form Opens //Models/<Model Name>/Reports/Detail/<Model Name> Detail.wss

Updated December 9, 2024