QPR ProcessAnalyzer Wiki: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
 
(82 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div class="downloadButton" style="width:240px;float:right;margin: 3px 12px 0px 15px;">[[QPR_ProcessAnalyzer_Downloads|Download<br />QPR ProcessAnalyzer]]</div>
<div class="downloadButton" style="width:240px;float:right;margin: 3px 12px 0px 15px;">[[QPR_ProcessAnalyzer_Downloads|Download<br />QPR ProcessAnalyzer]]</div>


Welcome to QPR ProcessAnalyzer Wiki! QPR ProcessAnalyzer is your tool for turning event and transactional data into visual process intelligence. Topics in this documentation are divided based on user roles: process analysts, developers and administrators. For an introduction, read [[Getting Started with QPR ProcessAnalyzer|Getting Started]] and [[Introduction to QPR ProcessAnalyzer]] sections.
Welcome to QPR ProcessAnalyzer Wiki! QPR ProcessAnalyzer is a software for turning event and transactional data into visual process analysis and intelligence. Topics in this documentation are divided based on user roles for process analysts, developers and administrators.


<div style="height:5px;"></div>
<div style="height:5px;"></div>
== For Process Analysts ==
== For Process Analysts ==
QPR ProcessAnalyzer is used via web browser. In QPR ProcessAnalyzer application you can perform various analyses on your process model.
This section contains information how to get started with QPR ProcessAnalyzer and how to create your first dashboards! This section also describes how to use filters and how to make different kinds of analyses with QPR ProcessAnalyzer.


<div style="display: flex;flex-wrap: wrap;">
<div style="display: flex;flex-wrap: wrap;">
<div style="flex: 1 0 210px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
<div style="flex: 1 0 210px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
=== Introduction and General ===
=== Getting Started ===
* [[Getting Started with QPR ProcessAnalyzer]]
* [[Getting Started with QPR ProcessAnalyzer]]
* [[Introduction to QPR ProcessAnalyzer|QPR ProcessAnalyzer Core Capabilities]]
* [[Introduction to Process Mining|Introduction to Process Mining]]
* [[Process_Mining_Concepts|Process Mining Concepts]]
* [[Process_Mining_Concepts|Process Mining Concepts]]
* [[Languages and Localization|Language and Localization Settings]]
* [[Languages and Localization|Language and Localization Settings]]
* [[Navigation_Menu|Navigation Menu Functions]]
* [[Online_Learning_Platform|Online Learning Platform]]
* [[QPR TaskRecorder]]
* [[QPR TaskRecorder]]
* [[Online_Learning_Platform|Online Learning Platform]]
</div>
</div>


Line 21: Line 22:


=== Working with Dashboards ===
=== Working with Dashboards ===
* [[Navigation_Menu|Navigation Menu Functions]]
* [[QPR_ProcessAnalyzer_Project_Workspace|Project Workspace]]: [[QPR_ProcessAnalyzer_Project_Workspace#Projects|Projects]], [[QPR_ProcessAnalyzer_Project_Workspace#Dashboards|Dashboards]], [[QPR_ProcessAnalyzer_Project_Workspace#Models|Models]], [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|Datatables]], [[Managing_Scripts|Scripts]], [[QPR_ProcessAnalyzer_Project_Workspace#Recycle_Bin|Recycle Bin]]
* [[QPR_ProcessAnalyzer_Project_Workspace|Project Workspace]]: [[QPR_ProcessAnalyzer_Project_Workspace#Projects|Projects]], [[QPR_ProcessAnalyzer_Project_Workspace#Dashboards|Dashboards]], [[QPR_ProcessAnalyzer_Project_Workspace#Models|Models]], [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|Datatables]], [[Managing_Scripts|Scripts]], [[QPR_ProcessAnalyzer_Project_Workspace#Recycle_Bin|Recycle Bin]]
* [[Filtering_in_QPR_ProcessAnalyzer|Using Filters]]
* [[Filtering_in_QPR_ProcessAnalyzer|Using Filters]]
* [[QPR ProcessAnalyzer Dashboard Designer|Creating Dashboards]]
* [[QPR ProcessAnalyzer Dashboard Designer|Creating Dashboards]]
* [[Business Calendar|Business Calendar for Duration Calculation]]
* [[Dashboard Variables|Dynamic Variables in Dashboards]]
* [[Dashboard Variables|Dynamic Variables in Dashboards]]
* [[Business Calendar|Business Calendar to Calculate Durations]]
* [[Best Practices for Designing Dashboards|Best Practices for Designing Dashboards]]
* [[Best Practices for Designing Dashboards|Best Practices for Designing Dashboards]]
</div>
</div>
Line 34: Line 34:
=== Analyses and Visualizations ===
=== Analyses and Visualizations ===
<div style="float:left; width:50%;">
<div style="float:left; width:50%;">
* [[Process Flowchart|Process Flowchart]]
* [[QPR ProcessAnalyzer Chart|Chart]] / [[Big Data Chart|Big Data Chart]]
* [[QPR ProcessAnalyzer Chart|Chart]] / [[Big Data Chart|Big Data Chart]]
** [[QPR ProcessAnalyzer Graphs|Graphical Charts]]
** [[QPR ProcessAnalyzer Graphs|Graphs]]
** [[QPR_ProcessAnalyzer_Table|Table]]
** [[QPR_ProcessAnalyzer_Table|Table]]
** [[QPR_ProcessAnalyzer_Pivot_Table|Pivot Table]]
** [[QPR_ProcessAnalyzer_Pivot_Table|Pivot Table]]
Line 42: Line 43:
** [[Chart_On-screen_Settings|On-screen Settings]]
** [[Chart_On-screen_Settings|On-screen Settings]]
** [[Chart_Linked_Settings|Linked Settings]]
** [[Chart_Linked_Settings|Linked Settings]]
** [[Actions_to_Run_Script_in_Table|Run Script Actions]]
</div>
</div>
<div style="float:left; width:50%;">
<div style="float:left; width:50%;">
* [[Process Flowchart|Process Flowchart]]
* [[Root Causes|Root Causes Analysis]]
* [[Clustering Analysis|Clustering Analysis]]
* [[Conformance Analysis|Conformance Analysis]]
* [[Design Diagram|Design Diagram]] / [[QPR ProcessAnalyzer BPMN Editor|BPMN Editor]]
* [[Gantt_Chart|Gantt Chart]]
* [[Sankey_Chart|Sankey Chart]]
* [[Label and Link]]
* [[Label and Link]]
* [[Image|Image]]
* [[Image|Image]]
* [[Root Causes|Root Causes Analysis]]
* [[Filter_Selectors|Filter Selectors]] / [[Dropdown_List_Selector|Dropdown List Selector]]
* [[Conformance Analysis|Conformance Analysis]]
* [[QPR ProcessAnalyzer BPMN Editor|BPMN Editor]]
* [[Clustering Analysis|Clustering Analysis]]
* [[Dropdown_List_Selector|Dropdown List Selector]]
</div>
</div>
</div>
</div>
Line 57: Line 60:
</div>
</div>


== For Developers ==
== For Citizen Developers ==
To build QPR ProcessAnalyzer models, you need to extract data from source systems, transform it to an eventlog format and finally load to process models. To perform these tasks, you can use the ETL scripting platform that is part of QPR ProcessAnalyzer. When the model is created, users can start analyzing and create dashboards.
This section describes how to build ETL scripts that transform the source data into process mining models. There is also a detailed description how the process mining models can be configured so that they are optimal for the desired analyses. Finally, there is reference documentation for all expression language related functionality, that can be used both when writing custom KPI's in dashboards and in the ETL scripts.


<div style="display: flex;flex-wrap: wrap;">
<div style="display: flex;flex-wrap: wrap;">
<div style="flex: 1 0 370px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
<div style="flex: 1 0 370px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
=== KPI Expression Language ===
=== Expression Language Reference ===
* [[QPR_ProcessAnalyzer_Expressions|Basic Syntax and Operations]] / [[Generic Functions in QPR ProcessAnalyzer|Generic Functions]]
* [[SQL_Expressions|SQL Expressions for Snowflake]]
* In-memory expressions: [[QPR_ProcessAnalyzer_Expressions|Basic Syntax and Operations]] / [[Generic Functions in QPR ProcessAnalyzer|Generic Functions]]
* [[Generic_Objects_in_Expression_Language|Generic types]] ([[Generic_Properties_in_Expression_Language|Generic Properties]], [[Generic_Objects_in_Expression_Language#Array|Array]], [[Generic_Objects_in_Expression_Language#DateTime|DateTime]], [[Generic_Objects_in_Expression_Language#String|String]], [[Generic_Objects_in_Expression_Language#Timespan|Timespan]],  [[Generic_Objects_in_Expression_Language#Dictionary|Dictionary]])
* [[Process_Mining_Objects_in_Expression_Language|In-memory models API]] ([[Process_Mining_Objects_in_Expression_Language#AttributeType|AttributeType]], [[Process_Mining_Objects_in_Expression_Language#Case|Case]], [[Process_Mining_Objects_in_Expression_Language#Event|Event]], [[Process_Mining_Objects_in_Expression_Language#EventLog|EventLog]], [[Process_Mining_Objects_in_Expression_Language#EventType|EventType]], [[Process_Mining_Objects_in_Expression_Language#Flow|Flow]], [[Process_Mining_Objects_in_Expression_Language#FlowOccurrence|FlowOccurrence]], [[Process_Mining_Objects_in_Expression_Language#Variation|Variation]])
* [[Process_Mining_Objects_in_Expression_Language|In-memory models API]] ([[Process_Mining_Objects_in_Expression_Language#AttributeType|AttributeType]], [[Process_Mining_Objects_in_Expression_Language#Case|Case]], [[Process_Mining_Objects_in_Expression_Language#Event|Event]], [[Process_Mining_Objects_in_Expression_Language#EventLog|EventLog]], [[Process_Mining_Objects_in_Expression_Language#EventType|EventType]], [[Process_Mining_Objects_in_Expression_Language#Flow|Flow]], [[Process_Mining_Objects_in_Expression_Language#FlowOccurrence|FlowOccurrence]], [[Process_Mining_Objects_in_Expression_Language#Variation|Variation]])
* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language|System objects]] ([[Datatable_in_Expression_Language|Datatable]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model|Model]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project|Project]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Script|Script]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|User/Group]])
* Configuration objects ([[Dashboard_in_Expression_Language|Dashboard]], [[Datatable_in_Expression_Language|Datatable]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model|Model]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Filter]], [[Diagram_in_Expression_Language|Diagram]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Script|Script]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project|Project]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|User/Group]])
* [[Generic_Objects_in_Expression_Language|Generic types]] ([[Generic_Properties_in_Expression_Language|Generic Properties]], [[Generic_Objects_in_Expression_Language#Array|Array]], [[Generic_Objects_in_Expression_Language#DateTime|DateTime]], [[Generic_Objects_in_Expression_Language#String|String]], [[Generic_Objects_in_Expression_Language#Timespan|Timespan]],  [[Generic_Objects_in_Expression_Language#Dictionary|Dictionary]])
* Tabular data ([[DataFrame in Expression Language|DataFrame]], [[SqlDataFrame in Expression Language|SqlDataFrame]],  [[DataFlow_in_Expression_Language|DataFlow]])
* Tabular data types ([[DataFrame in Expression Language|DataFrame]], [[SqlDataFrame in Expression Language|SqlDataFrame]],  [[DataFlow_in_Expression_Language|DataFlow]])
* [[SQL_Expressions|SQL Expressions for Big Data Chart]]
* [[Machine_Learning_Functions_in_Expression_Language|Machine Learning API]] / [[Conformance_Checking|Conformance Checking]]
* [[Machine_Learning_Functions_in_Expression_Language|Machine Learning API]] / [[Conformance_Checking|Conformance Checking]]
* [[Filtering_in_QPR_ProcessAnalyzer_Queries|Filtering Model Data]]
* [[Filtering_in_QPR_ProcessAnalyzer_Queries|Filter Rules JSON]]
</div>
</div>


<div style="flex: 1 0 250px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
<div style="flex: 1 0 250px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">


=== Manage Data Models ===
=== Create Process Mining Models ===
* [[Creating Process Mining Model|Creating Process Mining Model]]
* [[Creating Process Mining Model|Walkthrough: Creating Process Mining Model]]
* [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|Exporting and Importing Data]]
* [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|Importing Data from CSV, XES and PACM files]]
* [[Calculated Attributes in QPR ProcessAnalyzer|Calculated Case and Event Attributes]]
* [[Email Notifications|Email Notifications]]
* [[Email Notifications|Email Notifications]]
* [[Calculated Attributes in QPR ProcessAnalyzer|Calculated Case and Event Attributes]]
* [[QPR ProcessAnalyzer Model Datasources|Model datasources]] ([[QPR ProcessAnalyzer Model Datasources#Loading Data from Datatables|Datatable]], [[QPR ProcessAnalyzer Model Datasources#Loading Script|Loading Script]], [[QPR ProcessAnalyzer Model Datasources#ODBC_Datasource|ODBC]])
* [[QPR ProcessAnalyzer Model Datasources|Model datasources]] ([[QPR ProcessAnalyzer Model Datasources#Loading Data from Datatables|Datatable]], [[QPR ProcessAnalyzer Model Datasources#Loading Script|Loading Script]], [[QPR ProcessAnalyzer Model Datasources#ODBC_Datasource|ODBC]])
* [[Case Level Permissions|Case Level Permissions]]
* [[Automatic Model Loading on Server Startup|Keeping Models Always Available]]
* [[Automatic Model Loading on Server Startup|Keeping Models Always Available]]
* [[Case Level Permissions|Case Level Permissions]]
* [[Event Ordering for Identical Timestamps|Event Ordering for Identical Timestamps]]
* [[Event Ordering for Identical Timestamps|Event Ordering for Identical Timestamps]]
* [[Managing Time Zones and Local Time|Time Zones and Local Time]]
* [[Managing Time Zones and Local Time|Time Zones and Local Time]]
* [[Anonymize data|Anonymize data]]
* [[Best_Practices_for_Designing_Models|Best Practices for Designing Models]]
* [[Best_Practices_for_Designing_Models|Best Practices for Designing Models]]
* [[Create_Predicted_Eventlog|Create Predicted Eventlog]]
</div>
</div>


<div style="flex: 1 0 250px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
<div style="flex: 1 0 250px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">


=== Data Integrations and API's ===
=== Data Integrations and Connectors ===
* [[Managing Scripts|Managing Scripts]]
* [[Managing Scripts|Managing Scripts in Workspace]]
* [[Running_and_Calling_Scripts|Running and Calling Scripts]]
* [[Datatable_Properties_Dialog|Managing Datatables in Workspace]]
* [[SQL Scripting for ETL|SQL Scripting]]
* [[SQL Scripting for ETL|Writing SQL Scripts]]
* [[SQL Scripting Commands|SQL Scripting Commands]]
* [[SQL Scripting Commands|SQL Scripting Commands Reference]]
* [[Storing Secrets for Scripts|Storing Secrets]]
* [[QPR ProcessAnalyzer ScriptLauncher|Installing and using QPR ScriptLauncher]]
* [[Importing_Data_from_SAP|How to Import Data from SAP]]
* [[Anonymize data|Anonymize data]]
* [[Expression Script Examples|Expression Script Examples]]
* [[Expression Script Examples|Expression Script Examples]]
* [[Secure_Strings|Secure Strings]]
* [[QPR ProcessAnalyzer API|QPR ProcessAnalyzer REST API]]
* [[QPR ProcessAnalyzer ScriptLauncher|QPR ProcessAnalyzer ScriptLauncher]]
* [[QPR ProcessAnalyzer API|QPR ProcessAnalyzer API]]
* [[Sample Eventlog Files|Sample Eventlogs]]
* [[Sample Eventlog Files|Sample Eventlogs]]
</div>
</div>
Line 105: Line 110:


== For System Administrators ==
== For System Administrators ==
QPR ProcessAnalyzer requires installing QPR ProcessAnalyzer Server hosted in IIS and two SQL Server databases. All functionality is available in the web UI, which don't require any installations. If there is a need to access on-premise source systems to extract eventlog data, QPR ProcessAnalyzer ScriptLauncher needs to be installed.
This section starts with the planning of QPR ProcessAnalyzer installation. After all requirements have been fulfilled, you can continue with the installation and configuration of QPR ProcessAnalyzer. Finally, learn how to manage users and perform other administrative tasks.


<div style="display: flex;flex-wrap: wrap;">
<div style="display: flex;flex-wrap: wrap;">
Line 111: Line 116:
=== Planning Installation ===
=== Planning Installation ===
* [[QPR ProcessAnalyzer System Requirements|System Requirements]]
* [[QPR ProcessAnalyzer System Requirements|System Requirements]]
* [[QPR ProcessAnalyzer System Architecture|System Architecture]]
* [[User Session Management|User Session Management]]
* [[QPR ProcessAnalyzer Release Notes|QPR ProcessAnalyzer Release Notes]]
* [[QPR ProcessAnalyzer Release Notes|QPR ProcessAnalyzer Release Notes]]
* [[QPR_TaskRecorder_Release_Notes|QPR TaskRecorder Release Notes]]
* [[QPR_TaskRecorder_Release_Notes|QPR TaskRecorder Release Notes]]
* [[QPR ProcessAnalyzer System Architecture|System Architecture]]
* [[User Session Management|User Session Management]]
* [[QPR_ProcessAnalyzer_Version_Compatibility|Compatibility between Releases]]
</div>
</div>


Line 122: Line 126:
=== Installing and Configuring ===
=== Installing and Configuring ===
* [[Installing QPR ProcessAnalyzer Server|Install QPR ProcessAnalyzer Server]] (or [[Updating_QPR_ProcessAnalyzer_Server|update existing]])
* [[Installing QPR ProcessAnalyzer Server|Install QPR ProcessAnalyzer Server]] (or [[Updating_QPR_ProcessAnalyzer_Server|update existing]])
* [[QPR_ProcessAnalyzer_ScriptLauncher|Install QPR ProcessAnalyzer ScriptLauncher]]
* [[Snowflake_Connection_Configuration|Configure Snowflake Connection]]
* [[Setting_up_Scripting_Sandbox|Setting up SQL Scripting Sandbox]]
* [[SAML_2.0_Federated_Authentication|SAML 2.0 Authentication]]
* [[QPR ProcessAnalyzer Security Hardening|Security Hardening]]
* [[QPR ProcessAnalyzer Security Hardening|Security Hardening]]
* [[SAML_2.0_Federated_Authentication|SAML 2.0 Authentication]]
* [[Activate_QPR_ProcessAnalyzer_using_ActivationUtility|Activation without Internet Connection]]
* [[Snowflake_Connection_Configuration|Snowflake Configuration]]
* [[Activate_QPR_ProcessAnalyzer_using_ActivationUtility|Manual Activation]]
</div>
</div>


Line 132: Line 136:


=== Administrating System ===
=== Administrating System ===
* [[Roles and Permissions|Roles and Permissions]]
* [[Roles and Permissions|User Permissions General Information]]
* [[Manage Users and Groups|Manage Users and Groups]]
* [[Manage Users and Groups|Manage Users dialog]]
* [[PA_Configuration_database_table|Configuration Table in Database]]
* [[PA_Configuration_database_table|Configuration Table in Database]]
* [[QPR ProcessAnalyzer Logs|Logs in QPR ProcessAnalyzer]]
* [[QPR ProcessAnalyzer Logs|Logs for Audit Trail and Troubleshooting]]
* [[Memory Management Settings|Memory Management Settings]]
* [[Memory Management Settings|Memory Management Settings]]
</div>
</div>

Latest revision as of 07:50, 27 February 2024

Welcome to QPR ProcessAnalyzer Wiki! QPR ProcessAnalyzer is a software for turning event and transactional data into visual process analysis and intelligence. Topics in this documentation are divided based on user roles for process analysts, developers and administrators.

For Process Analysts

This section contains information how to get started with QPR ProcessAnalyzer and how to create your first dashboards! This section also describes how to use filters and how to make different kinds of analyses with QPR ProcessAnalyzer.

For Citizen Developers

This section describes how to build ETL scripts that transform the source data into process mining models. There is also a detailed description how the process mining models can be configured so that they are optimal for the desired analyses. Finally, there is reference documentation for all expression language related functionality, that can be used both when writing custom KPI's in dashboards and in the ETL scripts.

For System Administrators

This section starts with the planning of QPR ProcessAnalyzer installation. After all requirements have been fulfilled, you can continue with the installation and configuration of QPR ProcessAnalyzer. Finally, learn how to manage users and perform other administrative tasks.

Agreements

See the QPR End User Software License Agreement and QPR Software as a Service Agreement.