QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
 
Line 1: Line 1:
This page contains new features and fixed issues for each QPR ProcessAnalyzer release. For information on the compatibility of different versions, see [[QPR ProcessAnalyzer Version Compatibility|Version Compatibility Information]].
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.


== Next Release: QPR ProcessAnalyzer 2020.7 (planned release date 2020-09-29) ==  
== Next Release: QPR ProcessAnalyzer 2025.2 (planned release 2025-03-04) ==
Build number: 2020.7.0.xxxxx, Model compatibility version: x, Database version: xx, PACM file version: x, Protocol version: xx.


'''Notes:'''
[[Next_Release_Content|See plan for next release features and fixes]]
* [[QPR_ProcessAnalyzer_Version_Compatibility|Excel Client protocol version]] will be changed in QPR ProcessAnalyzer 2020.7 which requires to update Excel Client when updating to QPR ProcessAnalyzer 2020.7. (See more how to [[Installing_QPR_ProcessAnalyzer_Excel_Client#Installing_QPR_ProcessAnalyzer_Excel_Client|update Excel Client]])
* The legacy process mining models are not supported anymore, and they need to be migrated manually to new models before updating to QPR ProcessAnalyzer 2020.7. The new models use datatables to store events and cases. You can check the model type as follows: Open QPR ProcessAnalyzer Web UI, open the models dropdown list in the header, find a model, open ''Properties'' for the model, and go to the ''Datasources'' tab. If the ''Load from Database'' is ''yes'', the model is a legacy model and requires a migration. The migration can be done by exporting the model as a .pacm file (in the ''Actions'' tab from model properties), and importing the file back using the ''Import Data'' functionality. It's also recommended to delete the legacy models. The eventlog data for the legacy models is not yet removed in QPR ProcessAnalyzer 2020.7 and thus it's possible to rollback to QPR ProcessAnalyzer 2020.6 if needed. The eventlog data for the legacy models will be removed in a future release to save space in the database.


'''Features:'''
== Latest Release: QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23) ==
* 307987: Navigation menu width is set based on dashboard names.
* 307996: Translation fixes.
* 307954: Web API for datatables.
 
'''Fixed issues:'''
* 219465: Case/event attribute not found error messages not user friendly.


== Latest release: QPR ProcessAnalyzer 2020.6 (release date 2020-08-18) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
Build number: 2020.6.0.42152, Model compatibility version: 3, Database version: 74, PACM file version: 7, Protocol version: 33.


'''Features:'''
===New features===
* 307918: Localization for Russian, Spanish, German, Finnish and Swedish.
* B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
* 307921: New dashboard Preview mode is separated from the Edit mode, to be able to temporarily change chart settings without saving them to the dashboard.  
* B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
* 307982: Changes to showing model last imported date and additional information to Model Properties dialog.
* B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
* 307983: Editing calculated case and event attributes.
* B-08439: Added project settings [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Database_and_Schema|DatabaseNameInDataSource and SchemaNameInDataSource]] to define Snowflake database and schema.
* 307980: Chart setting "On-screen Settings Follow Flow Selection" to freeze chart from reacting to flow selection.
* B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
* 307824: Expression language function improvements (IndexOf, LastIndexOf, ToString, ParseDateTime, First, Last).
* B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].
* 307952: When loading model data, the order of events inside cases is primarily based on the timestamp and secondarily by event row number.
* 307953: Querying model-datatable linking in expression language.
* 307817: User management operations to Web API.
* 307900: Memory consumption improvement for getting number of unique attribute values.
* 307978: Performance improvement: Taken into use AttributeType.UniqueCount to replace Count(_.Values) in expression used by UI.
* 307781: ProjectId property is removed from dashboard export files.
* 307955: Dataframes are loaded in parallel.
* 307934: AsParallel function implementation has been finalized.


'''Fixed issues:'''
===Fixed issues===
* 219388: Old data comes to dashboard when data imported to datatable.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* 219412: No scrollbar for both error message and web UI window.
* D-14323: Filtering with "Split data by filtering" dimension didn't work with exclude type of filter rules and when there were multiple filter rules.
* 219414: Error message appears in Clustering Analysis for model with zero events and cases.
* D-14346: Fixed issue where manual activation using activation utility didn't work.
* 219419: QueryIdentifier should be excluded from client side query cache.
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* 219426: Script editor cannot save changes in 2020.5 version.
* D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* 219430: Filtering does not work in PAPO Cases and Event Types when using French.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
* 219431: PAPO Events and Root Causes not working when using French.
* D-14331: Flowchart lost selection when flowchart used linked variables with array values.
* 219435: Dialogues have small layout issue.
* D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
* 219441: Deletion does not work correctly in folders screen when selecting using shift+ctrl-click.
* D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
* 219160: Hidden case attributes are visible in profiling case analysis, and in Influence Analysis for case attributes settings.
* D-14342: Flow step and Zoom settings control have same size and layout is aligned.
* 219418: Missing translations for the Clustering analysis.
* D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
* 219446: JavaScript error when closing dialog using the X button.
* D-14327: AI Assistant had console error when pressing send button without text.
* 219444: Deselecting selected item by re-clicking it will not hide the selection buttons in Chart and generates an error in browser console
* D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
* 219449: Prediction fails with certain small models.
* D-14321: Added error message for AI Assistant when trying to use it without model selected.
* 219450: Evaluation stack is not generated correctly if an exception occurs while inside a function having no parameters.
* 219456: Query cache is not cleared when model settings are changed.


== QPR ProcessAnalyzer 2020.5 (release date 2020-06-29) ==  
===Other improvements===
Build number: 2020.5.0.41888, Model compatibility version: 3, Database version: 73, PACM file version: 7, Protocol version: 33.
* B-08391: Datatable access has been optimized improving performance for object-centric models.
* B-08529: Added support for array type in stringified value format.
* B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
* B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
* B-08544: Frontend components have been updated.
* B-08561: Updated translations for release 2025.1.


'''Notes:'''
== Release: QPR ProcessAnalyzer 2024.8 (build 8937) (released 2024-12-11) ==
* Dashboards structure is simplified, as panels are removed and presentation objects are placed directly to the dashboard canvas. In addition, panel headers are not available anymore. Presentation objects have now background color, border color, border width and border corner radius, that were previously in the panel level. All existing dashboards are automatically migrated to the newer structure. Existing dashboards that have several presentation objects within a same panel, are positioned on top of the others, so in those cases presentation objects need to be repositioned manually after updating to QPR ProcessAnalyzer 2020.5.
* IP address verification of user sessions has been removed. Previously, each user session was only allowed from the same IP address. This kind of security feature won't work with IPv6 addresses which usually change more often than IPv4 addresses.


'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307938: Support for French language.
Known issue: There may be old invalid models which don't work with QPR ProcessAnalyzer 2024.8. The following query can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] (with System administrator user) to list such models:
* 307868: New dashboard designer that doesn't have panels.
<pre>
* 307947: [[Tables Conditional Formatting|Tables conditional formatting]]
Models.Where(!IsOcelModel && Configuration.TryGetValue("DataSource").TryGetValue("Events").TryGetValue("DataSourceType") == _EMPTY).(Project.Name + ": " + Name + " (" + Id + ")")
* 307948: Dashboard properties layout and terminology changes.
</pre>
* 307911: IP address verification has been removed.
Those models don't have a valid datasource defined and thus they are likely not is use. Easiest solution is to delete those models with following command:
* 307931: Expression language and performance improvements (originated from Spark prototyping).
<pre>
* 307774: Web API operation /api/importfile for data import.
ModelById(<id>).DeletePermanently()
* 307933: Default logging mode has been changed to ExclusiveLock for all components.
</pre>
* 307904: Server side support for UI languages.
</div>


