NEW EXTENSION: Basic Functions

NEW

•Initial functionality with translation files from all MPM-Extensions

•See more

NEW EXTENSION: Dialog Box

NEW

•Basic functionality for Popup/Dialog in Qlik sense

•Add Master visualization object, html/plain text in the textarea

•Multilanguage support

•Integration of Basic Functions for Translation

•See more

NEW EXTENSION: Lead Time Filter

NEW

•Initial functionality to select two activities from your app and calculate a lead time between them

•See more

NEW EXTENSION: Grouped container

NEW

•Basic functionality to structure your Qlik Sense objects (Master items) freely in a container

•See more

Process analyzer

improvements

•Simpler UX: the bar and sliders moved in a reduced form to the bottom

•More layout options available for edge routing & layout algorithms: chose what you need - improved performance or a perfect layout  

•See more

query builder

NEW

•Improved Usability: copy the resulting query via button helps developers to reuse the pattern in formulas or the back-end

•Integration of BasicFunctions for translations

Process Modeler

NEW

•Improved Usability: copy the resulting query via button helps developers to reuse the pattern in formulas or the back-end

•Integration of BasicFunctions for translations

•See more

BPMN-modeler

NEW

•Multi language support

•Integration of BasicFunctions for translations

•Improve navigation layout

•See more

Process Activity Filter

NEW

•New selection option added: now you can select whether a process should start or end with an activity

•Integration of BasicFunctions for translations

•See more

ProcessVariantsInspector

NEW

•Integration of BasicFunctions for translations

•See more

MPM Scripts, Data Editor & Data Model

NEW

•New Variables in the 0.init tab:

oLet mvShowPeriodComparison = false();

oLet mvShowCostCalculation = false();

oSet mvIntervalFormat = 'd hh:mm';

oLet mvNetAndGrossTimes = 0;

oLet mv_SwitchEventResourceLog = 'Standard';

•New variable on the 2B. tab:

oLet mvNetAndGrossTimes

•New Variables on the 2A. tab:

oSet mvPercentageTimeLimit (replaces the former upper & lowerLimit-variables)

oSet mvPercentageTimeLimitOperator

oSet mvPercentageAutomationLimit

•MasterScript:

oMaster Items can now be deleted

oNew search functionality

oDuplicate warning

FIXes

•The method call mw_pa_init_mining on the script tab 1A and 3 has been adapted.

•The parameter in the multilanguage master item method have been adjusted.

improvements

•In the data editor:

oFor some front-end variable a default is set in the data editor:

▪Let mwNetOrNot = null();

▪Let mvCustomLeadTimeQualifier = 'StartToEnd';

▪Let mvTimeRangeFrontEnd = 'In Year';

▪Let  mvProcessDescriptionResource = '';

oThe WeekendDays variable on the 2B. tab has been removed

oThe number of time-related precalculated flags in the RootCauseAnalysisFlags table has been reduced.

oFewer method calls after the MasterItems inline table.

oThe fields "DE_Description", "EN_Description" and "ES_Desctiption" have been added to the InputTranslations table.  Now a description of all MasterItems depending on the selected default language will be loaded into the app.

•In the core MPM data model:

oThe Custom Lead Time in now named Subprocess and the CustomLeadTimes_$(mvProcessDescription) is now named SubprocessDefinition_$(mvProcessDescription)

oThe CaseTimes-table now contains on row per subprocess time, subprocess times and the standard lead time (start to end) are treated the same and fill the same fields. Due to the restructuring some fields became obsolete and have been deleted.

oFor subprocesses information about the target time is given and further fields related to missed target times are derived

oFor each subprocess the information SubprocessFinished = 1 or 0 is stored in the CaseTimes-table

o1:1 Case-related information (like root cause analysis optimization potentials) are stored in the (now mandatory) case information table.

oThe CaseInformation table is now named CaseInformation_$(mvProcessDescription).

oThe field CaseCounter and ProcessFinished moved to the table CaseInformation.

