Dictionary of data fields used in mavim process mining
Dictionary of data fields used in mavim process mining A Activity The activity name of the event. -- KA-01564
A
Activity
The activity name of the event.
Activity target
The activity name of the next event.
Automatic
Whether or not the event has been automatically executed. For instance; by an RPA bot.
AutomationRate
The average automation rate for a case based on the Automatic-column in the event log.
AverageAutomationRate
The average automation rate for the whole process; based on the Automatic-column in the EventLog.
AverageAutomationRatePrevMonth
The average automation rate in the previous month; based on the measure AverageAutomationRate.
AverageNumResourcesPerStep
The average number of resources per step for the whole process; based on the Resource-column in the EventLog.
AverageNumResourcesPerStepPrevMonth
The average number of resources per process steps in the previous month; based on the measure AverageNumResourcesPerStep.
B
Bookmark
This field is only used to support the bookmark feature. To enable this feature; drag and drop each Filter columns from the FilterAnd and FilterOr table in the Bookmarks bucket and choose First.
C
Case attributes
A case attribute is a characteristic that describes a case/instance.
CaseAttributesTable
If you have case attributes in a seperate table; specify their name here.
Case Id
The unique case identifier.
Cost
A variable indicating cost per event. Has no implicit unit. Represents the Cost-column from EventLog.
D
Duration
The total lead time between two adjacent events in seconds. Includes activity execution time (if set).
DurationActivity
The total execution time of an activity. Is calculated from Timestamp to TimestampEnd.
DurationAtActivityEnd
This measure is used in the Mavim Lead Time Calculator.
DurationAtActivityStart
This measure is used in the Mavim Lead Time Calculator.
DurationIdle
The total idle time between two activities. Excludes activity execution time. If activity duration is not set in the event log; Duration and DurationIdle will be the same.
DurationDays
The total lead time in days.
E
Edge
Helper column for FilterAnd- and FilterOr-tables.
Edge Labels
Here you can enter values that you want to be displayed as information on the paths in your process flow. (e.g CaseId from the EventLog table). The Number of Edge Labels selected in the formatting pane defines the number of the attributes (listed at the top of the Edge Labels bucket) that will be displayed as information on the process path labels. Additionally; all the attributes will be shown as a tooltip.
Edge Thickness
Select an attribute to determine the path width. For example; if you want the paths to differentiate by the number of cases; drag the case_id column from the Event Log table into the Edge Thickness panel and select Count from the drop-down-menu.
Edge Highlight
Select an attribute to be used to determine the path color. For example; if you want to highlight the paths that have a long average lead time; drag Duration from the EventLog table to the Edge Highlight bucket and choose Average in the drop-down-menu.
EndActivity
The last activity of each case.
EndDate
The date (day; month; and year) on which the case has ended. Also see EndDateMonth and EndTime. EndTime The time on which the case has ended. Also see EndDate.
EndDateMonth
he date (month and year) on which the case has ended. Also see EndDate and EndTime. This column is needed for the Report Server-version.
Event attributes
An event attribute is a characteristic that describes an activity.
EventLogTable
Specify the name of the database table which contains the event log.
EventNumber
The position of an event in the case. Start event will have number 1.
F
Filter Include
Display all process variants containing the selected nodes/paths.
Filter All
Include All means only those process variants containing all selected nodes/paths are displayed.
Filter Any
Include Any means all process variants containing at least one of the selected nodes/paths are displayed. Filter Exclude Display all process variants not containing the selected nodes/paths.
G
GroupAutomationRate
The calculated column creates bins for the automation rate of cases. It can be used for visualizations; e.g. as an axis for a bar chart.
GroupDuration
The calculated column creates bins for the total lead time of cases. It can be used for visualizations; e.g. as an axis for a bar chart.
GroupProcessSteps
The calculated column creates bins for the total number of process steps of cases. It can be used for visualizations; e.g. as an axis for a bar chart.
H
HasLoopsOrSelfLoops
This calculated column puts a flag whether a case has either a loop or a selfloop (1) or not (0).
I
IsRework
Indicates that this activity already occurred earlier in the case.
IsLoopsOrSelfLoops
This calculated column puts a flag whether a activity has either a loop or a selfloop (1) or not (0).
L
Legend
Here you can enter a categoric value to split the graph into different categories.
Linear Highlight
Creates a linear based scale for the highlight values
Loop
Whether the current activity occurs for at least the second time in the case. Can be used in the Mavim Process Explorer as an edge highlight. LongDuration
Cases with a duration in bin (g) of GroupDuration.
Log Highlight
Creates a logarithmic based scale for the highlight values
N
Node Tooltips
This field is used to display values on the node as a tooltip.
Node Size
Select an attribute to determine the node size. For example; if you put the CaseId column from the EventLog table into the Node Size bucket and choose Count in the drop-down-menu; the nodes are scaled depending on the number of cases that went through individual nodes.
Node Highlight
Select an attribute to determine the nodes marked by a color similar to the Edge Highlight.
NumActivities
Distinct number of activity names.
NumEvents
Total number of events (process steps) in the case (i.e.; a case with loops will have higher number of events than activity names).
NumLoops
Number of loops in the case. Self-loops do not count up this number.
NumResources
Number of resources of a case based on the column Resource of the EventLog.
NumSelfLoops
Number of self-loops for the case. Loops do not count up this number.
O
Outlier Highlight
Creates a linear based scale for outliers; which is similar to a box plot.
P
PathId
Relationship column for FilterAnd- and FilterOr-tables.
PercentCasesWith(Self)Loops
Percentage of your cases which have either loops or selfloops.
PercentCasesWith(Self)LoopsPrevMonth
Percentage of your cases which have either loops or selfloops in the previous month based on the measure PercentCasesWith(Self)Loops.
PercentCasesWithLongDuration
Percentage of your cases with a duration equal or longer as calculated in GroupDuration in category (g).
PercentCasesWithLongDurationPrevMonth
Percentage of your cases with a duration equal or longer as calculated in GroupDuration from the previous month based on the measure PercentCasesWithLongDuration.
PercentCasesWithManyProcessSteps
Percentage of your cases with process steps equal or higher as calculated in GroupProcessSteps in category (g).PercentCasesWithManyProcessStepsPrevMonth
Percentage of your cases with process steps equal or higher as calculated in GroupProcessSteps in category (g) in the previous month based on the measure PercentCasesWithManyProcessSteps.
PercentSelectedCases
Percentage of your selected/displayed cases. It is used for the gauge visualizations; e.g.; in the Discovery. PercentSelectedVariants Percentage of your selected/displayed variants. It is used for the gauge visualizations; e.g.; in the Discovery.
PercentUniqueVariants
Percentage of your unique variants; i.e.; variants with only one case.
PercentUniqueVariantsPrevMonth
Percentage of your unique variants in the previous month based on the measure PercentUniqueVariants.
Probability
Transition probability for one activity directly following another. Can be used in the Mavim Process Explorer as an edge highlight or edge tooltip.
R
Resource
The resource executing the event. Represents the Resource-column from the event log.
Root Cause Analyzer
Root Cause Analyzer helps you to identify the most likely root causes of behaviors; patterns or problems in your process.
S
SelfLoop
Whether the next activity is the same as the current.
StartActivity
The first activity of each case.
SortKey
You determine the sorting of activities with simultaneous execution. If two process steps are carried out simultaneously
StartDate
The date (day; month; and year) on which the case has started.
StartDateMonth
The date (month and year) on which the case has started.
StartTime
The time on which the case has started.
StartDateYear
The year on which the case has started.
T
Target
The Mavim Process Analyzer visual needs this information to recognize subsequent events of a path.
TimestampDate
The date on which the execution of the event has been started.
TimestampDateEnd
The date on which the execution of the event has ended. If no end time is given in the event log this will be the same as TimestampDate; resulting in 0s execution time.TimestampEnd describes the point in time where an activity/event ends. If additional information about durations; such as the duration of an activity or the idle time between activities is required; this field is crucial.
TimestampTargetDate
The date on which the execution of the next activity has started. See TimestampTargetTime.
TimestampTargetDateEnd
The date on which the execution of the next activity has ended. If no end time is given in the event log this will be the same as TimestampDateEnd; resulting in 0s execution time.
TimestampTarget
The time on which the execution of the next activity has started. See TimestampTargetDate. TimestampTargetTimeEnd The time on which the execution of the next activity has ended. If no end time is given in the event log this will be the same as TimestampTimeEnd; resulting in 0s execution time. Top1VariantCoverage
Percentage of your cases covered by the most frequent variant. If not filtered; variant with ID 1 is the most frequent.
TotalCost
The total cost of your case based on the column Cost from the EventLog.
V
Variant
The unique order of activities in the case. Most frequent variant will be number 0.
Variants
To enable the slider in the Process Explorer; drag this measure into the Variants-bucket of the Process Explorer.
VariantIsUnique
Whether the case variant is unique among all cases. Can be 1 (variant is unique) or 0 (variant is not unique).
Variant Indicator Only successors
Shows the successor of the process node or edge clicked.
Variant Indicator Only predecessors
Shows the predecessor of the process node or edge clicked.
Variant Indicator Sucessors and predecessors
Shows the successor and the predecessor of the process node or edge clicked.
#
#Cases
The constant total number of all cases in the event log. Does not change the number on any filter.
#Events
The constant total number of all events in the event log. Does not change the number on any filter.
#Variants
The constant total number of all variants in the event log. Does not change the number on any filter.