'''Fixed issues:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219372: Issue with simultaneous eventlog processing that caused "Value cannot be null" errors and sometimes calculation with incorrect eventlogs.
SQL Server database compatibility level needs to be at least 130 (corresponding to SQL Server 2016) for databases used by QPR ProcessAnalyzer. When using a supported version of SQL Server, the database compatibility level might still be unsupported, so please check to used compatibility level. It's recommended to set the highest available compatibility level. More information: https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.
* 219375: --#CallWebService didn't work with Content-Type parameter.
</div>
* 219357: UI was stuck to IdP login page when SAML settings (e.g SAMLUserIdAttribute) were misconfigured.
* 219391: After logout GetOperationProgress failed for validating session.
* 219408: Removed focus outline border from buttons and textboxes.
* 219398: ETL Access denied CheckIsInProjectContext.
* 219373: Case.FlowOccurrences and Case.FlowOccurrencesByType have Variations preprocessing missing.
* 219382: Query for open operations should not return "open" operations that were started before the server startup time.
* 219402: Model with LoadOnStartup=true doesn't work with case level permission with expressions referring to current user.
* 219409: Filters containing event type and variation rules always filter out all cases.
* 219416: Error in model loading in startup can effect other model loading.
* 219369: Change error message "Time out while waiting for server response.".
* 219387: Text filter options opened to left for ChartView making them partly hidden for first column.
* 219395: Save button not always enabled when editing dashboard.
* 219396: Context change notification should not be called for closing dashboard charts.
* 219411: Right click menu issue in PA Flowchart analysis view.


== QPR ProcessAnalyzer 2020.4 (release date 2020-05-26) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2020.4.0.41643, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
[[External_Content|External content]] component doesn't allow to embed websites from other origins than the QPR ProcessAnalyzer server. This is due to a change in the Content security policy (CSP) HTTP header (more information: [[QPR_ProcessAnalyzer_Security_Hardening#Added_HTTP_Headers|Security hardening]]). The content security policy HTTP header can be modified in the [[Installing_QPR_ProcessAnalyzer_Server#Server_settings_file_(appsettings.json)|appsettings.json file]]. More information about the ''same-origin policy'': https://developer.mozilla.org/en-US/docs/Web/Security/Same-origin_policy.
</div>


'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* In QPR ProcessAnalyzer 2020.4, the deployment package dashboards come with the installation, so there is no deployment package anymore to be installed. The previous deployment package located in the ''QPR ProcessAnalyzer UI'' project can be deleted when 2020.4 is installed.
QPR ProcessAnalyzer now uses the Microsoft.Data.SqlClient library for SQL server connection instead of the System.Data.SqlClient library, and there are slight differences with the connection string parameter default values. If using a self-signed certificate in the SQL Server with the encrypted connection, it might require to add '''TrustServerCertificate=True''' to the connection string, so that QPR ProcessAnalyzer will trust the self-signed certificate and allow the database connection.
* To fix issue ''Datetimes are incorrect in files exported from data grids'' (219377), [[Data Grid Export Service|data grid export service]] needs to be updated from version V001 to V002.
</div>
* Issue workaround: After updating to QPR ProcessAnalyzer 2020.4, dashboards containing the root causes analysis give an error message about invalid chart configuration. The problem can be fixed as follows: from the JSON text that appears in the full screen text editor, make the following text replacements: "Case Attribute" --> "Case attribute" and "Attribute Value" --> "Attribute value". When the dashboard is saved, the error doesn't appear anymore.
* To improve performance, for custom expressions in charts it's recommended to replace ''??_remove'' with the [[Generic_Functions_in_QPR_ProcessAnalyzer#RemoveNulls|RemoveNulls]] function. Example: Expression ''Average((_.Attribute("Cost") ??_remove)._)'' can be changed to ''Average(RemoveNulls(_.Attribute("Cost")))''.
* To improve performance, for custom expressions in charts it's recommended to change expressions that make duration aggregations to work in a way that the aggregation is made before converting TimeSpans to integers (e.g. to days). Example: expression ''Average(_.Duration.TotalDays)'' can be changed to ''Average(_.Duration).TotalDays''.
* Issue: In Firefox, when opening a dashboard, an error message "Error in chart settings" might appear (the dashboard is still opened correctly). If the issue appears, it's recommended to use Chrome, where the issue does not appear that often. There are no other workarounds available for the issue.
* Issue: FlowOccurrences and FlowOccurrencesByType properties don't work for Case objects when there are also filter rules applied. Some measures and dimensions use those properties. QPR ProcessAnalyzer 2020.5 will fix the issue, and for earlier versions there is no workaround.  


'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307859: Deployment package dashboards are embedded to QPR ProcessAnalyzer release.
Project ''Designer'' and ''Administrator'' roles can now create models and datatables in the project. Earlier these operations required the global ''Create models'' role. This global role is now renamed to ''Create projects'', describing its new purpose.
* 307899: RemoveNulls function to remove null values from arrays.
</div>
* 307915: Expression language improvements related to CSV file generation.
* 307809: When dashboard is opened, editing mode is disabled when no rights to edit the dashboard.
* 307829: Highcharts, Syncfusion, GoJS and some other components have been updated to their latest versions.
* 307848: Component updates for building QPR ProcessAnalyzer UI.
* 307882: JavaScript libraries are split into smaller files in release build.
* 307932: Some PAPO buttons are removed from the tool palette.
* 307912&307917: ChartView and main header improvements for 2020.4 (parts 1 and 2).


'''Fixed bugs:'''
===Features===
* 219365: Sometimes system stuck during the time models were being loaded into memory.
* B-08395: Added native [[Object-Centric_Flowchart|object-centric flowchart]] showing predefined measures.
* 219326&219377: Datetimes are incorrect in files exported from data grids (time zone difference) (See also the notes above).
* B-08396: Object attributes are now available as [[Object-centric_Process_Mining_Model#Object-centric_perspectives|case attributes in object-centric perspective]].
* 219378: ChartView resizing sometimes didn't work when using full screen.
* B-08449: Snowflake Native App supports [[QPR_ProcessAnalyzer_Project_Workspace#Snowflake_Native_App|project-specific database, schema, and warehouse]].
* 219371: Error messages have been improved for session expired and unknown error.
* B-08432: Decision intelligence event log [[Create_Predicted_Eventlog|prediction]] and [[Create_Simulated_Eventlog|simulation]] has been integrated into QPR ProcessAnalyzer.
* 219360: Some styles were defined twice in CSS.
* B-03062: Project Designer and Administrator roles can now create models and datatables, and global "Create models" role changed to "Create projects".
* B-08471: Model properties dialog has been simplified for Native App to exclude in-memory model datasources.
* B-08504: Charts don't automatically change case/event attributes and event types when encountering non-existing selections.
* B-08522: Optimized Snowflake queries that do not need event data.
* B-08454: Optimized SQL executed in Snowflake by removing unnecessary column type casts.
* B-08507: Migrated tables for scripts and script logs to Entity Framework.
* B-08519: Migrated user management tables to Entity Framework.
* B-08539: Migrated model, project and filter tables to Entity Framework.
* B-08514: Updated translations for release 2024.8.
* B-08515: Frontend components have been updated.
* B-08513: Backend components have been updated.


== Additional release for QPR ProcessAnalyzer 2020.3 (release date 2020-04-23) ==
===Fixed issues===
Build number: 2020.3.0.41450, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
* D-14320: On-screen setting didn't work when "dynamicType" is "DataTablesOfProject".
* D-14221: Content-Security-Policy HTTP headers allows only same origin for iframes, and X-Frame-Options HTTP header removed.
* D-14317: Model statistics system report gave error about invalid expression.
* D-14286: Fixed issue in model import which sometimes created partially configured model.
* D-14315: Filtering for custom dimensions didn't work, if expression refers to measures with variables.
* D-14302: "let" statement did not work in #expr-block embedded into SQL expression.
* D-14303: Flowchart lost selection when flowchart used linked variables.
* D-14311: Fixed issue were dashboards were not visible in iPhone.
* D-14301: Filtering from "First event attribute value" and "Last event attribute value" columns did not work.
* D-14314: Fixed error in BPMN editor when object-centric model didn't have perspective defined.
* D-14297: Native App incorrectly cached OAuth token causing "OAuth access token expired" errors.
* D-14248: Improved error message "Unable to read event log data from external source without specified sample size".
* D-12402: Fixed issue where flowchart start/end flows didn't start from middle of start/end symbols.
* D-14293: AI Assistant didn't work with object-centric models.
* D-14295: Fixed issue where authentication was not possible if PA_ROLE table contained roles with ROL_FLAGS field having NULL values.
* D-14245: When dialog was opened in Workspace, console showed following error: "Blocked aria-hidden on a <button> element because the element that just received focus ...".


'''Features''':
== QPR ProcessAnalyzer 2024.7 (build 8234) (released 2024-10-29) ==
* 307902 ChartView improvements for 2020.3 hotfix: Custom expressions have by default datatype "auto", added support for binding to multi-select lists in Variable bindings, bugfix: Custom sorting didn't work in presets, bugfix: Aggregation method for Pivot table was not selected correctly.


'''Fixed bugs:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219370: Dashboards could not be edited by other than administrators.
If using local datatables (stored in SQL Server), the [[PA_Configuration_database_table#SqlServerConnectionString|SqlServerConnectionString]] setting is now mandatory. Starting from QPR ProcessAnalyzer 2024.7, local datatables cannot be created if the setting is not configured. It's recommended to have a separate database for the datatables data, but it's also possible to configure the same connection to the SqlServerConnectionString setting as for the configuration database (in [[Installing_QPR_ProcessAnalyzer_Server#Server_settings_file_(appsettings.json)|appsettings.json]]). See [[QPR_ProcessAnalyzer_System_Architecture|System Architecture]] for more information about the data storage.
* 219361: Flowchart sometimes crashed to ThrowKeyNotFoundException when pressing Root Causes button.
</div>


== QPR ProcessAnalyzer 2020.3 (release date 2020-04-16) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2020.3.0.41413, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
Check whether there are custom roles in the database (table PA_ROLE) which have the ROL_FLAGS field set to NULL. The NULL values don't work with this release, so set a correct value (either 1, 2, or 3). Following query can be run in the database showing roles which have an incorrect ROL_FLAGS field:
<pre>
SELECT *
FROM [PA_ROLE]
WHERE [ROL_FLAGS] = NULL;
</pre>
</div>


'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* Legacy Chart and Gauge presentation objects are removed from QPR ProcessAnalyzer (they are different than ChartView). If there are dashboards containing those types of presentation objects after updating to 2020.3, there will be a placeholder frame instead with an error message of a non-existing presentation object. To change the dashboard, remove those placeholders and replace with ChartViews. It's recommended to make the replacement to ChartViews before the update, because chart and gauge settings cannot be accessed anymore in 2020.3.
Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.11. Old versions of the functions use Python 3.8 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications emails about existing deprecated functions. It's recommended to remove the old functions which are following:
* ChartView will change from an HTML presentation object to a native presentation object, which ensures that dashboards will work in future releases when the ChartView is evolving. ChartViews created with 2020.2 will be automatically migrated to the native ChartViews in 2020.3. ChartViews created with 2020.1 or earlier releases need to be updated manually by removing the ChartView from the dashboard and replacing it with a new ChartView.
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
* QPRPA_UDTF_CLUSTER
* QPRPA_UDTF_CLUSTER_V2
* QPRPA_UDTF_CLUSTER_V3
* QPRPA_UDF_BPMN_IS_CONFORMANT
* QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS
</div>


'''Features:'''
'''Features'''
* 307849: Securely stored strings for passwords.
* B-08458: Object-centric perspectives can be stored as filters and object-centric model can be selected for dashboard.
* 307746: ChartView is now a native presentation object instead of an HTML presentation object. ChartView's made in 2020.2 are automatically converted to the native presentation objects.
* B-08472: Snowflake filter cache tables are now created in background to improve performance.
* 307880: When a datatable model is moved to another project, the linked datatables should also be moved to the project.
* B-08452: Limited sampled cases to 10000 in Snowflake and in-memory clustering presets.
* 307556: Functions to expression language to improve usability and performance: CaseCount, EventCount, EventCountByType and Round.
* B-08430: Improved [[Process_Flowchart|Snowflake flowchart]] performance by calculating variations using sampling.
* 307895: SQL scripting command for database commit.
* B-08446: QPR ProcessAnalyzer can be deployed as Snowflake application package to publish it as a [[QPR_ProcessAnalyzer_Native_App_in_Snowflake|native app]].
* 307850: Expression language performance improvement by a new way to calling functions and properties.
* B-08418: QPR ProcessAnalyzer has been integrated into Snowflake authentication for Snowpark Container Services.
* 307858: Expression language: Support for array operators.
* B-08420: Legacy "Local" datatables cannot be created anymore - only separate SQL Server database is supported (see release note above).
* 307845: Header buttons layout has been improved.
* B-08437: Snowflake cache is now bypassed for queries that have caching disabled.
* 307870: Preprocessings are determined automatically.
* B-08443: Improved object-centric models performance by optimizing perspective generation.
* 307761: Functionality that user doesn't have access is now disabled in the dashboard designer and workspace to avoid access denied errors.
* B-08450: Updated Snowflake UDF's python version from 3.8 to 3.11 (see release note above).
* 307839: Generic chart and gauge presentation objects are removed.
* B-08425: Migrated nine configuration data tables to use Entity Framework.
* 307863: Automatic redirection to SAML authentication.
* B-08334: Removed legacy functionality related to models.
* 307872: API support for querying if SAML is configured.
* B-08337: Removed legacy functionality related to roles.
* 307846: Error message further improvements.
* B-08456: Frontend components have been updated.
* 307888: Error message text changes for Dashboard not found and Multiple dashboards found.
* B-08477: Backend components have been updated.
* 307874 & 307887: ChartView and main header has been improved.
* B-08478: Updated translations for release 2024.7.


'''Fixed bugs:'''
'''Fixed issues'''
* 219341: Analysis function unnecessarily required FilterId parameter.
* D-14263: Filtering with case id caused error when Snowflake model didn't have case attributes datatable.
* 219343: Root causes analysis gave access denied when using Analysis function.
* D-14256: Workspace showed progress spinner forever if trying to remove rows from table where there is no access.
* 219348: Query cancellation caused database connection leakage.
* D-14250: "Show in Query Designer" button didn't show full query sent to server.
* 219332: "Thread was being aborted" returned to client while loading model from datatable.
* D-14285: Non-breaking spaces didn't work in json fields.
* 219321: Removed unnecessary error log lines "Missing expected HttpRequest X-Forwarded-For" that appeared even if UseXForwardedForAsClientIp=false.
* D-14278: Workspace models list showed linked cases/events datatable even though datatable didn't exist.
* 219335: [_remove ]._ or empty array is not handled correctly in a KPI dimension.
* D-14251: Aggregations list in Combined measure/dimension/column incorrectly showed aggregations for all data types.
* 219340: default.aspx does not work.
* D-14257: Exporting datatable with no columns froze loading spinner.
* 219330: EditDashboards permission should be needed for target project when moving dashboards between projects.
* D-14188: Script incorrectly aborted after error occurring in the import phase of client-side import.
* 219347: Queries done by the main header were cancelled when view is changed.
* D-14275: Several "Loop percentage" event measures caused flowchart error.
* 219355: Expression language: Was unable to use properties of the parent context in dictionary initialization.
* D-14259: Removed malfunctioning undo/redo operations from Design diagram.
* 219346: PAPO flowchart should have by default median duration shown on flows and flow counts hidden.
* D-14260: Design diagram toolbar incorrectly scrolled to left when diagram was zoomed.
* 219333: PAPO generated incorrect filter JSON and unnecessary query.
* D-14262: Opening version information caused javascript error if backend communication failed.
* 219311: When opened a view by identifier, the view was fetched twice from the server.
* D-14271: None aggregation didn't work with some Statistical calculations.
* 219329: Unnecessary information was stored in database for dashboard definitions.
* D-14283: BPMN editor toolbox has now correct font.
* 219362: Issues with session expiration checks.
* D-14280: Dashboard component stacking order buttons didn't work if dashboard had z-indeces with gaps.
* 219364: Session expiration with SAML authentication configured gives incorrect error message.
* 219344: Case count view in model manager header and Home view can cause unwanted model loading.
* 219242: Flowchart is not updated correctly after event type filtering.


== QPR ProcessAnalyzer 2020.2 (release date 2020-03-09) ==
<span id="84516a70"></span>
Build number: 2020.2.0.41129, Model compatibility version: 3, Database version: 67, PACM file version: 7, Protocol version: 33.


'''Notes:'''
== QPR ProcessAnalyzer 2024.6 (build 7414) (released 2024-09-18) ==
* Expression language has now a [[QPR_ProcessAnalyzer_Expressions#Conditional_operator_.28if.29|conditional operator "if"]] and [[QPR_ProcessAnalyzer_Expressions#Define_variables_.28let.29_and_assign_variable_values_.28.3D.29|variable declaration operator "let"]]. In earlier QPR ProcessAnalyzer versions, the expression language had functions [[Generic_Properties_and_Functions_in_QPR_ProcessAnalyzer_Expressions#If|If]] and [[Generic_Properties_and_Functions_in_QPR_ProcessAnalyzer_Expressions#Let|Let]] which earlier could also be written in lowercase (i.e. "if" and "let"). Starting from QPR ProcessAnalyzer 2020.2, the lowercase versions refer to the conditional and variable declaration operators, and the uppercase versions refer to the corresponding functions. If there are expressions containing "If" and "Let" functions written in lowercase, please change them starting with uppercase.
* Issue workaround: The Root Causes analysis don't work (shows empty) in the right side chart (PAPO) of the ''Process Discovery'' view. The issue can be fixed as follows by an administrator: click the ''Edit'' toggle button, click the right side chart, click the ''Edit'' icon in the top right of the chart, click the chart again, click ''Properties'' icon in the top right of the chart, open ''Variables'' tab, find the ''InfluenceAttributeTypeId'' variable, and change its value to empty (instead of ''20''). Click ''Close'' twice to go back to the main level and click ''Save'' button. The issue will be fixed to 2020.3.
* Issue workaround: In ChartView, the ''Duration between events'' measure and dimension don't work when there are filters in use (the chart is empty). Workaround is to add the following ''Suffix expression'' to the measure or dimension settings (without quotes): "''//eventtypes''". The issue will be fixed to 2020.3.


'''Features:'''
'''Features:'''
* 307779: SAML 2.0 support for PA UI.
* B-08366: Frontend for [[Object-centric_Process_Mining_Model|OCPM model]] configuration and Snowflake charts using perspectives.
* 307789: PAPO now supports ModelId variable and new filters.
* B-08365: Added following visual settings for [[QPR_ProcessAnalyzer_KPI_Card|KPI Card]]: font size, text color, text styles, vertical and horizontal alignment.
* 307854: Filter selector for main header.
* B-08382: Measures, dimensions and columns can be duplicated in [[QPR_ProcessAnalyzer_Chart#Measure,_Dimension_and_Column_Settings|chart settings]].
* 307844: Improved main header (visible in view designer and workspace) (part 2).
* B-08381: [[QPR_ProcessAnalyzer_Table|Table]] vertical scrollbar is now hidden when table is not scrollable.
* 307820: Improved main header (visible in view designer and workspace).
* B-08355: Expression language identifiers are primarily assumed as variables and secondarily as property names.
* 307840: Model loading script is now run in a security context allowing access to the project. Setting AllowExternalDatasources for disabling ODBC interfaces.
* B-08402: QPR ProcessAnalyzer can now connect to Snowflake when running in Snowpark Container Services.
* 307763: Root causes analysis supports multiple case attributes.
* B-08389: Added support for making multiple Snowflake queries in same request for OCPM queries.
* 307737: Datatable columns can be queried without loading entire datatable into memory.
* B-08416: Improved backend functionality for partially configured OCEL models.
* 307780: When user logs in, last used model and default filter of the model is added to the session context.
* B-08428: Improved Snowflake calculation performance by including to filter cache tables only the event table key (this behavior can be opt-in with a [[PA_Configuration_database_table#CacheOnlyPrimaryKeysForFilters|CacheOnlyPrimaryKeysForFilters setting]]).
* 307547: Expression filter rule supports value conversion expression for better compatibility with e.g. date values.
* B-08448: Add configuration to disable event cache tables storing primary key only.
* 307841: Expression language has a new function [[Process_Mining_Objects_in_Expression_Language#Case|Case.DurationBetweenEvents]].
* B-08340: New users don't have a default model selected when login for the first time.
* 307819: Expression language improvements for functions, variables and statements.
* B-08413: Frontend components have been updated.
* 307827: New function EventsWindow (and expression optimization to take it into use automatically)
* B-08397: Backend components have been updated.
* 307794: [[ QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model | GenericWrite permission]] should see model object counts when case level permissions are in use.
* B-08398: Updated translations for release 2024.6.
* 307776: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|Effective permissions]] can be queried using expression language.
* 307838: /api/projects returns effective permissions for each project.
* 307832: Browser side caching has been optimized for performance.
* 307787: Session data and permission are cached for improved performance.
* 307853: Memory management operations to expression language.
* 307803: Error message improvements (part 2).


'''Fixed bugs:'''
'''Fixed issues:'''
* 219198: In web.config, empty setting names are formatted as <value></value>.
* D-14209: Fixed issue where moving projects in Workspace was not possible.
* 219199: In web.config, ResponsePollingInterval is 3600000.
* D-14186: Highcharts visualizations datalabel texts were incorrectly shown over tooltips.
* 219200: Model.EstimatedMemory gave too large estimate for models with lot of event types.
* D-14210: Fixes for issue with incorrectly shown pending tasks in System Reports.
* 219222: AggregateOthers didn't work with MaximumRowCount when dimensions is null in expression analysis.
* D-14242: SqlDataFrame Persist function now keeps the original column types even if they are changed.
* 219276: It should be possible to set filter to be model default filter when the filter is created.
* D-14147: Snowflake queries gave "Object reference not set to an instance of an object" error with MaximumRowCount higher than 2 billion.
* 219280: It should be possible to delete model default filter.
* D-14189: Dropdown list component gave following error when clicking Add button for "List items": Cannot read properties of undefined (reading 'axisLabel').
* 219275: Changing model default filter should only be possible for ManageViews permission.
* D-14192: Datagrid paging settings are now preserved when resizing or zooming window.
* 219297: Designer user can delete other people published filter from web UI but cannot delete it from PA Excel Client.
* D-14214: In System reports, dropdown list showing dashboards didn't open if there were more than 1000 dashboards.
* 219285: Expression filter gives "Value was either too large or too small for an Int32".
* D-14218: CSV file import didn't detect existing column correctly when there was difference only in letter case.
* 219304: Expression analysis returning DataFrame doesn't work in SQL script that prints to Excel sheet.
* D-14184: Giving ScriptText or ScriptFileName as parameter for QPR ScriptLauncher created a broken script.
* 219251: Sample files removed from \\Release\Files\OfficeAddIns\Excel\Example Data.
* D-14220: AI assistant gave strange error message when trying to explain chart showing error.
* 219293: AnalyzeConformance function throws KeyNotFoundException - variation data missing.
* D-14135: Expression based Snowflake filter rule caused error "Object reference not set to an instance of an object".
* 219261: Restored model model could not be open.
* D-14229: In Snowflake, disabled filter rules didn't affect header object counts when there were several filter rules.
* 219271: Invalid security notification when using Excel client.
* D-14228: In Models and Model statistics reports, columns showing case and event attributes didn't work.
* 219298: X-Forwarded-For handled incorrectly in Functions.GetClientIpAddress.
* D-14213: In User Settings dialog, Effective Permissions settings are now preserved while dialog is open.
* 219305: Decimal datatype caused problems in the expression language.
* D-14227: Fixed issue where applying chart settings in System reports made settings pane empty.
* 219323: Delete operation deleted unexpected project, models and datatables.
* D-14185: Stack traces were incorrectly returned even if IncludeExceptionDetailsInErrors was false.
* 219337: EventTypes in ModelInformation in PA response should contain entire model data.
* D-14226: Fixed several OCPM calculation related issues in backend.
* 219339: Expression language: If statement without false statement causes an exception if the condition is false.
* D-13943: Added error message to Case attribute selector when model doesn't have selected case attribute.
* 219172: Invalid filterId causes "Internal server error" and " Method Not allow" error.
* D-14162: Expression "0.()" gave null reference error.
* 219258: Exception message is not shown properly in PA Web UI for FaultException.
* D-14246: Chart setting dialog may have been partly out of screen when activating other chart while in dashboard is scrolled.
* 219281: Improving the error handling for invalid ModelId.
* D-14238: Snowflake chart measure aggregation is incorrectly affected by statistical calculations.
* 219284: Client side forces filterId=0 even if filter is not mentioned.
* D-14133: In Snowflake chart, events Aggregate settings caused JaveScript error and UI messed up.
* 219313: After adding the same existing panel twice, not possible to delete it from the view.
* D-14172: Fixed issue where validation error appeared when copying and moving elements in Design Diagram.
* 219320: Duplicate id on PanelDesigner field-properties.html template.
* D-14253: Table didn't show column filter icon when column name was empty.
* 219336: When PAPO is added from tool palette, InfluenceAttributeTypeId variable contains invalid value "20" (should be empty).


== QPR ProcessAnalyzer 2020.1 (release date 2020-01-21) ==  
== Additional release for QPR ProcessAnalyzer 2024.5 (build 6814) (released 2024-07-01) ==
Build number: 2020.1.0.40909, Model compatibility version: 3, Database version: 65, PACM file version: 7, Protocol version: 32.
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Known issue: It's not possible to move projects that existed before updating to this release. The issue will be fixed in the next release. There is a following workaround available: Administrator user can go to the [[Navigation_Menu#Expression_Designer|Expression Designer]] and run the following expression: '''Projects.Modify(#{})'''.
</div>


'''Features:'''
'''Fixed issues:'''
* 307749: Support for importing data to the datatable models.
* D-14191: Running script by id failed on data import when parameters contained ScriptId.
* 307813: DataSourceType parameter to --#ImportEvents and --#ImportCaseAttributes ETL scripting commands.
* D-14183: Fixed issue where flowchart SVG export only exported the visible part of flowchart.
* 307743: Backend support for saving the new filters.
* 307775: Effective dashboard permissions are included to dashboard definition when fetched from the server.
* 307772: Dashboard project path is added to dashboard definition when fetched from the server.
* 307778: When saving a view, the view is not anymore reloaded unnecessary.
* 307810: Expression language adjustments.
* 307818: Drop support for QPR ProcessAnalyzer Excel Client for Excel 2013.


'''Fixed bugs:'''
== Additional release for QPR ProcessAnalyzer 2024.5 (build 6769) (released 2024-06-27)==
* 219236: Microsoft.AspNet.Identity.Core.dll and Microsoft.AspNet.Identity.Core.xml files missing when installing QPR ScriptLauncher from the installation package.
* 219291: QPR ProcessAnalyzer didn't work in https only configuration.
* 219264: DataFrameMode enabled for KPI analysis even if Values have been defined (but Dimensions is empty).
* 219223: Variable function don't work with upper case variables.
* 219267: Viewing DataFrame contents in KPI analysis gives incorrect results.
* 219279: DataFrame columns by name is unavailable inside user defined functions in KPI analysis.
* 219259: It should be possible to enable CORS from all origins.
* 219274: "Inconsistent or unavailable ids" error when using all cases filter.
* 219290: Getting contents of a dashboard is slow in a customer environment.
* 219286: User could not open any models after using broken model.
* 219227: Slowness in model creation when read data from datasource - event cost calculation improvements.
* 219250: Slowness in event creation when read data from datasource - group by event sorting.
* 219292: Performance issue in /api/uielements as it unnecessarily fetched dashboard contents.
* 219295: Client side fix for 219292.
* 219269: Query results were handled incorrectly in the client side - datatype is cell specific, not column specific.


== Additional release for QPR ProcessAnalyzer 2019.9 (release date 2019-12-18) ==
'''Features:'''
Build number: 2019.9.0.40754, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.


'''Notes'''
*B-08388: Added backend support for OCPM model perspectives to convert object-centric eventlogs into case-centric.
* Starting from QPR ProcessAnalyzer 2019.9 the separately installed QPR UI is not needed anymore. Instead, the web UI is now part of QPR ProcessAnalyzer and does not require a separate installation. The new UI can be accessed in ''http(s)://SERVER/QPRPA/ui/'' (where SERVER is the hostname of your QPR ProcessAnalyzer server). Dashboards in the old QPR UI are not moved automatically to QPR ProcessAnalyzer, and also the QPR UI dashboard export files are not compatible with the new QPR ProcessAnalyzer UI.


'''Features for QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 307785: Angular Migration: Migrate ProcessAnalyserService.
* 307786: Angular Migration: Migrate FieldPropertiesUtils.


'''Fixed bugs for QPR ProcessAnalyzer:'''
*D-14187: Creating local datatables was not possible in Workspace if datatables were stored to the configuration database (i.e., SqlServerConnectionString setting is not used).
* 219262: Login to PA UI is not possible when there is + character in the password
* 219263: Opening dashboard which definition is large
* 219257: It should be possible to get DataFrame cell value by column name in expression analysis


== QPR ProcessAnalyzer 2019.9 (release date 2019-12-10) ==  
==QPR ProcessAnalyzer 2024.5 (build 6746) (released 2024-06-25)==
Build number: 2019.9.0.40704, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307484: Implemented Excel client protocol version for improved compatibility for older Excel Clients.
*B-08338: Added reports to monitor dashboards usage: Popular dashboards, Dashboards by users and by time, and specific dashboard usage.
* 307564: [[Web.config_file_in_QPR_ProcessAnalyzer|Case sampling]] is disabled by default.
*B-08314: Snowflake connection string can be [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Connection|specified for each project]] to allow projects connecting to different Snowflake accounts, databases or schemas.
* 307724: There is a support for self-signed certificate for QPR ProcessAnalyzer service.
*B-08341: Added [[SQL_Expressions#GetRelatedValueFrom_function|GetRelatedValueFrom]] and [[SQL_Expressions#AggregateRelatedValueFrom_function|AggregateRelatedValueFrom]] SQL expression functions to extend models with data from additional tables.
* 307705: User related information and session id is available for HTML presentation objects.
*B-08301: In chart settings, selecting another measure/dimension/column now doesn't reset settings.
* 307712: Error messages from the backend are shown in UI
*B-08317: Added Snowflake presets for Root Causes for Attributes in table and detailed table format.
* 307750: PA UI Frontend (part 3)
*B-08318: Improved Snowflake Events preset performance by adding a filter that picks a subset of cases.
*B-08385: Open AI default large language model has been changed to "gpt-4o".
*B-08342: Added DashboardName and DashboardProjectName properties to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
*B-08320: Added RenameAllColumns function to dataframes to easily rename all columns.
* B-08321: Added DataSourceConnection property to dataframes in expression language.
*B-08307: Finetuned Workspace functionality for models that don't have datasource defined.
*B-08329: Optimized metadata queries to Snowflake to improve performance.
*B-08311: Changed QPR ScriptLauncher interaction with the server by changing long polling to short calls to improve robustness.
*B-08368: Implemented backend support for configuring and importing OCPM models.
*B-08352: Frontend components have been updated.
* B-08348: Backend components have been updated.
*B-08349: Updated translations for release 2024.5.


'''Fixed bugs for QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 219170: Conformance checking didn't work when there is a non-existing bpmn task between parallel gateway and the end event.
*D-14150: Charts temporarily showed as too large when resized with non-zero chart margin values.
* 219152: Loading model into memory doesn't anymore require a ResetModelCache permission.
*D-14058: Login page is not anymore shown when SAML authentication is configured and user is directed to the identity provider.
* 219213: Improved model loading performance when using ODBC, datatable and expression datasources.
*D-11579: Column filter menu in tables can now appear outside the table area which is useful in small tables.
* 219218: Order of the comparison rules incorrectly affected the influence analysis results.
*D-14144: Fixed issue where Snowflake clustering failed if there were date type of case attribute with null values.
* 219240: Import model or export model from filter gave "Input string was not in a correct format" error.
*D-14163: Non-breaking spaces appeared strangely as "&amp;nbsp;" in Highcharts charts.
* 219238: Fix for error message "CommunicationException: The remote host closed the connection".
*D-14132: Snowflake model object counts were not shown when opening dashboard while model metadata was still loading.
* 219249: Access was incorrectly denied for non system admins when saving a new dashboard.
*D-14142: CreateDataTable function incorrectly deleted all source datatable content if connection included source datatable name.
*D-14161: Fixed issue where Append function in SqlDataFrame broke source data.
*D-14157: AI Assistant didn't show detailed error message when OpenAI query failed.
*D-14137: AI Assistant incorrectly appeared on top of chart in the fullscreen mode.
*D-14170: Toolbar dropdown lists didn't work when dashboard contained more than one Design Diagram.
*D-14146: Fixed error "Unable to get on-premise gateway named..." when running script from SQL script using QPR ScriptLauncher.
*D-14106: Having only a template string in the #expr{...} block didn't work.
*D-14008: "Root Causes contribution" and "Comparison eventlog cases percentage" columns didn't work (in-memory).
*D-14010: Occurrences of specific flow measure didn't work with the Root causes analysis weighting expression (in-memory).
*D-14148: Root causes for case duration preset didn't support Multi-unit time settings.
*D-14139: Added info message when successfully exporting model to pacm file.
*D-14153: Fixed in-memory measures for "Flow duration" and "Occurrences of specific flow" which failed when selected flow didn't exist.
*D-14167: Fixed issue where ScriptLauncher sometimes terminated prematurely on exceptions occurring in on-premise import.
*D-14165: Flowchart export file name was incorrect and exported flowchart background was always transparent.
*D-14160: Fixed issue where DashboardId wasn't recorded to operation log when opening dashboard by identifier (DashboardsController.GetByIdentifierPath).
*D-14159: IsHidden property didn't work in in-memory Value expressions.
* D-14131: Some popup messages had incorrect html escaping.
*D-14151: Fixed issue where flowchart might have given browser console error when clicking event types or flows while still loading data.
* D-14022: In System reports, numeric aggregations which don't work in SQL Server are now hidden.
*D-14129: Imported model name was incorrectly cut if it contained dots.


== QPR ProcessAnalyzer 2019.8 (release date 2019-10-30) ==  
==QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14)==
Build number: 2019.8.0.40391, Model compatibility version: 2, Database version: 62, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307633: [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_Datatables|Datatables]] can be used as a PA model datasource (part 1).
*B-08227: Dashboards have [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] (powered by ChatGPT) helping users in process analysis. AI Assistant can answer general questions about the process, create filters based on user prompt, and explain charts and analyses.
* 307700: JSON filter rules should not give error for non-existing values, such as event type names.
*B-08277: QPR ProcessAnalyzer now detects automatically when cases or events data in Snowflake updates. Check is done every 5 minutes which is the maximum delay of detecting new data. ([[Snowflake_Connection_Configuration#Automatic_data_update_detection|more information]])
* 307721: Improvements to model [[QPR_ProcessAnalyzer_Model_JSON_Settings#Automatic_Loading_on_Server_Startup|Improvements to model LoadOnStartup]]: loading is done in a separate thread and in parallel.
*B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
* 307693: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language|Expression language: Return attributes in alphabetical order]].
*B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
* 307738: Expression language: [[QPR_ProcessAnalyzer_Expressions#Null_conditional_operator_.28.3F._and_.3F:.29 | null-conditional]] and [[QPR_ProcessAnalyzer_Expressions#Null_coalescing_operator_.28.3F.3F.29 | null-coalescing operators]].
*B-08276: Adjusted permissions for [[Roles_and_Permissions#Project_Permissions|moving projects]].
* 307725: Expression language: AsParallel function for making calculations in parallel to improve performance.
*B-08310: Added Details property to [[Generic_Objects_in_Expression_Language#Exception|Exception object]] in expression language.
* 307715: New PA Web UI Backend (part 3).
*B-08328: Language translations have been updated to 2024.4.
* 307728: New PA Web UI Backend (part 4).
*B-08312: Frontend components have been updated.
*B-08308: Backend components have been updated.


'''Fixed bugs for QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 219210: ScriptLaucher CSV export should quote string values with double quotes when the string value contains semicolon.
*D-14084: Filter rule for first and last event in case couldn't be edited if there were more than one event selected.
* 219143: IIS https only setup does not work.
*D-14091: Duration multi-unit didn't work in big data chart.
* 219186: Event.IndexInCase had issue with event type filters.
*D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
* 219167: Event.OutgoingFlowOccurrence and Event.IncomingFlowOccurrence had issues with event type filters.
*D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
* 218689: _.Cases and _.Events doesn't work as a root in EventLog context in KPI Analysis.
*D-14107: Snowflake model that has earlier been an in-memory model showed case count and estimated memory incorrectly.
* 219004: PA license expiration causes unclear error in UI.
*D-14074: Fixed issue in QPR ScriptLauncher when calling the script from other script.
* 219187: KeyNotFound exception occurred when include only all cases from the Path Analysis.
*D-14104: Fixed expression language parsing issue with in-memory DataFrame and filter using "In" function.
* 219197: Minor issues in ODBC datasource.
* D-14121: Datatable UpdateRows function now supports column names given as expressions.
* 219207: Flowchart influence analysis does not work properly when using both Filter and Comparison parameters.
* D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
* D-14123: There was an error of unable to get on-premise gateway when using ExtractSap function in expression language script from SQL script called from expression language script.
*D-14128: Table without title was incorrectly exported as .txt file.
*D-14112: Convert to custom expression button didn't work in design diagram.
*D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
*D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed in chart settings.
*D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
*D-14096: Highcharts tooltip square icons were slightly misaligned.
* D-14099: There was a console warning when opening the business calendar dialog.
*D-14118: Design diagram sometimes gave following JavaScript error: Cannot read properties of undefined (reading 'parentNode').
*D-14024: If quickly logging out after changing model, the model change might not be been saved.
*D-14120: User.getAttribute function returned values from incorrect context.
*D-14102: Pivot table cannot read properties of undefined.
*D-14161: SqlDataFrame.Append breaks the used source SqlDataFrames


== QPR ProcessAnalyzer 2019.7 (release date 2019-09-25) ==  
==QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)==
Build number: 2019.7.0.40226, Model compatibility version: 2, Database version: 61, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307655: Drop support for SQL core as PA data source (Part 5 Memory optimization).
* B-08024: [[Design_Diagram|Design diagram]] has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
* 307696: New PA Web UI Backend.
*B-08242: Script based [[Actions_to_Run_Script_in_Table|actions]] can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
* 307710: New PA Web UI Backend (part 2).
*B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
*B-08288: Added expression language functions to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Start|start and stop]] scripts.
*B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
*B-07906: Implemented cross joins to SQL dataframes.
*B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
*B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
*B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
*B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
*B-03047: Removed support for dashboard panels.
* B-08214: Removed unused columns from the PA_VIEW table.
*B-08254: Frontend components have been updated.
*B-08255: Backend components have been updated.
* B-08233: Language translations have been updated to 2024.3.


'''Fixed bugs for QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 219164: Event.NextInCase/PreviousInCase didn't work with event type filters.
*D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
* 219136: ODBC model not support import and remove functionality.
*D-14035: In design diagram, BPMN event and gateway symbols are now circular.
* 219171: Event.NextInCase and Event.PreviousInCase requires CaseEvents preprocessing.
*D-14049: Added some missing translations for table column filter and BPMN editor.
* 219173: Out of memory error and application pool crashing in customer environment.
*D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
*D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
*D-13976: Fixed issue where gateway-based imports were not synchronous.
*D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
*D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
*D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
*D-14071: Business calendar button press caused error when user didn't have access to any model.
*D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
*D-11268: There were inconsistent button colors in Workspace.
*D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
*D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
*D-14081: Fixed null references error when logging null in expression script.


== QPR ProcessAnalyzer 2019.6 (release date 2019-08-08) ==  
==Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)==
Build number: 2019.6.0.40009, Model compatibility version: 2, Database version: 59, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307260: Update to Visual Studio 2017 and update to .Net 4.7.1.


'''Fixed bugs for QPR ProcessAnalyzer:'''
*B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.
* 219106: Datetime ticks property in the expression language should be in UTC.


== QPR ProcessAnalyzer 2019.5 (release date 2019-06-19) ==
'''Fixed issues:'''
Build number: 2019.5.0.39902, Model compatibility version: 2, Database version: 59, PACM file version: 7.


'''Features for QPR ProcessAnalyzer UI:'''
*D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.
* 307330: Filtering renewal: PAPO.
* 307638: Angular Migration: Migrate Analysis classes part 3.
* 307653: Angular Migration: Migrate Analysis classes part 4.


'''Features for QPR ProcessAnalyzer:'''
==QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)==
* 307649: Drop support for SQL core as PA data source (Part 4 Source code removal).


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219040: Clustering analysis expression doesn't take into account model without any case attributes.
The legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Models.Filters]] and [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property.
* 219001: Case Analysis always limited to 1000 rows (other analyses have the same problem).
</div>
* 219042: PAPO: "Influence Analysis for Case Attributes", value is rounded to closest integer.
* 218944: PAPO: Recycle bin icon in filter rule name is not visible when there is long text without spaces.
* 219041: When duration limit 0, filters made from duration beams don't work.
* 219099: Datetimes in expression language query don't show fraction of seconds (QPR UI).
* 219103: PAPO: context menu is not working in KPI analysis.


'''Fixed bugs in QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219062: GetModels is slow for admin.
New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).
* 218978: Odd 1 million filter is adapted once you remove your custom filter.
</div>
* 219015: Script Launcher million rows limit when exporting to excel csv.
* 219022: GetModelAsStream webservice not support modelId.
* 219080: JSON filtering does not work with flowchart analysis.
* 219087: Increase from 1GB to 2GB limit in PA webservice.
* 219032: PAPO Variation Analysis is not drawn.
* 219017: Datetimes in expression language query don't show fraction of seconds (PA CORE).


== Additional release for QPR ProcessAnalyzer 2019.4 (release date 2019-05-31) ==
'''Features:'''
Build number: 2019.4.0.39800, Model compatibility version: 2, Database version: 59, PACM file version: 7.
*B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
*B-08232: Entire future eventlogs can be [[Create_Predicted_Eventlog|predicted]] based on generative AI models running in Snowflake.
*B-08166: Added expression language function [[Generic_Functions_in_QPR_ProcessAnalyzer#OpenAIChatCompletion|OpenAIChatCompletion]] to answer natural language prompts based on OpenAI ChatGPT API.
*B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
*B-08196: Conditional formatting rules can be defined for [[QPR_ProcessAnalyzer_Table#Textual_equal_rules_for_background_color|textual and boolean values]].
*B-08213: Big data chart expressions event type selections to be multi-select where applicable.
*B-08205: Expression language API is available for storing [[Storing_Secrets_for_Scripts|secrets]] for scripts.
*B-07780: Chart [[QPR_ProcessAnalyzer_Chart#Variable_mappings|variable mappings]] has been removed - use the [[Chart_Linked_Settings|linked settings]] instead. Dashboards using variable mappings are automatically converted to use linked settings.
*B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
*B-08174: Only non-default parameters values are written to the operation log.
*B-08200: Timestamps in System reports are shown in user workstation local time.
*B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
*B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
*B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
*B-08202: Updated copyright for year 2024.
*B-08199: Frontend components have been updated.
* B-08203: Backend components have been updated.
*B-08209: Translations updated for release 2024.2.


'''Fixed bugs in QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 219078: PAPO loses saved filter when changing analysis
*D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
* 219000: User with only Analyzer role can see and use private filter created by Administrator.
*D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
* 219049: Copy of a model with odbc datasource doesn't have filters from the original model.
*D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
* 219044: Calculated case attributes don't work with odbc model without defined cases.
*D-13962: System variable values were interpreted incorrectly when used in linked settings.
*D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
*D-13959: Removed possibility to add datatable columns with the legacy "any" data type.
*D-13991: Improved drop-down selector component to handle empty strings as variable values.
*D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
*D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
*D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
*D-13960: Added missing translations for list of permission list and 12-hour clock format.
* D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
*D-13969: Datatable column schema export sometimes showed empty for the key column.
*D-13862: Session token was not accepted when url path capitalization is different.
*D-13942: Datatable could not be dimensioned if it has column named "CaseId".
*D-13980: Business calendar dialog crashed when tried to open it for a model without access.
*D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
*D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
* D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
* D-13977: Multi-select dropdown lists showed some special characters incorrectly.
*D-13945: Syncfusion toast message didn't work when text contains ${[]}.
* D-13930: Pivot table throws javascript error when certain clicks.
* D-13273: Duplicate datatable row count didn't shown correctly.
*D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
*D-13985: Models list dots menu had texts misaligned in narrow screens.
*D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
*D-13997: Workspace tables column filtering search caused JavaScript errors.
*D-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
*D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
*D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
*D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
*D-14004: Removed empty filters from queries to optimize them.
*D-13988: Fixed issue where data grid context menu rendered initially as too high.
*D-13979: BPMN model editor element settings use now Open Sans font.
*D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
*D-13984: Fixed the error of refusing to run the JavaScript URL.
*D-14031: ThrownObject property was not included to http error response when error came from the script.


'''Features for QPR ProcessAnalyzer:'''
==QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10)==
* 307611: Drop support of PAIK.
* 307636: Drop PA Excel client support for Excel 2010, Windows 7 and Windows 8.1.
* 307628: Drop support for SQL core as PA data source (Part 3 Source code removal).


== QPR ProcessAnalyzer 2019.4 (release date 2019-05-07) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2019.4.0.39420, Model compatibility version: 2, Database version: 58, PACM file version: 7.
QPR ProcessAnalyzer Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime ([[Updating_QPR_ProcessAnalyzer_Server|see more]]). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.
</div>


'''Release Highlights''':
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* Custom dashboards for QPR ProcessAnalyzer can be browsed and edited more easily, as there is a Dashboards menu item available.
In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.
</div>


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307419: Change the database connection type to use in-memory core (PA Core).
*B-08019: New component [[Design Diagram]] for showing user-created diagrams in dashboards where to visualize process mining metrics.
* 307324: Drop support for SQL core as PA data source (Part 1: Export from EventLog).
*B-08087: Generic [[Dropdown_List_Selector|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* 307619: Drop support for SQL core as PA data source (Part 2: Remove analysis 26, 27 and 28).
* B-08163: Linked settings support for binding to [[Chart_Linked_Settings#Binding_to_case_attribute_filters_with_attribute_name_and_attribute_values|case attribute filter values without defining case attribute name]].
* 307523: Refactor ModelInformation code in PA Core.
*B-08170: Snowflake model filters can be [[Filtering_in_QPR_ProcessAnalyzer#Filter_actions|saved as new models]] which can be used to create snapshots of part of models.
* 307613: Quick & Easy memory usage optimizations: PA Core.
*B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
* 307618: Prediction capability to expression language.
*B-08161: Added [[Datatable_in_Expression_Language#Modify|Modify]] function to change datatable properties and improved [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CreateDatatable|CreateDatatable]] function for creating datatables.
*B-08122: Added new system report to list dashboards.
*B-08173: Removed legacy filters that didn't have any filter rules.
*B-07961: In OperationLog, changed parameters to json format and added request id.
*B-08069: Added DashboardId property to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
*B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|DeleteRows]] function to delete rows in datatables with similar logic than SQL delete.
*B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
*B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
*B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
* B-07689: For datatables, [[Datatable_in_Expression_Language#ForeignKeys|foreign keys]] to other datatables can be defined using expression language.
*B-08176: Translation updates for release 2024.1.
*B-08175: Workspace should show timestamps in user's local time.


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
'''Fixed issues:'''
* 218909: Data grid based analysis jumping.
* D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* 218971: PAPO Variation analysis has both paths and counts at the same time.
*D-13916: Chart filter could not be defined for some expressions in Big data chart.
* 218972: PAPO Duration analysis missing the grouped by dimension (default value is not set in analysis).
*D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
* 218969: Event attribute "Cost" doesn't work in Profiling Events analysis and in Expression language.
*D-13906: In Conformance Analysis, deviating flows were not translated.
* 219006: Case id's (case names) are interpreted as numbers by PAPO.
*D-13907: Improved translation related to datatable properties dialog "Used by models" field.
* 219027: Numerical attributes are shown as zero decimals in some analysis in data grid presentations.
*D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
* D-13911: Fixed small glitches in the opening and closing of drop-down lists.
*D-13918: Datatable could be configured incorrectly to use table for other datatable.
*D-13932: Duplicating datatable with custom table in datasource losed all data.
* D-11002: Removed legacy in-memory prediction preset.
*D-13912: Added check that array cannot be stored to dashboard Content property.
*D-13936: Query designer default query didn't work with Snowflake models.
*D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
*D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
*D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
*D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.


'''Fixed bugs in QPR ProcessAnalyzer:'''
==Old Releases==
* 218938: Filter rules information is not showing names for odbc loaded models and calculated case/event attributes.
See older releases in [[QPR ProcessAnalyzer Release Archive]]
* 218945: PA UI Profiling and Event type analysis with selections costs are lost.
* 218976: Inconsistency in pre-processing CaseEvents results.
* 219012: Pre-loaded models give null reference exception.
* 219008: Key is not in dictionary is thrown when selecting benchmark case attribute.
* 219034: Model calculation context for expression data source is not initialized correctly.
* 218920: Private filters are visible for other users (which is fine for admins but not for other user types).
 
== QPR ProcessAnalyzer 2019.3 (release date 2019-03-27) ==  
Build number: 2019.3.0.38860, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights''':
* It's possible to add [[Calculated_Attributes_in_QPR_ProcessAnalyzer|calculated case and event attributes]] to QPR ProcessAnalyzer models using the expression language. Calculated attributes are created when the model is loaded into memory, and they are available in the analyses like the normal imported attributes. Calculated attributes allow e.g. data conversions and cleansing, and also making calculations beforehand to improve performance.
* QPR ProcessAnalyzer has a new [[Clustering Analysis]], which divides cases into similar groups based in case attributes and occurred types of events. Clustering analysis provides a new way to understand and structure your process mining data.
* In the expression language, the left out rows can be [[QPR_ProcessAnalyzer_Expression_Analysis#Expression_Analysis_JSON_Configuration|aggregated as the last row]], which is useful, e.g. when you want to present only the most important data but still see the total amount of cases in the model. Also ChartView contains a new setting Group and Show Others using this expression language feature.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307507: Disable rectangular selection in flowchart.
 
'''Features for QPR ProcessAnalyzer:'''
* 307545: KPI: Clustering analysis and related utility functions.
* 307512: Expression language: Description attribute to Model.
* 306900: Calculated case and event attributes.
* 307533: Level of event log pre-processing can be set for [[QPR_ProcessAnalyzer_Expression_Analysis#KPI_Analysis_JSON_Configuration |expression analysis]].
* 307575: [[Web.config_file_in_QPR_ProcessAnalyzer#Qpr.ProcessAnalyzer.Common.Properties.Settings_Section |Change items memory caching times]].
* Support for Windows 8 has been dropped. Windows 8.1 is still supported.
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218863: Model manager not updated after changing Filter Id.
* 218874: Sorting and filtering icons overlap in datagrid.
* 218922: There should be default maximum number of items for different analyses created from tool palette.
* 218723: Empty analysis window after error thrown by PA service.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218908: Wrong Client data in operation log.
* 218928: Expression filter doesn't work with integers.
* 218940: Model eventlog can drop from memory.
* 218927: JSON filtering for case attributes doesn't work with nulls.
* 218779: Source data formatted to two decimals accuracy but PA total cost flowchart show much more decimals.
* 218943: ODBC SQL boolean values does not work with filter CaseAttributeValue.
* 218965: Accessing calculated event attribute value from EventType.Events -property does not work.
 
== QPR ProcessAnalyzer 2019.2 (release date 2019-02-14) ==
Build number: 2019.2.0.38539, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights''':
* Support for [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Excel_Client| Microsoft Office 2019]] for QPR ProcessAnalyzer Excel Client.
 
'''Features for QPR ProcessAnalyzer:'''
* 307423: Improved memory management: unused objects are automatically dropped from the memory. Settings can be configured in [[Web.config_file_in_QPR_ProcessAnalyzer#Qpr.ProcessAnalyzer.Common.Properties.Settings_Section | web.config]] or from the [[QPR_ProcessAnalyzer_Model_JSON_Settings#Memory_Usage_Settings | model JSON settings]].
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218838: KPI analysis: Event Occurrence Time isn't calculated properly, e.g. Period=Month fails.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218880: PAPO: odbc case and event attributes are not shown in dropdown menu.
* 218877: Support material - Project admins are not able to create new users.
* 218898: Importing XES file with xmlns -definition fails.
* 218893: Model status shows incorrectly "offline" when Model event log is in memory and Model information not.
* 218917: BaseContext.EvaluateChildExpression with given root object iterates the root object if it is an array.
 
== Additional release for QPR ProcessAnalyzer 2019.1 (release date 2019-01-23) ==
Build number: 2019.1.0.38400, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Features for QPR ProcessAnalyzer:'''


* 307357: PA model management: Analysis requests canceling. All operations have new parameters QueryIdentifier and CancelEarlierQueriesWithIdentifier.
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218806: Variation filter doesn't filter correctly.
* 218802: It should not be able to load deleted models into memory.
* 218866: Case Analysis shows "0" for textual Case Attribute (SelectedActivityCounts=0 column count and data not match).
* 218862: Case Analysis returns incorrect Start and End times when start or end transition is selected.
* 218847: Variation Analysis Include Only Cases Filter Fails when using Event Counts and filter.
* 218765: Event Occurrence Time calculation for KPI analysis (Server side).
== QPR ProcessAnalyzer 2019.1 (release date 2019-01-03) ==
Build number: 2019.1.0.38310, Model compatibility version: 2, Database version: 58, PACM file version: 7.
'''Release Highlights''':
* There are new training videos available for QPR ProcessAnalyzer in QPR Community. QPR ProcessAnalyzer users can access the videos by clicking Training Videos in the header menu of QPR ProcessAnalyzer UI.
* ChartView can show several measures at the same time. In table, measures are in different columns, and in chart, measures are presented as different series.
'''Fixed bugs for QPR ProcessAnalyzer UI:'''
* 218768: Number of decimals is not updated in KPI analysis due to HistoryId context variable.
* 218787: Datagrid export fails with numerical values.
* 218757: KPI analysis - null value shown as NaN.0 in table.
* 218794: Popup menu is replicated when PAPO is drawn multiple times.
* 218740: Case Analysis Year period should not show thousand separator.
* 218805: Analysis not shown after adding duration analysis to panel using view designer "shortcuts buttons".
* 218804: PAPO showing only Analysis Window doesn't show anything when other PAPO hides the Analysis window.
* 218815: Flowchart influence analysis does not always show the results in an identical way.
* 218791: Flowcharts visibility stepper don't work in PA deployment package Process benchmarking view.
* 218844: KPI Analysis sorting is not saved to the context variable.
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218755: If user selects Influence Analysis for Case Attributes into analysis window, it freezes the analysis window completely.
* 218756: PA model - with event attributes - without case attributes = event attributes shown in profiling case attributes analysis.
== Old Releases ==
See older releases in [[QPR ProcessAnalyzer Release Archive]]
__NOTOC__
__NOTOC__


[[Category: QPR ProcessAnalyzer]]
[[Category: QPR ProcessAnalyzer]]

Latest revision as of 15:56, 6 February 2025

This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.

Next Release: QPR ProcessAnalyzer 2025.2 (planned release 2025-03-04)

See plan for next release features and fixes

Latest Release: QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)

New features presentation: QPR_ProcessAnalyzer_2025_1.pdf

New features

  • B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
  • B-08530: Charts can have a description text which are shown in a dialog when pressing the info button.
  • B-08546: Added LlmComplete function to access Snowflake Cortex large language models.
  • B-08439: Added project settings DatabaseNameInDataSource and SchemaNameInDataSource to define Snowflake database and schema.
  • B-08531: Projects can be created in expression language using CreateProject function.
  • B-08387: Added backend support for object-centric model filtering for object attributes.

Fixed issues

  • D-14339: Week numbers showed incorrect year for last dates in the end of year.
  • D-14323: Filtering with "Split data by filtering" dimension didn't work with exclude type of filter rules and when there were multiple filter rules.
  • D-14346: Fixed issue where manual activation using activation utility didn't work.
  • D-14326: Fixed issue where extra columns in objects table broke object-centric model.
  • D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
  • D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
  • D-14331: Flowchart lost selection when flowchart used linked variables with array values.
  • D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
  • D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
  • D-14342: Flow step and Zoom settings control have same size and layout is aligned.
  • D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
  • D-14327: AI Assistant had console error when pressing send button without text.
  • D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
  • D-14321: Added error message for AI Assistant when trying to use it without model selected.

Other improvements

  • B-08391: Datatable access has been optimized improving performance for object-centric models.
  • B-08529: Added support for array type in stringified value format.
  • B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
  • B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
  • B-08544: Frontend components have been updated.
  • B-08561: Updated translations for release 2025.1.

Release: QPR ProcessAnalyzer 2024.8 (build 8937) (released 2024-12-11)

Known issue: There may be old invalid models which don't work with QPR ProcessAnalyzer 2024.8. The following query can be run in the Expression Designer (with System administrator user) to list such models: 

Models.Where(!IsOcelModel && Configuration.TryGetValue("DataSource").TryGetValue("Events").TryGetValue("DataSourceType") == _EMPTY).(Project.Name + ": " + Name + " (" + Id + ")")

Those models don't have a valid datasource defined and thus they are likely not is use. Easiest solution is to delete those models with following command: 

ModelById(<id>).DeletePermanently()

SQL Server database compatibility level needs to be at least 130 (corresponding to SQL Server 2016) for databases used by QPR ProcessAnalyzer. When using a supported version of SQL Server, the database compatibility level might still be unsupported, so please check to used compatibility level. It's recommended to set the highest available compatibility level. More information: https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.

External content component doesn't allow to embed websites from other origins than the QPR ProcessAnalyzer server. This is due to a change in the Content security policy (CSP) HTTP header (more information: Security hardening). The content security policy HTTP header can be modified in the appsettings.json file. More information about the same-origin policy: https://developer.mozilla.org/en-US/docs/Web/Security/Same-origin_policy.

QPR ProcessAnalyzer now uses the Microsoft.Data.SqlClient library for SQL server connection instead of the System.Data.SqlClient library, and there are slight differences with the connection string parameter default values. If using a self-signed certificate in the SQL Server with the encrypted connection, it might require to add TrustServerCertificate=True to the connection string, so that QPR ProcessAnalyzer will trust the self-signed certificate and allow the database connection.

Project Designer and Administrator roles can now create models and datatables in the project. Earlier these operations required the global Create models role. This global role is now renamed to Create projects, describing its new purpose.

Features

  • B-08395: Added native object-centric flowchart showing predefined measures.
  • B-08396: Object attributes are now available as case attributes in object-centric perspective.
  • B-08449: Snowflake Native App supports project-specific database, schema, and warehouse.
  • B-08432: Decision intelligence event log prediction and simulation has been integrated into QPR ProcessAnalyzer.
  • B-03062: Project Designer and Administrator roles can now create models and datatables, and global "Create models" role changed to "Create projects".
  • B-08471: Model properties dialog has been simplified for Native App to exclude in-memory model datasources.
  • B-08504: Charts don't automatically change case/event attributes and event types when encountering non-existing selections.
  • B-08522: Optimized Snowflake queries that do not need event data.
  • B-08454: Optimized SQL executed in Snowflake by removing unnecessary column type casts.
  • B-08507: Migrated tables for scripts and script logs to Entity Framework.
  • B-08519: Migrated user management tables to Entity Framework.
  • B-08539: Migrated model, project and filter tables to Entity Framework.
  • B-08514: Updated translations for release 2024.8.
  • B-08515: Frontend components have been updated.
  • B-08513: Backend components have been updated.

Fixed issues

  • D-14320: On-screen setting didn't work when "dynamicType" is "DataTablesOfProject".
  • D-14221: Content-Security-Policy HTTP headers allows only same origin for iframes, and X-Frame-Options HTTP header removed.
  • D-14317: Model statistics system report gave error about invalid expression.
  • D-14286: Fixed issue in model import which sometimes created partially configured model.
  • D-14315: Filtering for custom dimensions didn't work, if expression refers to measures with variables.
  • D-14302: "let" statement did not work in #expr-block embedded into SQL expression.
  • D-14303: Flowchart lost selection when flowchart used linked variables.
  • D-14311: Fixed issue were dashboards were not visible in iPhone.
  • D-14301: Filtering from "First event attribute value" and "Last event attribute value" columns did not work.
  • D-14314: Fixed error in BPMN editor when object-centric model didn't have perspective defined.
  • D-14297: Native App incorrectly cached OAuth token causing "OAuth access token expired" errors.
  • D-14248: Improved error message "Unable to read event log data from external source without specified sample size".
  • D-12402: Fixed issue where flowchart start/end flows didn't start from middle of start/end symbols.
  • D-14293: AI Assistant didn't work with object-centric models.
  • D-14295: Fixed issue where authentication was not possible if PA_ROLE table contained roles with ROL_FLAGS field having NULL values.
  • D-14245: When dialog was opened in Workspace, console showed following error: "Blocked aria-hidden on a <button> element because the element that just received focus ...".

QPR ProcessAnalyzer 2024.7 (build 8234) (released 2024-10-29)

If using local datatables (stored in SQL Server), the SqlServerConnectionString setting is now mandatory. Starting from QPR ProcessAnalyzer 2024.7, local datatables cannot be created if the setting is not configured. It's recommended to have a separate database for the datatables data, but it's also possible to configure the same connection to the SqlServerConnectionString setting as for the configuration database (in appsettings.json). See System Architecture for more information about the data storage.

Check whether there are custom roles in the database (table PA_ROLE) which have the ROL_FLAGS field set to NULL. The NULL values don't work with this release, so set a correct value (either 1, 2, or 3). Following query can be run in the database showing roles which have an incorrect ROL_FLAGS field: 

SELECT *
FROM [PA_ROLE]
WHERE [ROL_FLAGS] = NULL;

Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.11. Old versions of the functions use Python 3.8 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications emails about existing deprecated functions. It's recommended to remove the old functions which are following:

  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
  • QPRPA_UDTF_CLUSTER
  • QPRPA_UDTF_CLUSTER_V2
  • QPRPA_UDTF_CLUSTER_V3
  • QPRPA_UDF_BPMN_IS_CONFORMANT
  • QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS

Features

  • B-08458: Object-centric perspectives can be stored as filters and object-centric model can be selected for dashboard.
  • B-08472: Snowflake filter cache tables are now created in background to improve performance.
  • B-08452: Limited sampled cases to 10000 in Snowflake and in-memory clustering presets.
  • B-08430: Improved Snowflake flowchart performance by calculating variations using sampling.
  • B-08446: QPR ProcessAnalyzer can be deployed as Snowflake application package to publish it as a native app.
  • B-08418: QPR ProcessAnalyzer has been integrated into Snowflake authentication for Snowpark Container Services.
  • B-08420: Legacy "Local" datatables cannot be created anymore - only separate SQL Server database is supported (see release note above).
  • B-08437: Snowflake cache is now bypassed for queries that have caching disabled.
  • B-08443: Improved object-centric models performance by optimizing perspective generation.
  • B-08450: Updated Snowflake UDF's python version from 3.8 to 3.11 (see release note above).
  • B-08425: Migrated nine configuration data tables to use Entity Framework.
  • B-08334: Removed legacy functionality related to models.
  • B-08337: Removed legacy functionality related to roles.
  • B-08456: Frontend components have been updated.
  • B-08477: Backend components have been updated.
  • B-08478: Updated translations for release 2024.7.

Fixed issues

  • D-14263: Filtering with case id caused error when Snowflake model didn't have case attributes datatable.
  • D-14256: Workspace showed progress spinner forever if trying to remove rows from table where there is no access.
  • D-14250: "Show in Query Designer" button didn't show full query sent to server.
  • D-14285: Non-breaking spaces didn't work in json fields.
  • D-14278: Workspace models list showed linked cases/events datatable even though datatable didn't exist.
  • D-14251: Aggregations list in Combined measure/dimension/column incorrectly showed aggregations for all data types.
  • D-14257: Exporting datatable with no columns froze loading spinner.
  • D-14188: Script incorrectly aborted after error occurring in the import phase of client-side import.
  • D-14275: Several "Loop percentage" event measures caused flowchart error.
  • D-14259: Removed malfunctioning undo/redo operations from Design diagram.
  • D-14260: Design diagram toolbar incorrectly scrolled to left when diagram was zoomed.
  • D-14262: Opening version information caused javascript error if backend communication failed.
  • D-14271: None aggregation didn't work with some Statistical calculations.
  • D-14283: BPMN editor toolbox has now correct font.
  • D-14280: Dashboard component stacking order buttons didn't work if dashboard had z-indeces with gaps.

QPR ProcessAnalyzer 2024.6 (build 7414) (released 2024-09-18)

Features:

  • B-08366: Frontend for OCPM model configuration and Snowflake charts using perspectives.
  • B-08365: Added following visual settings for KPI Card: font size, text color, text styles, vertical and horizontal alignment.
  • B-08382: Measures, dimensions and columns can be duplicated in chart settings.
  • B-08381: Table vertical scrollbar is now hidden when table is not scrollable.
  • B-08355: Expression language identifiers are primarily assumed as variables and secondarily as property names.
  • B-08402: QPR ProcessAnalyzer can now connect to Snowflake when running in Snowpark Container Services.
  • B-08389: Added support for making multiple Snowflake queries in same request for OCPM queries.
  • B-08416: Improved backend functionality for partially configured OCEL models.
  • B-08428: Improved Snowflake calculation performance by including to filter cache tables only the event table key (this behavior can be opt-in with a CacheOnlyPrimaryKeysForFilters setting).
  • B-08448: Add configuration to disable event cache tables storing primary key only.
  • B-08340: New users don't have a default model selected when login for the first time.
  • B-08413: Frontend components have been updated.
  • B-08397: Backend components have been updated.
  • B-08398: Updated translations for release 2024.6.

Fixed issues:

  • D-14209: Fixed issue where moving projects in Workspace was not possible.
  • D-14186: Highcharts visualizations datalabel texts were incorrectly shown over tooltips.
  • D-14210: Fixes for issue with incorrectly shown pending tasks in System Reports.
  • D-14242: SqlDataFrame Persist function now keeps the original column types even if they are changed.
  • D-14147: Snowflake queries gave "Object reference not set to an instance of an object" error with MaximumRowCount higher than 2 billion.
  • D-14189: Dropdown list component gave following error when clicking Add button for "List items": Cannot read properties of undefined (reading 'axisLabel').
  • D-14192: Datagrid paging settings are now preserved when resizing or zooming window.
  • D-14214: In System reports, dropdown list showing dashboards didn't open if there were more than 1000 dashboards.
  • D-14218: CSV file import didn't detect existing column correctly when there was difference only in letter case.
  • D-14184: Giving ScriptText or ScriptFileName as parameter for QPR ScriptLauncher created a broken script.
  • D-14220: AI assistant gave strange error message when trying to explain chart showing error.
  • D-14135: Expression based Snowflake filter rule caused error "Object reference not set to an instance of an object".
  • D-14229: In Snowflake, disabled filter rules didn't affect header object counts when there were several filter rules.
  • D-14228: In Models and Model statistics reports, columns showing case and event attributes didn't work.
  • D-14213: In User Settings dialog, Effective Permissions settings are now preserved while dialog is open.
  • D-14227: Fixed issue where applying chart settings in System reports made settings pane empty.
  • D-14185: Stack traces were incorrectly returned even if IncludeExceptionDetailsInErrors was false.
  • D-14226: Fixed several OCPM calculation related issues in backend.
  • D-13943: Added error message to Case attribute selector when model doesn't have selected case attribute.
  • D-14162: Expression "0.()" gave null reference error.
  • D-14246: Chart setting dialog may have been partly out of screen when activating other chart while in dashboard is scrolled.
  • D-14238: Snowflake chart measure aggregation is incorrectly affected by statistical calculations.
  • D-14133: In Snowflake chart, events Aggregate settings caused JaveScript error and UI messed up.
  • D-14172: Fixed issue where validation error appeared when copying and moving elements in Design Diagram.
  • D-14253: Table didn't show column filter icon when column name was empty.

Additional release for QPR ProcessAnalyzer 2024.5 (build 6814) (released 2024-07-01)

Known issue: It's not possible to move projects that existed before updating to this release. The issue will be fixed in the next release. There is a following workaround available: Administrator user can go to the Expression Designer and run the following expression: Projects.Modify(#{}).

Fixed issues:

  • D-14191: Running script by id failed on data import when parameters contained ScriptId.
  • D-14183: Fixed issue where flowchart SVG export only exported the visible part of flowchart.

Additional release for QPR ProcessAnalyzer 2024.5 (build 6769) (released 2024-06-27)

Features:

  • B-08388: Added backend support for OCPM model perspectives to convert object-centric eventlogs into case-centric.

Fixed issues:

  • D-14187: Creating local datatables was not possible in Workspace if datatables were stored to the configuration database (i.e., SqlServerConnectionString setting is not used).

QPR ProcessAnalyzer 2024.5 (build 6746) (released 2024-06-25)

Features:

  • B-08338: Added reports to monitor dashboards usage: Popular dashboards, Dashboards by users and by time, and specific dashboard usage.
  • B-08314: Snowflake connection string can be specified for each project to allow projects connecting to different Snowflake accounts, databases or schemas.
  • B-08341: Added GetRelatedValueFrom and AggregateRelatedValueFrom SQL expression functions to extend models with data from additional tables.
  • B-08301: In chart settings, selecting another measure/dimension/column now doesn't reset settings.
  • B-08317: Added Snowflake presets for Root Causes for Attributes in table and detailed table format.
  • B-08318: Improved Snowflake Events preset performance by adding a filter that picks a subset of cases.
  • B-08385: Open AI default large language model has been changed to "gpt-4o".
  • B-08342: Added DashboardName and DashboardProjectName properties to OperationLog in expression language.
  • B-08320: Added RenameAllColumns function to dataframes to easily rename all columns.
  • B-08321: Added DataSourceConnection property to dataframes in expression language.
  • B-08307: Finetuned Workspace functionality for models that don't have datasource defined.
  • B-08329: Optimized metadata queries to Snowflake to improve performance.
  • B-08311: Changed QPR ScriptLauncher interaction with the server by changing long polling to short calls to improve robustness.
  • B-08368: Implemented backend support for configuring and importing OCPM models.
  • B-08352: Frontend components have been updated.
  • B-08348: Backend components have been updated.
  • B-08349: Updated translations for release 2024.5.

Fixed issues:

  • D-14150: Charts temporarily showed as too large when resized with non-zero chart margin values.
  • D-14058: Login page is not anymore shown when SAML authentication is configured and user is directed to the identity provider.
  • D-11579: Column filter menu in tables can now appear outside the table area which is useful in small tables.
  • D-14144: Fixed issue where Snowflake clustering failed if there were date type of case attribute with null values.
  • D-14163: Non-breaking spaces appeared strangely as "&nbsp;" in Highcharts charts.
  • D-14132: Snowflake model object counts were not shown when opening dashboard while model metadata was still loading.
  • D-14142: CreateDataTable function incorrectly deleted all source datatable content if connection included source datatable name.
  • D-14161: Fixed issue where Append function in SqlDataFrame broke source data.
  • D-14157: AI Assistant didn't show detailed error message when OpenAI query failed.
  • D-14137: AI Assistant incorrectly appeared on top of chart in the fullscreen mode.
  • D-14170: Toolbar dropdown lists didn't work when dashboard contained more than one Design Diagram.
  • D-14146: Fixed error "Unable to get on-premise gateway named..." when running script from SQL script using QPR ScriptLauncher.
  • D-14106: Having only a template string in the #expr{...} block didn't work.
  • D-14008: "Root Causes contribution" and "Comparison eventlog cases percentage" columns didn't work (in-memory).
  • D-14010: Occurrences of specific flow measure didn't work with the Root causes analysis weighting expression (in-memory).
  • D-14148: Root causes for case duration preset didn't support Multi-unit time settings.
  • D-14139: Added info message when successfully exporting model to pacm file.
  • D-14153: Fixed in-memory measures for "Flow duration" and "Occurrences of specific flow" which failed when selected flow didn't exist.
  • D-14167: Fixed issue where ScriptLauncher sometimes terminated prematurely on exceptions occurring in on-premise import.
  • D-14165: Flowchart export file name was incorrect and exported flowchart background was always transparent.
  • D-14160: Fixed issue where DashboardId wasn't recorded to operation log when opening dashboard by identifier (DashboardsController.GetByIdentifierPath).
  • D-14159: IsHidden property didn't work in in-memory Value expressions.
  • D-14131: Some popup messages had incorrect html escaping.
  • D-14151: Fixed issue where flowchart might have given browser console error when clicking event types or flows while still loading data.
  • D-14022: In System reports, numeric aggregations which don't work in SQL Server are now hidden.
  • D-14129: Imported model name was incorrectly cut if it contained dots.

QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14)

Features:

  • B-08227: Dashboards have AI Assistant (powered by ChatGPT) helping users in process analysis. AI Assistant can answer general questions about the process, create filters based on user prompt, and explain charts and analyses.
  • B-08277: QPR ProcessAnalyzer now detects automatically when cases or events data in Snowflake updates. Check is done every 5 minutes which is the maximum delay of detecting new data. (more information)
  • B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
  • B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
  • B-08276: Adjusted permissions for moving projects.
  • B-08310: Added Details property to Exception object in expression language.
  • B-08328: Language translations have been updated to 2024.4.
  • B-08312: Frontend components have been updated.
  • B-08308: Backend components have been updated.

Fixed issues:

  • D-14084: Filter rule for first and last event in case couldn't be edited if there were more than one event selected.
  • D-14091: Duration multi-unit didn't work in big data chart.
  • D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
  • D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
  • D-14107: Snowflake model that has earlier been an in-memory model showed case count and estimated memory incorrectly.
  • D-14074: Fixed issue in QPR ScriptLauncher when calling the script from other script.
  • D-14104: Fixed expression language parsing issue with in-memory DataFrame and filter using "In" function.
  • D-14121: Datatable UpdateRows function now supports column names given as expressions.
  • D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
  • D-14123: There was an error of unable to get on-premise gateway when using ExtractSap function in expression language script from SQL script called from expression language script.
  • D-14128: Table without title was incorrectly exported as .txt file.
  • D-14112: Convert to custom expression button didn't work in design diagram.
  • D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
  • D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed in chart settings.
  • D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
  • D-14096: Highcharts tooltip square icons were slightly misaligned.
  • D-14099: There was a console warning when opening the business calendar dialog.
  • D-14118: Design diagram sometimes gave following JavaScript error: Cannot read properties of undefined (reading 'parentNode').
  • D-14024: If quickly logging out after changing model, the model change might not be been saved.
  • D-14120: User.getAttribute function returned values from incorrect context.
  • D-14102: Pivot table cannot read properties of undefined.
  • D-14161: SqlDataFrame.Append breaks the used source SqlDataFrames

QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)

Features:

  • B-08024: Design diagram has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
  • B-08242: Script based actions can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
  • B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
  • B-08288: Added expression language functions to start and stop scripts.
  • B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
  • B-07906: Implemented cross joins to SQL dataframes.
  • B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
  • B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
  • B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
  • B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
  • B-03047: Removed support for dashboard panels.
  • B-08214: Removed unused columns from the PA_VIEW table.
  • B-08254: Frontend components have been updated.
  • B-08255: Backend components have been updated.
  • B-08233: Language translations have been updated to 2024.3.

Fixed issues:

  • D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
  • D-14035: In design diagram, BPMN event and gateway symbols are now circular.
  • D-14049: Added some missing translations for table column filter and BPMN editor.
  • D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
  • D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
  • D-13976: Fixed issue where gateway-based imports were not synchronous.
  • D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
  • D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
  • D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
  • D-14071: Business calendar button press caused error when user didn't have access to any model.
  • D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
  • D-11268: There were inconsistent button colors in Workspace.
  • D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
  • D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
  • D-14081: Fixed null references error when logging null in expression script.

Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)

Features:

  • B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.

Fixed issues:

  • D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.

QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)

The legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., Models.Filters and RoleAssignments property.

New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).

Features:

  • B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
  • B-08232: Entire future eventlogs can be predicted based on generative AI models running in Snowflake.
  • B-08166: Added expression language function OpenAIChatCompletion to answer natural language prompts based on OpenAI ChatGPT API.
  • B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
  • B-08196: Conditional formatting rules can be defined for textual and boolean values.
  • B-08213: Big data chart expressions event type selections to be multi-select where applicable.
  • B-08205: Expression language API is available for storing secrets for scripts.
  • B-07780: Chart variable mappings has been removed - use the linked settings instead. Dashboards using variable mappings are automatically converted to use linked settings.
  • B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
  • B-08174: Only non-default parameters values are written to the operation log.
  • B-08200: Timestamps in System reports are shown in user workstation local time.
  • B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
  • B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
  • B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
  • B-08202: Updated copyright for year 2024.
  • B-08199: Frontend components have been updated.
  • B-08203: Backend components have been updated.
  • B-08209: Translations updated for release 2024.2.

Fixed issues:

  • D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
  • D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
  • D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
  • D-13962: System variable values were interpreted incorrectly when used in linked settings.
  • D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
  • D-13959: Removed possibility to add datatable columns with the legacy "any" data type.
  • D-13991: Improved drop-down selector component to handle empty strings as variable values.
  • D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
  • D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
  • D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
  • D-13960: Added missing translations for list of permission list and 12-hour clock format.
  • D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
  • D-13969: Datatable column schema export sometimes showed empty for the key column.
  • D-13862: Session token was not accepted when url path capitalization is different.
  • D-13942: Datatable could not be dimensioned if it has column named "CaseId".
  • D-13980: Business calendar dialog crashed when tried to open it for a model without access.
  • D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
  • D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
  • D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
  • D-13977: Multi-select dropdown lists showed some special characters incorrectly.
  • D-13945: Syncfusion toast message didn't work when text contains ${[]}.
  • D-13930: Pivot table throws javascript error when certain clicks.
  • D-13273: Duplicate datatable row count didn't shown correctly.
  • D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
  • D-13985: Models list dots menu had texts misaligned in narrow screens.
  • D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
  • D-13997: Workspace tables column filtering search caused JavaScript errors.
  • D-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
  • D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
  • D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
  • D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
  • D-14004: Removed empty filters from queries to optimize them.
  • D-13988: Fixed issue where data grid context menu rendered initially as too high.
  • D-13979: BPMN model editor element settings use now Open Sans font.
  • D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
  • D-13984: Fixed the error of refusing to run the JavaScript URL.
  • D-14031: ThrownObject property was not included to http error response when error came from the script.

QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10)

QPR ProcessAnalyzer Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime (see more). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.

In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.

Features:

  • B-08019: New component Design Diagram for showing user-created diagrams in dashboards where to visualize process mining metrics.
  • B-08087: Generic dropdown list selector works with Snowflake models allowing to add selection lists for any values.
  • B-08163: Linked settings support for binding to case attribute filter values without defining case attribute name.
  • B-08170: Snowflake model filters can be saved as new models which can be used to create snapshots of part of models.
  • B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
  • B-08161: Added Modify function to change datatable properties and improved CreateDatatable function for creating datatables.
  • B-08122: Added new system report to list dashboards.
  • B-08173: Removed legacy filters that didn't have any filter rules.
  • B-07961: In OperationLog, changed parameters to json format and added request id.
  • B-08069: Added DashboardId property to OperationLog in expression language.
  • B-08139: Added UpdateRows function to update existing rows in datatables with similar logic than SQL update.
  • B-08115: Added DeleteRows function to delete rows in datatables with similar logic than SQL delete.
  • B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
  • B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
  • B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
  • B-07689: For datatables, foreign keys to other datatables can be defined using expression language.
  • B-08176: Translation updates for release 2024.1.
  • B-08175: Workspace should show timestamps in user's local time.

Fixed issues:

  • D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
  • D-13916: Chart filter could not be defined for some expressions in Big data chart.
  • D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
  • D-13906: In Conformance Analysis, deviating flows were not translated.
  • D-13907: Improved translation related to datatable properties dialog "Used by models" field.
  • D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
  • D-13911: Fixed small glitches in the opening and closing of drop-down lists.
  • D-13918: Datatable could be configured incorrectly to use table for other datatable.
  • D-13932: Duplicating datatable with custom table in datasource losed all data.
  • D-11002: Removed legacy in-memory prediction preset.
  • D-13912: Added check that array cannot be stored to dashboard Content property.
  • D-13936: Query designer default query didn't work with Snowflake models.
  • D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
  • D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
  • D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
  • D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.

Old Releases

See older releases in QPR ProcessAnalyzer Release Archive

Retrieved from "https://wiki.onqpr.com/pa/index.php?title=QPR_ProcessAnalyzer_Release_Notes&oldid=25819"