oThe lead time information are provided as net and gross values only if the factoryAndShiftCalendar is defined and the variable mwNetAndGross is set to 1. Else the standard lead time fields hold the gross times if no factoryAndShiftCalender is given or they hold the net times if the calender is defined.

•In the conformance checking data model:

oThe tables ActivityConformance and EdgeConformance are deleted.

oThe information ActivityConformance = Deviating / Correct Activity and the EdgeConformance likewise moved into the pa_activity_log-table.

oDue to the restructuring some fields became obsolete and have been deleted.

TEMPlate app

New

•New Layout with usability improvements:

oThe dashboards follow a new, UX-centered layout approach

oDashboards send a clear message and Tool-Sheets send a clear purpose

oEvery PPI is displayed with it's evolution over time

oEvery PPI is set into the process context

oEvery dashboard holds it's own RCA

oA period comparison is given for each PPI if configured so in the data editor with the variable Let mvShowPeriodComparison = true();

oA cost estimation is given for each analysis (where useful) if configured so in the data editor with the variable Let mvShowCostCalculation = true();

•New and easier Workflows:

oA MPM Toolbar allows every MPM analysis on every sheet

oThe Ad hoc lead time workflow is supported by a handy extension:

oThe Activity Details, Edge Details and Process Discovery Sheet can be switched to the ressource log perspective via button.

•New Sheets for higher information output:

oAutomation

oProcess Discovery (former Process Log Raw, Case Details, Process Discovery, Geo Analysis and Ressource Analysis)

oRework

oLead Time (former Time Analysis and Analysis of Custom Lead Times)

oOptimization Dashboard

•New PPIs for better process tracking:

oLead Time Dashboard:

▪% Late Cases

▪AVG/Median Time Late

▪Lead Time Spread

oAutomation Dashboard:

▪% No Touch Rate

▪% No Touch Lead Time

▪% Manual Effort

▪Cost Saving Potentials

oRework:

▪% Cases without Rework

▪% Rework Events

▪Time Lost by Rework

▪AVG in Rework in Cases

▪Cost Saving Potentials

oVariants:

▪ABC-analysis for variants

▪ABC-categorization for activities

▪% Cases with B-&C-Activities

▪Cost Saving Potential

oConformance:

▪% Perfect Conformance

▪% Unnecessary Steps

▪% Skipped Steps

▪Time Lost by unnecessary Steps

▪Cost Saving Potentials

oMonitoring:

▪# Open Late Cases

oActivity Details:

▪Added Lead Time by Activity

oEdge Details:

▪Added Lead Time by Edge

•You now have the option to get a single-language-Template App, derived from the Multilanguage App

•It is now possible to customize the theme colors including the colors in the icons, apply a custom theme to an application on a server, and learn helpful hints and tools

IMPROVEMENTS

•For usability improvement the following sheets have been changed:

oTarget Process Benchmarking & Comparison to Benchmarking

oProcess Monitoring to Monitoring

oProcess Variants and Activities to Variants

•The following sheet have been removed to reduce the app's complexity:

oAnalysis of Custom Lead Time

▪ now part of the new sheet Lead Time

oAnalysis Scope

▪Now moved to the MPM Toolbar

oApplication Performance Log

oGeo Analysis

▪Now part of the new sheet Process Discovery

oProcess Log Raw Data

▪The Log moved to the Additional Analysis on the sheet Process Discovery

oProcess Mining Dashboard -

▪Now part of the new sheet Process Discovery

oProcess Modeler and Deviation Analysis

oProcess Pattern Analysis

▪The QueryBuilder moved to the MPM Toolbar

oResource

▪The function is covered in the sheet Process Discovery

oRoot Cause Analysis -

▪The RCA is moved to the Additional Analysis of each related dashboard

oStrategic Dashboard YTD

▪Period comparison can be activated for every dashboard

oTactical Dashboard

▪Period comparison can be activated for every dashboard

oTime Analysis and Optimization

▪Now part of the new sheet Lead Time

•The following PPIs have been improved:

oProcess Homogenity:

▪Now caluclated with ln() function so the values are more linearly distributed between 0% and 100% for high numbers of variants and cases

oLead Time PPIs

▪The interval format now depends on the variable Set mvIntervalFormat = 'd hh:mm';  and does not contain if-statements any longer.

•The master item concept has been improved to find items faster and understand them better. Every master item holds a description in the app-default language

BPMN IMPORT WIZARD

NEW

•Add happy path manually in drag and drop window

•Manipulate existing happy paths in drag and drop window

•Add mapping load from app or qvd file

•Add filter dimensions for happy paths with case information data from app

•Support multi language BPMN files

•Allow BPMN files with multiple start and end activities

•Allow BPMN files with multiple processes

Imporvements

•Show activity names in happy path

MPM IMPORT WIZARD

new

•Add gui representation of new and changed template app variables

•Adapt table changes from template app

TEMPlate app & MPM Scripts

Fixes

•Automation Rate difference formatted as percentage points.

•Fixed several translation errors.

•Multilang app translates filters correctly.

•NetCaseLeadTime is calculated correctly for intervals smaller than one day.

IMPROVEMENTS

•Performance on app usage:

oUnused fields are dropped from the data model.

oKeys are auto numbered.

oFloating numbers are reduced to 4 digits.

oThe field UniqueCaseActivityRowNo was deleted.

oThe method mw_delete_variables is renamed to mw_clean_up and contains new functionalities e.g. autonumbering key fields (mw_delete_variables is still available).

oIn our tests the app size is reduced by 30%.

•Dataload performance improved: search-Index exclusion includes more fields.

BPMN IMPORT WIZARD

NEW

•Symbio-Integration (BPM Suite) - Extract HappyPaths for Conformance Checking from your Symbio Scenario:

oAdd new configuration for the data from symbio.

oLoad rest connections for symbio.

oLoad scenarios from symbio.

oLoad happy paths from symbio.

oFollow mapping and happy path configuration with symbio data.

improvements

•improved layout of hints for first step.

MPM IMPORT WIZARD

FIXes

•Fix handling of empty columns in csv-files.

improvements

•Improved layout.

•Re-Configure (change) existing MPM Apps (Conformance Checking, Root Cause Analysis, Custom Lead Times,...).

bPMN Modeler

IMPROVEMENT

•Saves the current selection in local storage.

•Updates view without apply selection in process analyzer.

•Hides edit palette by default and shows it with button in toolbar.

•Header bars

othat show which BPMN is shown (generated or imported).

oand the number of process variants and number of cases for the generated BPMN.

•Center viewport function and palette layout improved.

Process Analyzer

NEW

•MasterItems are now supported.

•Coloring option for nodes, edges and groups are added.

Fixes

•Happy Path variable.

•Multi-Language formatting.

•Patch 1: Update Properties and Set MultiLang Props (wrong field references fixed).

•Patch 1: The master items are reset to default values when the sheet is changed.

QUERY BUILDER

Fixes

•The non-reload on a tab change in the container object is fixed.

Process ACTIVITY FILTER

Fixes

•The non-reload on a tab change in the container object is fixed

•Patch 1: Better performance.

TEMPlate app & MPM Scripts

new

•New sheet: BPMN Modeler - Spare time in the creation of BPMN files by using the discovered process graph.

•New sheet: Tactical Dashboard

•Root Cause Analysis works for open processes as well. The new variable mvRCAForFinishedProcessOnly controls whether RCA is performed on all or closes processes only.

•New field ActivityStartDate & new table MasterCalendar_Events_$(mvProcessDesc) to improve Activity Start Date analysis. The call for the master calendar calculation has been adapted accordingly in the template app.

•The Process Monitoring, Root Cause Analysis, Conformance Checking, Resource Log and Custom Lead Time Analysis worksheets are hidden if they not do contain data.

•The conformance checking tab allows the possibility to select and deselect happy paths for the conformance checking.

Fixes

•Minor translation errors were fixed.

•Comparison Sheet: The automation rate has been corrected.

•Conformance Checking: Text box content is corrected.

•The factory and shift calender defines weekend-days by a variable mvWeekEndDays. Thus, when the dayname-abbreviation are changed to another language the definition of weekends can be adapted.

IMPROVEMENTS

•Sheet improvements:

oRoot Cause Analysis Sheet: structured newly.The "anomalies" have been renamed to "optimization potentials". The description of the optimization potentials have changed and thresholds for the long/short running cases/custom lead times and low process governance are now freely selectable.

oStrategic Dashboard: arrows added for the variance to indicate the KPI/PPI development & the integration with Template App is finished (I would like / find an answer is now available on the Analysis Scope)

oTarget Process Benchmarking: workflow optimization: The right part is again in the default state. Thus, the benchmark is automatically applied to the selection in the rest of the app.

oThe Ad hoc Lead Time Sheet now includes the option to calculate the lead times with the configuration min to min.

oThe sheet Application Performance analyzes the performance log by single modules and configuration type.

•KPI improvements:

oAdjustment of the automation rate: Unknown resource information on activities no longer leads to 0% but to null() as automation rate.

oPerformance optimization: measures use Real User/Real Node for faster counting were possible.

oAdaption of the formula for Process Homogeneity (5 cases with 5 process variants lead to same result as 50 cases with 50 process variants).

•Performance improvements:

oThe index exclusion was intensified.

oThe format fields from the tables CaseTimes and EventTimes were deleted from the data model.

oThe master items have been optimized. Events are now summed via RealNode, which saves a set expression.

oIn the default mode a reduced data model is now loaded. The EventTimes table, and the ProcessPathWithLoops, nextActivityType, nextActivityID, nextActivityTimestamp, previousActivityType, previousActivityTypeID and previousActivityTomestamp are only loaded if the new variable mvLoadLargeDataModel is set to 1.

oNew option to load Timestamps without seconds and, thus, reduce data volume.

oMore fields are excluded in the index creation.

•Chart improvements:

oColoring in Dimension Analysis chart (Sheet Analysis of Custom Lead Time).

oAdjust graph - KPI1 & KPI2 by dimension - put both metrics on one axis (Ad Hoc Lead Time Analysis).

oDelete subheading for more space in the analysis (Process Mining Sheet, Process Variants and Activities Sheet).

oAdd alternative dimension (Process Mining Sheet).

oMonth Year and Date as alternative dimensions for the Lead Time Evolution Diagram (Process  Mining Dashboard.

oThe dimension user pattern is now precalculated in the script. Therefore, it is now available in the front end.

•The dimension table for the RCA can be changed via a central variable, Thus, typical user errors are prevented.

•Improved error messages for missing MPM scripts.

•Unused variables and master visualizations are deleted.

•The RCA is performed for all cases in default - not only closed cases. To load it for closed cases only the variable mvRCAForFinishedProcessOnly is set to 1.

•The conformance checking tab is reduced, the tables HappyPathTable and HappyPathDescription are merged.

BPMN IMPORT WIZARD

NEW

•The BPMN Import-Wizard supports the upload of BPMN files to MPM Template Apps without the need to do the scripting by yourself.

•The workflow of the BPMN Import-Wizard is self-explaining and documented step-by-step in the Wizard.

•For an installation guide see Install BPMN Import.

•For a user guide see Use the BPMN Import Wizard.

FIXES

•Patch 1: BPMN models with AND-gateway generate happy paths with OR-gateways

•Patch 1: MPM-start and MPM-end activities are ignored in the mapping.

•Patch 1: Wizard only filters apps from workspace for editing

Improvements

•Patch 1: The mapping workflow is simplified.

•Patch 1: BPMN-start & end-events are excluded from the mapping in default.

•Patch 1: BPMN-events are added as activities.

•Patch 1: Non-mapped BPMN activites are added to the AL_Activity list.

MPM IMPORT WIZARD

NEW

•Root Cause Analysis:  new configuration parameters.

FIxes

•Patch 1: App link for multi-node environment .

improvements

•Improved message output.

•Improved status management.

NEW EXTENSION: MPM bPMN Modeler

NEW

•Creates a BPMN from the process shown in the MPM ProcessAnalyzer

•The BPMN will be shown in the BPMN view with toolbar

•The BPMN view can also show the imported BPMN file from the conformance checking module

•The BPMN layout is created automatically or can be adapted and enhanced manually

•Export as SVG or BPMN File

•See more

Process Analyzer

Fixes

•Enable Rendering Text Message is shown correctly

Process Variants INspector

Fixes

•Snapshot functionality added

new

•Strategic dashboard YTD Sheet

oNew sheet to get an overview about the trends of the overall process performance.

•Analysis Scope Sheet

oProvides new guided analytics functionalities with a sheet and KPI/PPI overview.

•Times Analysis Sheet

oNew combo chart ( Lead Time & # Cases by User Pattern).

•Performance logging of the Template App

oPerformance logging can now be enabled with the new data connection mvLogApplicationPerformance.

oUse the new data connection mvDir_logs to save the qvd.

oA new sheet Application Performance Log Sheet visualizes the detailed script log for current and past data loads to analyze data load errors and script performance.

•ETL-Apps

oThe 03-process log app allows in the eventSource creation to keep fields apart from the mandatory fields in the in the eventSource. Thus, for the calculation of finished processes or the data model creation new opportunities come up.

•Template App data editor and MPM-scripts:

oMasterCalendar defines YTD / FYTD / MTD flag for maximum date or current date, depending on variable's mvTimeRange value.

oMasterCalendar defines FiscalYear based on a template app variable mvCalendarFM.

oMPM algorithms are now logged on demand by setting the variable mvLogApplicationPerformance and a new data connection mvDir_logs.

oThe table EventCalendar is now loaded optionally, thus, when not loaded the factory and shift calendar module is more performant. Therefore, a new variable let mvCalculateEventCalender was created.

oFor better debugging and error descriptions the MPM scripts are now tagged with a release-variable.

oBefore each "script area" a reference (URL) to the relevant part in the MPM help is given.

oThe EventLog-load script provides a template for a "ReworkEvent"-Flag.

Fixes

•Template App data editor and MPM-scripts:

oConformance checking for related dimensions now creates a unique key between related dimensions and the process variant.

oThe call of the MPM data model in use with the ETL-apps is corrected to match the default data connection.

•ETL-Apps

oCustom lead times, grouping and edge tables are stored as MPM data model output.

•Activity Details Sheet

oThe #Cases is now correctly displayed in the KPI-object when a subselection is given and the button "go to process variants sheet with selection" selects the cases correctly.

•Master Items and Translations:

oIn the ongoing LeadTime the set expression is corrected to ProcessFinished=0.

oThe translations for the guided analytics functionality were corrected in the Analysis Scope Sheet.

oThe duplicated master item “Lead Time Monitoring" was deleted.

•Process Monitoring Sheet

oDisplay error/translation error (Mulitlanguage app).

IMPROVEMENTS

•Template App data editor & MPM-scripts

oStorytelling snapshots and old variables with the format mvCaseDimensionXXXX, mvEventDimensionXXXX and mvGeofieldXXXX were deleted.

oThe time measures are now formatted as dynamic or fixed time format according to the new variable mvLeadTimeFormat .

oImproved design of the sheet Target Process Benchmarking

oThe master item repository name can be given to the method-call as optional parameter

•Process Variants and Activities sheet:

oAVG Case Waiting Time replaced with Activity Waiting time

•Analysis of Custom Lead Time sheet: Custom Lead Time KPI formatted correctly

•MPM Theme: color for second KPI changed from blue to gold, thus, differentiation between two measures becomes easier

New

•Add new import-format: XES. MEHRWERK got the XES certification by the IEEE Task Force in early 2021 for MPM.

•Add custom langauge selector for mulitlanguage apps EN/DE

•Add new config dialog: Shift calendar

•Add additional features to RCA config dialog

•Add qlik-proxy-support

Fixes

•Usage of data connection-variable in qlik script

•Stability on master items - generation

•Handling of slightly wrong csv-data-syntax

improvements

•Update to Angular 11 LTS

•Changed app to single - path - mode for use in content-library

•Change grouping config dialog to new look&feel and drag&drop -enhancements

Process Variants INspector

FIXES

•Wrong error message when license expired

•License error in snapshot mode / printing

Process Activity filter

IMPROVEMENTS

•Performance during selection of activities optimized

FIXES

•Wrong error message when license expired

•License error in snapshot mode / printing

Process Analyzer

new

•Edges of grouping folders have measures (incl. aggr, format type and format of measure) - see how to configure them in ProcessAnalyzer Properties

•Improved layouting of grouping

Fixes

•Wrong error message when license expired

•License error in snapshot mode / printing

•Patch 1: access denied in published sheets (if grouping activated)

•Patch 1: incorrect rendering of group nodes at page refresh

•Patch 1: incorrect edge labels for artifical edges if grouping is activated

Process Modeler

Fixes

•Wrong error message when license expired

•License error in snapshot mode / printing

Query Builder

Fixes

•Wrong error message when license expired

•License error in snapshot mode / printing

New

•Sheet Process Variants and Activities

oNew chart to analyze the number of cases by activitiy frequency classes.

•Sheet Conformance Checking

oThe whole process model is shown on the analyzer, therefore the bar chart "Cases per Happy Path" was changed and a button was added to select cases that belong to a certain happy path.

•New KPI

oAVG Workdays (not used in front-end but available as master item) which is calculated by the factory and shift calender and indicates the number of workdays that a case needed from start to end.

Improvements

•Sheet Resource

oSheet name changed to Resource Analysis

•BPMN import mapping table

oTwo new columns: excludeBPMNActivity and map are used to decide if activities from the BPMN model exist in MPM and shall or shall not be shown (with a mapped name or with their BPMN-name).

•Template App data editor and MPM-scripts

oDelta load checks if initial load is existing and triggers an initial load if not.

oAll tabs are activated for the Import Wizard, therefore, all inline tables were emptied.

oVariables to configure 1A. Resource Log were reduced to only one (mvProcessDescriptionResource).

oLogic of variable mvProcessFinished to configure 2A. Advanced Customization optimized (defined via set not let, thus, chr(39) is not longer needed).

oConformance Checking keeps empty happy paths and creates a standalone happy path table for the process model

oFunction name mw_createIDs was changed to mw_createActivityTypeID

oTranslation and master item creation methods optimized: MW_createMasterItems/ MW_createMasterItems_EN &  MW_concatenateMasterItems/ MW_concatenateMasterItems_EN function names were changed to MW_concatenateMasterItemsFromRepository  and MW_createMasterItemsFromInlineTable. Backwards compatibility is assured.

oVariable mvDoValueStreamMapping was deleted. Value Stream Mapping moved from the MPM Template App to the MPM Business Content.

oThe table HappyPathDescription is renamed to HappyPathDescription_$(mvProcessDescription).

oPatch 1: variables for filter-field names corrected in the method "MW_createMasterItemsFromInlineTable"

FixeS

•Sheet Resource

oField Process Path was corrected.

•Template App data editor & MPM-scripts

oCustom Lead Times: MinMaxStartActivtiy renamed to MinMaxStartActivity. Backwards compatibility is assured.

oRCA anomaly “happy  path fitness below 80%” moved to CaseTimes-table and is now called via CaseID. Backwards compatibility is not assured, please adapt older template app script when using Feb2021 mpm-scripts..

oMW_qualifyLog and MW_qualifyLogAndCaseID qualifies also EL_EdgeTypes

New

•Config dialog for root cause analysis

•Config dialog for grouping

•Config dialog for conformance checking

See the new configuration steps in the recently added documentation: Use the Import Wizard

Fixes

•Display of ts-icon on mapping of columns

•Script-replacement adapted to empty inline tables

improvements

•Generation of mvProcessFinished in init-part according to the MPM Template App improvement