QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
 
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.7 (planned 2025-11-11) ==
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]


'''Notes:'''
== Latest Release: QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 1em 1em;background-color:#ffcdd3;margin:10px 0px 0px 10px;">
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_6.pdf QPR_ProcessAnalyzer_2025_6.pdf]
Support for the legacy models is dropped in QPR ProcessAnalyzer 2020.7, and the models need to be converted to the new datatable-based models before updating to QPR ProcessAnalyzer 2020.7. You can check the model type as follows: Open QPR ProcessAnalyzer Web UI, open the models dropdown list in the header, find the 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 conversion.


The conversion can be done as follows:
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
# In QPR ProcessAnalyzer Web UI, export the model as a .pacm file by clicking ''Export Model'' in the ''Model Properties'' (in the ''Actions'' tab).
Known issue: If the [[PA_Configuration_database_table#:~:text=DefaultUiLanguage|DefaultUiLanguage]] system configuration is not defined, users who haven't changed their own language, are unable to login. To prevent this problem, please ensure the DefaultUiLanguage is defined. The next release will fix this issue (D-14706).
# Go to the ''Datasources'' tab, change the ''Load from Database'' from ''Yes'' to ''No'', and change the ''Cases'' ''Datasource'' to ''Datatable''. The ''Events'' ''Datasource'' is already correct.
# Import the .pacm file back to the same model using the ''Data Import'' in the navigation menu. In the import form, select ''Import to Existing'' model and choose the model. Checkbox ''Add to existing data'' can be in either position.
 
Notes regarding the conversion:
* Exporting and importing operations might take long time for very large models.
* Model id's are not changed in the conversion.
* Original filters and their id's are preserved but new duplicate filters are created during the import (which can be deleted).
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
[[QPR_ProcessAnalyzer_Version_Compatibility|Excel Client protocol version]] is changed which requires to update QPR ProcessAnalyzer 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]].
Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:
* object-src 'none'
* frame-ancestors 'self'
* form-action 'none'
* base-uri 'none'
* worker-src blob:
 
These new restrictions may affect usage that has previously been possible. For example, with the new settings, QPR ProcessAnalyzer can be embedded to a website only within the same origin. For detailed instructions on embedding QPR ProcessAnalyzer on a different website, please refer to [[Embed_to_Website|this quide]]. Additionally, for information on modifying the CSP settings, see documentation for [[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|security hardening]].
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
The version numbering of QPR ProcessAnalyzer has changed, and now releases are identified using a simple version number instead of the previous version format (e.g. 2020.6.0.42152). The version number can be seen in the ''User Settings'' in the main navigation menu.
In the QPR ProcessAnalyzer 2025.6 Native App, the release version number is not displayed correctly in the User Settings dialog. This omission does not have any other complications. QPR ProcessAnalyzer 2025.6 is the only release with this issue, making it possible to identify this release despite the missing version number. This issue is specific to the Native App only. The next release will fix this issue (D-14703).
</div>
</div>


'''Features:'''
===New features===
* 308003: Disabling filter rules.
* [[User_Settings#Starting_dashboard|Starting dashboard]] after login can be defined for user groups, allowing to create customized starting pages for easy navigation. (B-08791)
* 308021: Dimension specific maximum number of items.
* Snowflake [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|chart's event filters]] are now embedded to filters created from chart, to precisely follow chart calculation. (B-08845)
* 308006: KPI card customizable colors.
* Result data can be filtered in Snowflake charts using [[QPR_ProcessAnalyzer_Chart#:~:text=Result%20filtering%20expression|result filtering expression]] which works for any datasets. (B-08751)
* 308009: Color mappings to dimensions.
* Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* 307987: Navigation menu width is set based on dashboard names.
* Added model setting [[QPR_ProcessAnalyzer_Project_Workspace#Hiding_Object_Count_Statistics|Show object count statistics]] to hide object counts information in dropdown lists to optimize performance. (B-08849)
* 308008: Chart specific model selection.
* Added support for [[Chart_On-screen_Settings#:~:text=showStatistics|hiding statistics for on-screen setting]] dropdown lists to improve performance, and in addition the case ID is hidden Case/Event attribute profiling presets. (B-08840)
* 308017: Remove left and right axis synchronization in Chart.
* Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
* 307995: Ending tasks in web UI.
* Snowflake Native App: Added procedure to that [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Recover_administrator_access|creates administrator user to Native App]] if access to the app has been lost. Also, prevented user management operations that remove own access. (B-08733)
* 307993: Adjust model size estimate + filter rule editor refactoring.
* Snowflake Native App: Added procedure to [[Change_Native_App_Compute_Pool_Size|change Native App compute pool size]]. Changed new Native Apps to use CPU_X64_S size compute pool, and improved Native App stability. (B-08859)
* 308018: Bottleneck identification and optimizations for models having lots of cases.
* 307994: Take into use functions stdev, stdevp, var and varp in Chart.
* 308016: Migrate Chart pivot to Syncfusion JS2 PivotTable.
* 307805: Syncfusion JS2 migration - part 1.
* 307976: Angular migration finalization.
* 308025: QPRLibraries migration to Syncfusion JS2.
* 307939: Remove manually updated version numbers.
* 308005: Remove "Dimensions/columns as calculated attributes" and "Chart settings (compacted)" from chart.
* 307999: Remove legacy model settings from model properties.
* 308020: Change default bpmn model to empty.
* 307758: Standard deviation, sample standard deviation, variance and sample variance to expression language.
* 307992: In Conformance root causes view, replace datagrid with a chart.
* 307759: Add requirements and tests to mathematical functions from NCalc.
* 307879: Optimize preprocessing for model event log.
* 307916&308010: Drop support for legacy models.
* 308007: "On-screen settings follow flow selection" to work for all start and event event type selections.
* 308030: Change password changing to use /api/users/password.
* 307989: Expression language: Dictionary.Clone-function and improvement to generic ToDictionary and ToDataFrame functions.
* 308029: Revision number in UI.
* 308004: Expression designer results field should be editable.
* 307996&308012: Translation fixes.
* 307954: Web API for datatables.


'''Fixed issues:'''
===Fixed issues===
* 219429: Chart case attribute dropdown list item count did not match with the chart presentation.
* Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
* 219487: When moving and resizing, presentation objects should be aligned with each other and with the canvas.
* When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
* 219472: Improvements to model and data table loading slowness and memory usage.
* Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
* 219465: "Case/event attribute not found" error messages improved.
* Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
* 219474: Filter rule text said "undefined" for some expression based filters.
* In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
* 219462: User could not fix incorrect chart settings.
* Event type mapping in charts didn't work in object-centric models. (D-14620)
* 219471: "All cases" option was not visible when changing between models that don't have filters.
* Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
* 219488: Filter selection should be cancelled when changing dashboard.
* Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
* 219494: Duration values in flowchart were sometimes rounded incorrectly.
* Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
* 219484: Alignment of dashboard objects was difficult.
* In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
* 219502: When clicking same Case attribute/Event attribute preset again, loading animation staid for ever.
* Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
* 219481: Stdev, stdevp, var and varp functions should return null when there are zero or one items in the array.
* Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
* 219496: Series should be stacked bottom-to-top and from-left-to-right in charts.
* Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
* 219499: Chart colors were reset to default when resizing window.
* Translation was missing from error messages when deleting items from recycle bin. (D-14652)
* 219480: Attribute+Variation filter resulted in zero cases.
* Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
* 219479: SAML login redirection replaces contains http even if https is configured.
* Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
* Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
* Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
* Fixed incorrect data types in some project, user and group related measures. (D-14619)
* Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
* Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
* Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
* Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
* Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
* Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)


== Latest release: QPR ProcessAnalyzer 2020.6 (release date 2020-08-18) ==
===Other improvements===
Build number: 2020.6.0.42152, Model compatibility version: 3, Database version: 74, PACM file version: 7, Protocol version: 33. ([[QPR_ProcessAnalyzer_Version_Compatibility|see more]])
* Added QPR ProcessAnalyzer API request ID to Snowflake queries to easily find matching query in Snowflake query history. (B-08839)
* [[QPR_ProcessAnalyzer_Security_Hardening#Added_HTTP_Headers|Content Security Policy HTTP header]] includes now object-src, frame-ancestors, form-action, base-uri, and worker-src. (B-08794)
* Snowflake queries have been optimized by removing null and empty string checks from mapped columns as they are now handled by the model validation check. (B-08837)
* Added backend support for object-centric model filtering based on case-centric filter rules. (B-08836)
* Frontend components have been updated. (B-08851)
* Backend components have been updated. (B-08852)


'''Features:'''
== QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21) ==
* 307918: Localization for Russian, Spanish, German, Finnish and Swedish.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.pdf]
* 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.
* 307982: Changes to showing model last imported date and additional information to Model Properties dialog.
* 307983: Editing calculated case and event attributes.
* 307980: Chart setting "On-screen Settings Follow Flow Selection" to freeze chart from reacting to flow selection.
* 307824: Expression language function improvements (IndexOf, LastIndexOf, ToString, ParseDateTime, First, Last).
* 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:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219388: Old data comes to dashboard when data imported to datatable.
When using Snowflake Cortex, the AI Assistant is not showing the results table in the assistant's response. This issue has been fixed by the next release.
* 219412: No scrollbar for both error message and web UI window.
</div>
* 219414: Error message appears in Clustering Analysis for model with zero events and cases.
* 219419: QueryIdentifier should be excluded from client side query cache.
* 219426: Script editor cannot save changes in 2020.5 version.
* 219430: Filtering does not work in PAPO Cases and Event Types when using French.
* 219431: PAPO Events and Root Causes not working when using French.
* 219435: Dialogues have small layout issue.
* 219441: Deletion does not work correctly in folders screen when selecting using shift+ctrl-click.
* 219160: Hidden case attributes are visible in profiling case analysis, and in Influence Analysis for case attributes settings.
* 219418: Missing translations for the Clustering analysis.
* 219446: JavaScript error when closing dialog using the X button.
* 219444: Deselecting selected item by re-clicking it will not hide the selection buttons in Chart and generates an error in browser console
* 219449: Prediction fails with certain small models.
* 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) ==
===New features===
Build number: 2020.5.0.41888, Model compatibility version: 3, Database version: 73, PACM file version: 7, Protocol version: 33. ([[QPR_ProcessAnalyzer_Version_Compatibility|see more]])
* [[Object-Centric_Flowchart|Object-centric flowchart]] can also use object-to-object relations to link events and objects simplifying event-to-object configuration. (B-08671)
* [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] can provide precise quantitative analysis by making queries to eventlog data (powered by Snowflake Cortex Analyst and Agents). (B-08652)
* [[Filtering_in_QPR_ProcessAnalyzer|Flows and variations can be filtered]] from any event attribute viewpoint in Snowflake. (B-08737)
* Added [[Project_Properties_Dialog|project properties dialog]] for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
* [[QPR_ProcessAnalyzer_Project_Workspace#Validating_Model|Model validity check]] easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
* Projects can be [[QPR_ProcessAnalyzer_Project_Workspace#Exporting_Project|exported]] to json files and imported as new projects. (B-08717)
* Action buttons can be added to dashboard by defining [[Label_and_Link|label component]] that can change dashboard variables and run scripts. (B-08694)
* Web user interface is available in [[Languages_and_Localization|Ukrainian language]]. (B-08734)


'''Notes:'''
===Fixed issues===
* 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.
* Fixed following error when performing client-side SAP import: Could not find a part of the path (QPR_ImportSource_Chunk_*.tmp). (D-14589)
* 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.
* Fixed issue where ManageProjects permission was incorrectly required when running scripts using QPR ScriptLauncher non-legacy mode. (D-14562)
* Fixed following error when using SAP import from SQL script called from expression language called from SQL: The given key '' was not present in the dictionary. (D-14593)
* Some analyses didn't work, when case ID columns for cases and events datatables differed only in upper/lowercase letters. (D-14556)
* Business calendar didn't work for some measures/dimensions/columns and some had business calendar checkboxes missing. (D-14563)
* Prediction failed to following error: transformer_model_next_activity/event_year_input_embedding. (D-14551)
* Scripting now works correctly after rows from PA_OPERATION_STATUS table have been deleted. (D-14545)
* Fixed issue where case-centric flowchart was very slow for object-centric model. (D-14544)
* Prevented creating dashboards, models and scripts with duplicate names in the same project. (D-09480)
* KPI Card now shows line breaks correctly in textual values. (D-14546)
* Improved table Excel export for list data to show items with separator character instead of showing as JSON. (D-14479)
* Column showing non-conformance reason was incorrectly aligned to right. (D-14570)
* GetRelatedValueFrom function caused column name conflict when used multiple times in same query. (D-14591)
* Fixed issue where in-memory sorting for arrays gave "Error in sorting analysis result rows possibly due to multiple types of values ...". (D-14592)
* Array type of values were shown incorrectly when used Last Row Aggregates Over-limit Rows setting. (D-14616)
* Fixed the "Most common" text aggregation sorting error for in-memory calculation. (D-14573)
* Snowflake model validation gave incorrect error message when mapped column didn't exist in datatable. (D-14565)
* Improved model validation to detect when connection string key for model or datatable does not exist. (D-14607)
* Model validation gave incorrect error when when events datatable case id mapping was missing. (D-14566)
* Model validation gave incorrect error message when cases and events datatables were in different datasources. (D-14567)
* Model validation gave incorrect error message when underlying Snowflake table didn't exist. (D-14568)
* Workspace Card/Table mode toggle buttons were not translated. (D-14547)
* Some invalid queries gave unexpected errors and strange outputs. (D-14569)
* Added translations to model notifications preview table headers. (D-14590)
* Added translations to access denied message for header object counts indicator. (D-13967)
* AI Assistant explaining charts speaks now user interface language. (D-14578)
* AI Agent prompt chart editor didn't show correctly if model was not selected. (D-14536)
* AI Assistant gave "Unsupported cache table type" error when trying to explain object-centric flowchart. (D-14477)


'''Features:'''
===Other improvements===
* 307938: Support for French language.
* When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
* 307868: New dashboard designer that doesn't have panels.
* Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
* 307947: Tables conditional formatting
* Stringified value format supports also json objects. (B-08766)
* 307948: Dashboard properties layout and terminology changes.
* Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
* 307911: IP address verification has been removed.
* Translations have been updated. (B-08757)
* 307931: Expression language and performance improvements (originated from Spark prototyping).
* Frontend components have been updated. (B-08760)
* 307774: Web API operation /api/importfile for data import.
* Backend components have been updated. (B-08759)
* 307933: Default logging mode has been changed to ExclusiveLock for all components.
* 307904: Server side support for UI languages.


'''Fixed issues:'''
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==
* 219372: Issue with simultaneous eventlog processing that caused "Value cannot be null" errors and sometimes calculation with incorrect eventlogs.
* 219375: --#CallWebService didn't work with Content-Type parameter.
* 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) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]
Build number: 2020.4.0.41643, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33. ([[QPR_ProcessAnalyzer_Version_Compatibility|see more]])


'''Notes:'''
===New features===
* 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.
* Added new AI Agent presets analyzing current state and proposing improvements based on different viewpoints, such as Event and Case Counts, Automation, Bottlenecks, and Root Causes. (B-08710)
* 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.
* Added a [[Filter_Selectors#Filter_selector|generic filtering component]] that can be configured for creating any type of filters for distinct values. (B-08654)
* 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.
* Volume declining in measures due to case sampling can be compensated in chart and flowchart by using a [[Measure,_Dimension_and_Column_Settings#Statistical_calculations|Statistical calculation method]]. (B-08598)
* 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")))''.
* In object-centric models, Object ID, Event ID, Event timestamp, and Event type [[Object-centric_Process_Mining_Model#Object-centric_perspectives|attribute names]] are shown correctly. (B-08680)
* 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''.
* Snowflake native app has now [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#User_access_to_application|application roles]] for user (for using app) and administrator (for managing app). (B-08660)
* 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.
* For Snowflake native app, IMPORTED PRIVILEGES ON SNOWFLAKE DB privilege is removed and instead the [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Optional_privilege_for_AI_Agent|CORTEX_USER database role]] can be assigned. (B-08718)
* 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.
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Logging|Native app logging]] has been improved and now sharing application logs with QPR is possible. (B-08661)
* Added [[DataFrame_in_Expression_Language#CsvToDataFrame|CsvToDataFrame]] function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)


'''Features:'''
===Fixed issues===
* 307859: Deployment package dashboards are embedded to QPR ProcessAnalyzer release.
* Fixed "Invalid identifier" error when opening attribute selection list for case attribute preset caused by object id columns which differed only by letter capitalization. (D-14539)
* 307899: RemoveNulls function to remove null values from arrays.
* When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
* 307915: Expression language improvements related to CSV file generation.
* Filters created from dimensions having dimension-specific filter rules will now create expression filter rule where dimensions-specific filter is embedded, for accurately following the selection. (D-14499)
* 307809: When dashboard is opened, editing mode is disabled when no rights to edit the dashboard.
* Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
* 307829: Highcharts, Syncfusion, GoJS and some other components have been updated to their latest versions.
* Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
* 307848: Component updates for building QPR ProcessAnalyzer UI.
* Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
* 307882: JavaScript libraries are split into smaller files in release build.
* In in-memory models, array type of data was not dimensioned correctly. (D-14518)
* 307932: Some PAPO buttons are removed from the tool palette.
* AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
* 307912&307917: ChartView and main header improvements for 2020.4 (parts 1 and 2).
* Table grouping header labels were not formatted correctly. (D-14514)
* Fixed Root causes analysis to work with object-centric models. (D-14515)
* Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
* Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
* Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
* Flowchart SVG export did not show start and end symbols. (D-12401)
* Fixed issue where join operation didn't find renamed columns in SqlDataFrames. (D-14512)
* Improved chart filtering button positions to work with small chart sizes. (D-14509)
* Datatable foreign key columns dictionary data type was incorrect preventing reading columns information. (D-14505)
* Workspace scripts editor allowed to change script code for viewer users (altough not save it). (D-14534)
* In chart custom sorting, trying to refer to measure that had None aggregation, caused SQL compilation error. (D-14526)
* Model validation check crashed when the datatables were in different datasources. (D-14502)


'''Fixed bugs:'''
===Other improvements===
* 219365: Sometimes system stuck during the time models were being loaded into memory.
* Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
* 219326&219377: Datetimes are incorrect in files exported from data grids (time zone difference) (See also the notes above).
* Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
* 219378: ChartView resizing sometimes didn't work when using full screen.
* Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
* 219371: Error messages have been improved for session expired and unknown error.
* Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
* 219360: Some styles were defined twice in CSS.
* Frontend components have been updated. (B-08695)
* Backend components has been updated. (B-08696)


== Additional release for QPR ProcessAnalyzer 2020.3 (release date 2020-04-23) ==  
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==
Build number: 2020.3.0.41450, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.


'''Features''':
===New features===
* 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.
* Navigation menu is now displaying dashboards from open dashboard's project or from selected Workspace project (earlier dashboards were shown from the selected model's project). (B-08673)


'''Fixed bugs:'''
===Fixed issues===
* 219370: Dashboards could not be edited by other than administrators.
* Fixed issue where AI Agent made unnecessary queries when filtering dashboard, and also opening dashboard with lot of chart may have been slow. (D-14503)
* 219361: Flowchart sometimes crashed to ThrowKeyNotFoundException when pressing Root Causes button.
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
* Clustering analysis didn't work with object-centric models. (D-14486)
* When a new groups is added, it's selected by default in the Manage Users dialog. Also clicking a selected group does not deselect it. (D-14491)
* Deleting last group didn't remove the group from the list. (D-14504)


== QPR ProcessAnalyzer 2020.3 (release date 2020-04-16) ==  
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==
Build number: 2020.3.0.41413, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.


'''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.
There is an issue causing some dashboards having more than 50 charts to open slowly. The issue has been fixed in the next release by D-14503.
* 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.
</div>


'''Features:'''
=== Fixed Issues ===
* 307849: Securely stored strings for passwords.
* Fixed issue where system stopped responding after opening Scripts tab several times (error in logs: Timeout expired prior to obtaining a connection from the pool). (D-14506)
* 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.
* Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
* 307880: When a datatable model is moved to another project, the linked datatables should also be moved to the project.
* Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
* 307556: Functions to expression language to improve usability and performance: CaseCount, EventCount, EventCountByType and Round.
* Fixed issue in User Management where assigning role to project or adding user to group was not saved when there was a column filter. (D-14124)
* 307895: SQL scripting command for database commit.
* 307850: Expression language performance improvement by a new way to calling functions and properties.
* 307858: Expression language: Support for array operators.
* 307845: Header buttons layout has been improved.
* 307870: Preprocessings are determined automatically.
* 307761: Functionality that user doesn't have access is now disabled in the dashboard designer and workspace to avoid access denied errors.
* 307839: Generic chart and gauge presentation objects are removed.
* 307863: Automatic redirection to SAML authentication.
* 307872: API support for querying if SAML is configured.
* 307846: Error message further improvements.
* 307888: Error message text changes for Dashboard not found and Multiple dashboards found.
* 307874 & 307887: ChartView and main header has been improved.


'''Fixed bugs:'''
== QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)==
* 219341: Analysis function unnecessarily required FilterId parameter.
* 219343: Root causes analysis gave access denied when using Analysis function.
* 219348: Query cancellation caused database connection leakage.
* 219332: "Thread was being aborted" returned to client while loading model from datatable.
* 219321: Removed unnecessary error log lines "Missing expected HttpRequest X-Forwarded-For" that appeared even if UseXForwardedForAsClientIp=false.
* 219335: [_remove ]._ or empty array is not handled correctly in a KPI dimension.
* 219340: default.aspx does not work.
* 219330: EditDashboards permission should be needed for target project when moving dashboards between projects.
* 219347: Queries done by the main header were cancelled when view is changed.
* 219355: Expression language: Was unable to use properties of the parent context in dictionary initialization.
* 219346: PAPO flowchart should have by default median duration shown on flows and flow counts hidden.
* 219333: PAPO generated incorrect filter JSON and unnecessary query.
* 219311: When opened a view by identifier, the view was fetched twice from the server.
* 219329: Unnecessary information was stored in database for dashboard definitions.
* 219362: Issues with session expiration checks.
* 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) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
Build number: 2020.2.0.41129, Model compatibility version: 3, Database version: 67, PACM file version: 7, Protocol version: 33.


'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 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.
There is a potentially serious issue that can cause the system to stop responding, when opening the Scripts tab in the Workspace. The issue has been fixed in the next release (build 9725) by D-14506.
* 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.
</div>
* 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:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307779: SAML 2.0 support for PA UI.
Object-centric model simplification in the story B-08667 (object attributes can only have a single value) doesn't work with this release. The issue has been fixed in the next release (build 9725) by B-08683.
* 307789: PAPO now supports ModelId variable and new filters.
</div>
* 307854: Filter selector for main header.
* 307844: Improved main header (visible in view designer and workspace) (part 2).
* 307820: Improved main header (visible in view designer and workspace).
* 307840: Model loading script is now run in a security context allowing access to the project. Setting AllowExternalDatasources for disabling ODBC interfaces.
* 307763: Root causes analysis supports multiple case attributes.
* 307737: Datatable columns can be queried without loading entire datatable into memory.
* 307780: When user logs in, last used model and default filter of the model is added to the session context.
* 307547: Expression filter rule supports value conversion expression for better compatibility with e.g. date values.
* 307841: Expression language has a new function [[Process_Mining_Objects_in_Expression_Language#Case|Case.DurationBetweenEvents]].
* 307819: Expression language improvements for functions, variables and statements.
* 307827: New function EventsWindow (and expression optimization to take it into use automatically)
* 307794: [[ QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model | GenericWrite permission]] should see model object counts when case level permissions are in use.
* 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:'''
===New features===
* 219198: In web.config, empty setting names are formatted as <value></value>.
* Enhanced [[AI_Agent|AI Agent]] with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
* 219199: In web.config, ResponsePollingInterval is 3600000.
* In [[Object-centric_Process_Mining_Model|object-centric models]], object-to-object relations are now followed by traversing once all object types. (B-08606)
* 219200: Model.EstimatedMemory gave too large estimate for models with lot of event types.
* In object-centric models, event type and object type tables are not mandatory anymore, and common attributes can be specified in events and objects tables. (B-08663)
* 219222: AggregateOthers didn't work with MaximumRowCount when dimensions is null in expression analysis.
* Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
* 219276: It should be possible to set filter to be model default filter when the filter is created.
* "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
* 219280: It should be possible to delete model default filter.
* Snowflake Event Types preset has been improved by adding suggestion of desired and undesired activities based on frequency of occurrence. (B-08656)
* 219275: Changing model default filter should only be possible for ManageViews permission.
* Added checkbox for [[Measure,_Dimension_and_Column_Settings#Advanced_settings|disabling filtering]] for individual dimensions or columns. (B-08589)
* 219297: Designer user can delete other people published filter from web UI but cannot delete it from PA Excel Client.
* Case and event attributes dropdown lists show number of unique values in Snowflake models (instead of attribute datatype as previously). (B-08316)
* 219285: Expression filter gives "Value was either too large or too small for an Int32".
* [[SAML_2.0_Federated_Authentication|SAML authentication]] can now synchronize user groups from identity provider. (B-08612)
* 219304: Expression analysis returning DataFrame doesn't work in SQL script that prints to Excel sheet.
* Groups can be [[Manage_Users_and_Groups#Deleting_Group|deleted]] in user management. (B-08330)
* 219251: Sample files removed from \\Release\Files\OfficeAddIns\Excel\Example Data.
* [[Storing_Secrets_for_Scripts|Secrets]] can be defines as global that can be used by all projects. To set global secrets, [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret|SetSecret]] function works also in the generic context. (B-08599)
* 219293: AnalyzeConformance function throws KeyNotFoundException - variation data missing.
* Snowflake [[Clustering_Analysis|Clustering analysis]] shows now number of event occurrences as features describing clusters. (B-08353)
* 219261: Restored model model could not be open.
* Model validity check has been extended to find issues in the eventlog data for Snowflake case-centric models. (B-07910)
* 219271: Invalid security notification when using Excel client.
* 219298: X-Forwarded-For handled incorrectly in Functions.GetClientIpAddress.
* 219305: Decimal datatype caused problems in the expression language.
* 219323: Delete operation deleted unexpected project, models and datatables.
* 219337: EventTypes in ModelInformation in PA response should contain entire model data.
* 219339: Expression language: If statement without false statement causes an exception if the condition is false.
* 219172: Invalid filterId causes "Internal server error" and " Method Not allow" error.
* 219258: Exception message is not shown properly in PA Web UI for FaultException.
* 219281: Improving the error handling for invalid ModelId.
* 219284: Client side forces filterId=0 even if filter is not mentioned.
* 219313: After adding the same existing panel twice, not possible to delete it from the view.
* 219320: Duplicate id on PanelDesigner field-properties.html template.
* 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) ==
===Fixed issues===
Build number: 2020.1.0.40909, Model compatibility version: 3, Database version: 65, PACM file version: 7, Protocol version: 32.
* Fixed a potential issue which could have leaked database connections and caused connection pool starvation. (D-14414)
* Renewed self-signed certificate used by SAML 2.0 authentication with ten years of validity. (D-14424)
* Improved CallWebService function to send request body when using DELETE method. (D-14488)
* Login page now shows correct error message when there are serious system errors during login. (D-14480)
* "Datatable contents (in-memory)" option now works also with Snowflake datatables. (D-14391)
* Added maximum data size limitation to AI assistant to avoid error with large datasets. (D-14419)
* Day of the Year/Week/Month/Quater selection didn't work with specific event time in in-memory chart. (D-14421)
* KPI card now shows a scrollbar when content doesn't fit to the available space. (D-13428)
* Workspace projects hierarchy tooltips didn't show special characters correctly. (D-14430)
* BPMN editor crashed when creating filter from tasks giving following error: Cannot read properties of null (reading 'querySelector'). (D-14399)
* Value expressions didn't work that are referred in dimension and containing aggregation. (D-13624)
* Fixed issue where object-centric flowchart filter selection gave error when case-centric model was selected. (D-14408)
* Fixed issue where query to non-existing model incorrectly returned "Sequence contains no elements". (D-14402)
* Incorrect StringifiedValues in chart settings and expression filter rule caused UI to stuck. (D-14485)
* Table column filter value list didn't show the null value label correctly. (D-13844)
* "Visualize list items with colors" setting didn't work with the "Last Row Aggregates Over-limit Rows" setting. (D-14357)
* Made sure that failed queries are not added to model filter cache. (D-14484)
* Chart settings crashed when trying to use without model selected giving following error: Cannot read properties of undefined (reading 'injectValue'). (D-14395)
* Fixed issue where chart settings opened on top of full screen BPMN editor. (D-14472)
* Show details button in some error messages didn't have any effect when pressed. (D-14490)
* Model validation message was incorrect for model where other datatable is Snowflake and other SQL Server. (D-14475)


'''Features:'''
===Other improvements===
* 307749: Support for importing data to the datatable models.
* Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
* 307813: DataSourceType parameter to --#ImportEvents and --#ImportCaseAttributes ETL scripting commands.
* Datatable duplication is now synchronous in Snowflake until 30 seconds to avoid showing the created duplicate datatable with zero rows while the operation is still in progress. (B-08634)
* 307743: Backend support for saving the new filters.
* Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
* 307775: Effective dashboard permissions are included to dashboard definition when fetched from the server.
* Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
* 307772: Dashboard project path is added to dashboard definition when fetched from the server.
* Frontend components have been updated. (B-08638)
* 307778: When saving a view, the view is not anymore reloaded unnecessary.
* Backend components have been updated. (B-08639)
* 307810: Expression language adjustments.
* Translations have been updated. (B-08640)
* 307818: Drop support for QPR ProcessAnalyzer Excel Client for Excel 2013.


'''Fixed bugs:'''
==Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)==
* 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) ==
=== Fixed issues ===
Build number: 2019.9.0.40754, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.
* Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
* Fixed issue where AI Agent and LLMComplete function didn't work in Native App. (D-14410)
* Fixed translations for Workspace Scripts tab column filter for Status and Result columns. (D-14393)
* Fixed issue where Volume Distribution of Flow Analyzed object type didn't work. (D-14390)
* Removed reference to fonts.googleapis.com for stylesheets to avoid content-security-policy error. (D-14373)
* Syncfusion dialog headers now show special characters correctly. (D-14407)
* Object attribute filter gave null reference error when object type didn't exist in model. (D-14379)


'''Notes'''
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==
* 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:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]
* 307785: Angular Migration: Migrate ProcessAnalyserService.
* 307786: Angular Migration: Migrate FieldPropertiesUtils.


'''Fixed bugs for QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219262: Login to PA UI is not possible when there is + character in the password
Detection of models with incomplete datasource configuration has been improved, and now models where the event timestamp column type is string, are not anymore considered valid models. Earlier the string type of data was accepted and converted into dates when model was loaded (for in-memory models) or in SQL queries (in Snowflake models).
* 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) ==  
The following query can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] (with System administrator user) to list models where the events datatable timestamp column type is string:
Build number: 2019.9.0.40704, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.
<pre>
Models.Where({
let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
}).(Name + " (id: " + Id + ")");
</pre>
</div>


'''Features for QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307484: Implemented Excel client protocol version for improved compatibility for older Excel Clients.
For Snowflake dashboards, table actions to [[QPR_ProcessAnalyzer_Table#Table_actions|set dashboard variables]] now set the variable values in the [[Stringified_Value_Format|stringified format]] instead of as raw values. This makes the variables set by table actions compatible with the [[Chart_Linked_Settings|linked settings]] which also use the stringified format by default for the Snowflake models.
* 307564: [[Web.config_file_in_QPR_ProcessAnalyzer|Case sampling]] is disabled by default.
</div>
* 307724: There is a support for self-signed certificate for QPR ProcessAnalyzer service.
* 307705: User related information and session id is available for HTML presentation objects.
* 307712: Error messages from the backend are shown in UI
* 307750: PA UI Frontend (part 3)


'''Fixed bugs for QPR ProcessAnalyzer:'''
===New features===
* 219170: Conformance checking didn't work when there is a non-existing bpmn task between parallel gateway and the end event.
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
* 219152: Loading model into memory doesn't anymore require a ResetModelCache permission.
*Added [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering by object attributes]] for object-centric models. Filters can be created from dialog or selecting items from charts. (B-08547)
* 219213: Improved model loading performance when using ODBC, datatable and expression datasources.
*In object-centric models, object-to-object relations are followed only forward and backward directions. Additionally, there are performance improvements for object-centric models. (B-08577)
* 219218: Order of the comparison rules incorrectly affected the influence analysis results.
*Snowflake warehouse can be [[QPR_ProcessAnalyzer_Project_Workspace#Change_Snowflake_Warehouse_for_Model|specified for each model]] allowing to use optimal type of warehouse for different sizes of models. (B-08610)
* 219240: Import model or export model from filter gave "Input string was not in a correct format" error.
*Home screen has been removed, and [[QPR_ProcessAnalyzer_Project_Workspace|Workspace]] has new card layout and other UX improvements. (B-08541)
* 219238: Fix for error message "CommunicationException: The remote host closed the connection".
* Added [[Filtering_in_QPR_ProcessAnalyzer#Saving_filters|filter description]] field to filter properties dialog. (B-08451)
* 219249: Access was incorrectly denied for non system admins when saving a new dashboard.
*Removed event type existence check from charts, so that non-existing event types are allowed. (B-08585)
*Snowflake Native App configuration data can be [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Backup_configuration_data|backed up to a snapshot and restored]]. (B-08591)
*Improved detection of invalid models by adding [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CheckModelValidity|CheckModelValidity]] function returning model validation errors. (B-08426)


== QPR ProcessAnalyzer 2019.8 (release date 2019-10-30) ==
===Fixed issues===
Build number: 2019.8.0.40391, Model compatibility version: 2, Database version: 62, PACM file version: 7.
*Prevented following error in Snowflake dashboards: Object "qprpa_dt_cache_..." already exists when creating a cache table. (D-14348)
*In-memory chart "Cases filtered by attribute" didn't work for date type of attributes. (D-14387)
*Fixed issue where each dashboard element resize made element width or height increase when chart margin was more than zero. (D-14361)
*Chart related buttons are now hidden in datatable content preview. (D-14360)
*Fixed issue where gateway based data import didn't write SAP errors into script log. (D-14351)
* Snowflake chart gave error when "Last Row Aggregates Over-limit Rows" setting was used with list aggregation. (D-14352)
*"Users" system report performance has been improved by adding EffectivePermissionTypesFor function. (D-14266)
*Fixed issue where AI Assistant crashed when used with a model having ODBC or expression datasource. (D-14340)
*Fixed issue where AI Assistant explaining charts crashed when applying to Label component. (D-14344)
*Improved client-side import not to perform redundant datatable configuration data queries. (D-14347)
*Model was incorrectly identified as in-memory model when datatables were missing. (D-14325)
*Model default filter is now in use when model is opened from Workspace. (D-14376)


'''Features for QPR ProcessAnalyzer:'''
===Other improvements===
* 307633: [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_Datatables|Datatables]] can be used as a PA model datasource (part 1).
*Changed Snowflake charts to store [[QPR_ProcessAnalyzer_Table#Table_actions|variable change actions]] in stringified format to make them compatible with linked settings. (B-08587)
* 307700: JSON filter rules should not give error for non-existing values, such as event type names.
*Backend support for [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|object-centric filter rules Disabled flag]]. (B-08611)
* 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.
*Implemented Entity Framework based database initialization and migrations. (B-08566)
* 307693: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language|Expression language: Return attributes in alphabetical order]].
*Added support for following Entity Framework database providers: SQL Server (full), Snowflake Hybrid Tables (experimental), PostgreSQL (experimental). (B-08581)
* 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]].
*Frontend components have been updated. (B-08597)
* 307725: Expression language: AsParallel function for making calculations in parallel to improve performance.
*Backend components have been updated. (B-08596)
* 307715: New PA Web UI Backend (part 3).
*Translations have been updated for release 2025.2. (B-08607)
* 307728: New PA Web UI Backend (part 4).


'''Fixed bugs for QPR ProcessAnalyzer:'''
==QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)==
* 219210: ScriptLaucher CSV export should quote string values with double quotes when the string value contains semicolon.
* 219143: IIS https only setup does not work.
* 219186: Event.IndexInCase had issue with event type filters.
* 219167: Event.OutgoingFlowOccurrence and Event.IncomingFlowOccurrence had issues with event type filters.
* 218689: _.Cases and _.Events doesn't work as a root in EventLog context in KPI Analysis.
* 219004: PA license expiration causes unclear error in UI.
* 219187: KeyNotFound exception occurred when include only all cases from the Path Analysis.
* 219197: Minor issues in ODBC datasource.
* 219207: Flowchart influence analysis does not work properly when using both Filter and Comparison parameters.


== QPR ProcessAnalyzer 2019.7 (release date 2019-09-25) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
Build number: 2019.7.0.40226, Model compatibility version: 2, Database version: 61, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
===New features===
* 307655: Drop support for SQL core as PA data source (Part 5 Memory optimization).
*B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
* 307696: New PA Web UI Backend.
*B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
* 307710: New PA Web UI Backend (part 2).
*B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
*B-08439: Added project settings [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Database_and_Schema|DatabaseNameInDataSource and SchemaNameInDataSource]] to define Snowflake database and schema.
*B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
*B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].


'''Fixed bugs for QPR ProcessAnalyzer:'''
===Fixed issues===
* 219164: Event.NextInCase/PreviousInCase didn't work with event type filters.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* 219136: ODBC model not support import and remove functionality.
*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.
* 219171: Event.NextInCase and Event.PreviousInCase requires CaseEvents preprocessing.
*D-14346: Fixed issue where manual activation using activation utility didn't work.
* 219173: Out of memory error and application pool crashing in customer environment.
* 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.


== QPR ProcessAnalyzer 2019.6 (release date 2019-08-08) ==  
===Other improvements===
Build number: 2019.6.0.40009, Model compatibility version: 2, Database version: 59, PACM file version: 7.
* 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.


'''Features for QPR ProcessAnalyzer:'''
== Old Releases==
* 307260: Update to Visual Studio 2017 and update to .Net 4.7.1.
See older releases in [[QPR ProcessAnalyzer Release Archive]]
 
'''Fixed bugs for QPR ProcessAnalyzer:'''
* 219106: Datetime ticks property in the expression language should be in UTC.
 
== QPR ProcessAnalyzer 2019.5 (release date 2019-06-19) ==  
Build number: 2019.5.0.39902, Model compatibility version: 2, Database version: 59, PACM file version: 7.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307330: Filtering renewal: PAPO.
* 307638: Angular Migration: Migrate Analysis classes part 3.
* 307653: Angular Migration: Migrate Analysis classes part 4.
 
'''Features for QPR ProcessAnalyzer:'''
* 307649: Drop support for SQL core as PA data source (Part 4 Source code removal).
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 219040: Clustering analysis expression doesn't take into account model without any case attributes.
* 219001: Case Analysis always limited to 1000 rows (other analyses have the same problem).
* 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:'''
* 219062: GetModels is slow for admin.
* 218978: Odd 1 million filter is adapted once you remove your custom filter.
* 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) ==
Build number: 2019.4.0.39800, Model compatibility version: 2, Database version: 59, PACM file version: 7.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 219078: PAPO loses saved filter when changing analysis
* 219000: User with only Analyzer role can see and use private filter created by Administrator.
* 219049: Copy of a model with odbc datasource doesn't have filters from the original model.
* 219044: Calculated case attributes don't work with odbc model without defined cases.
 
'''Features for QPR ProcessAnalyzer:'''
* 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) ==
Build number: 2019.4.0.39420, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights''':
* Custom dashboards for QPR ProcessAnalyzer can be browsed and edited more easily, as there is a Dashboards menu item available.
 
'''Features for QPR ProcessAnalyzer:'''
* 307419: Change the database connection type to use in-memory core (PA Core).
* 307324: Drop support for SQL core as PA data source (Part 1: Export from EventLog).
* 307619: Drop support for SQL core as PA data source (Part 2: Remove analysis 26, 27 and 28).
* 307523: Refactor ModelInformation code in PA Core.
* 307613: Quick & Easy memory usage optimizations: PA Core.
* 307618: Prediction capability to expression language.


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218909: Data grid based analysis jumping.
* 218971: PAPO Variation analysis has both paths and counts at the same time.
* 218972: PAPO Duration analysis missing the grouped by dimension (default value is not set in analysis).
* 218969: Event attribute "Cost" doesn't work in Profiling Events analysis and in Expression language.
* 219006: Case id's (case names) are interpreted as numbers by PAPO.
* 219027: Numerical attributes are shown as zero decimals in some analysis in data grid presentations.
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218938: Filter rules information is not showing names for odbc loaded models and calculated case/event attributes.
* 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 09:49, 5 November 2025

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

Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11)

See roadmap for next release features and fixes

Latest Release: QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01)

New features presentation: QPR_ProcessAnalyzer_2025_6.pdf

Known issue: If the DefaultUiLanguage system configuration is not defined, users who haven't changed their own language, are unable to login. To prevent this problem, please ensure the DefaultUiLanguage is defined. The next release will fix this issue (D-14706).

Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:

  • object-src 'none'
  • frame-ancestors 'self'
  • form-action 'none'
  • base-uri 'none'
  • worker-src blob:

These new restrictions may affect usage that has previously been possible. For example, with the new settings, QPR ProcessAnalyzer can be embedded to a website only within the same origin. For detailed instructions on embedding QPR ProcessAnalyzer on a different website, please refer to this quide. Additionally, for information on modifying the CSP settings, see documentation for security hardening.

In the QPR ProcessAnalyzer 2025.6 Native App, the release version number is not displayed correctly in the User Settings dialog. This omission does not have any other complications. QPR ProcessAnalyzer 2025.6 is the only release with this issue, making it possible to identify this release despite the missing version number. This issue is specific to the Native App only. The next release will fix this issue (D-14703).

New features

  • Starting dashboard after login can be defined for user groups, allowing to create customized starting pages for easy navigation. (B-08791)
  • Snowflake chart's event filters are now embedded to filters created from chart, to precisely follow chart calculation. (B-08845)
  • Result data can be filtered in Snowflake charts using result filtering expression which works for any datasets. (B-08751)
  • Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
  • Added model setting Show object count statistics to hide object counts information in dropdown lists to optimize performance. (B-08849)
  • Added support for hiding statistics for on-screen setting dropdown lists to improve performance, and in addition the case ID is hidden Case/Event attribute profiling presets. (B-08840)
  • Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
  • Snowflake Native App: Added procedure to that creates administrator user to Native App if access to the app has been lost. Also, prevented user management operations that remove own access. (B-08733)
  • Snowflake Native App: Added procedure to change Native App compute pool size. Changed new Native Apps to use CPU_X64_S size compute pool, and improved Native App stability. (B-08859)

Fixed issues

  • Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
  • When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
  • Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
  • Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
  • In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
  • Event type mapping in charts didn't work in object-centric models. (D-14620)
  • Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
  • Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
  • Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
  • In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
  • Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
  • Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
  • Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
  • Translation was missing from error messages when deleting items from recycle bin. (D-14652)
  • Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
  • Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
  • Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
  • Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
  • Fixed incorrect data types in some project, user and group related measures. (D-14619)
  • Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
  • Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
  • Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
  • Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
  • Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
  • Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)

Other improvements

  • Added QPR ProcessAnalyzer API request ID to Snowflake queries to easily find matching query in Snowflake query history. (B-08839)
  • Content Security Policy HTTP header includes now object-src, frame-ancestors, form-action, base-uri, and worker-src. (B-08794)
  • Snowflake queries have been optimized by removing null and empty string checks from mapped columns as they are now handled by the model validation check. (B-08837)
  • Added backend support for object-centric model filtering based on case-centric filter rules. (B-08836)
  • Frontend components have been updated. (B-08851)
  • Backend components have been updated. (B-08852)

QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21)

New features presentation: QPR_ProcessAnalyzer_2025_5.pdf

When using Snowflake Cortex, the AI Assistant is not showing the results table in the assistant's response. This issue has been fixed by the next release.

New features

  • Object-centric flowchart can also use object-to-object relations to link events and objects simplifying event-to-object configuration. (B-08671)
  • AI Assistant can provide precise quantitative analysis by making queries to eventlog data (powered by Snowflake Cortex Analyst and Agents). (B-08652)
  • Flows and variations can be filtered from any event attribute viewpoint in Snowflake. (B-08737)
  • Added project properties dialog for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
  • Model validity check easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
  • Projects can be exported to json files and imported as new projects. (B-08717)
  • Action buttons can be added to dashboard by defining label component that can change dashboard variables and run scripts. (B-08694)
  • Web user interface is available in Ukrainian language. (B-08734)

Fixed issues

  • Fixed following error when performing client-side SAP import: Could not find a part of the path (QPR_ImportSource_Chunk_*.tmp). (D-14589)
  • Fixed issue where ManageProjects permission was incorrectly required when running scripts using QPR ScriptLauncher non-legacy mode. (D-14562)
  • Fixed following error when using SAP import from SQL script called from expression language called from SQL: The given key was not present in the dictionary. (D-14593)
  • Some analyses didn't work, when case ID columns for cases and events datatables differed only in upper/lowercase letters. (D-14556)
  • Business calendar didn't work for some measures/dimensions/columns and some had business calendar checkboxes missing. (D-14563)
  • Prediction failed to following error: transformer_model_next_activity/event_year_input_embedding. (D-14551)
  • Scripting now works correctly after rows from PA_OPERATION_STATUS table have been deleted. (D-14545)
  • Fixed issue where case-centric flowchart was very slow for object-centric model. (D-14544)
  • Prevented creating dashboards, models and scripts with duplicate names in the same project. (D-09480)
  • KPI Card now shows line breaks correctly in textual values. (D-14546)
  • Improved table Excel export for list data to show items with separator character instead of showing as JSON. (D-14479)
  • Column showing non-conformance reason was incorrectly aligned to right. (D-14570)
  • GetRelatedValueFrom function caused column name conflict when used multiple times in same query. (D-14591)
  • Fixed issue where in-memory sorting for arrays gave "Error in sorting analysis result rows possibly due to multiple types of values ...". (D-14592)
  • Array type of values were shown incorrectly when used Last Row Aggregates Over-limit Rows setting. (D-14616)
  • Fixed the "Most common" text aggregation sorting error for in-memory calculation. (D-14573)
  • Snowflake model validation gave incorrect error message when mapped column didn't exist in datatable. (D-14565)
  • Improved model validation to detect when connection string key for model or datatable does not exist. (D-14607)
  • Model validation gave incorrect error when when events datatable case id mapping was missing. (D-14566)
  • Model validation gave incorrect error message when cases and events datatables were in different datasources. (D-14567)
  • Model validation gave incorrect error message when underlying Snowflake table didn't exist. (D-14568)
  • Workspace Card/Table mode toggle buttons were not translated. (D-14547)
  • Some invalid queries gave unexpected errors and strange outputs. (D-14569)
  • Added translations to model notifications preview table headers. (D-14590)
  • Added translations to access denied message for header object counts indicator. (D-13967)
  • AI Assistant explaining charts speaks now user interface language. (D-14578)
  • AI Agent prompt chart editor didn't show correctly if model was not selected. (D-14536)
  • AI Assistant gave "Unsupported cache table type" error when trying to explain object-centric flowchart. (D-14477)

Other improvements

  • When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
  • Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
  • Stringified value format supports also json objects. (B-08766)
  • Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
  • Translations have been updated. (B-08757)
  • Frontend components have been updated. (B-08760)
  • Backend components have been updated. (B-08759)

QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28)

New features presentation: QPR_ProcessAnalyzer_2025_4.pdf

New features

  • Added new AI Agent presets analyzing current state and proposing improvements based on different viewpoints, such as Event and Case Counts, Automation, Bottlenecks, and Root Causes. (B-08710)
  • Added a generic filtering component that can be configured for creating any type of filters for distinct values. (B-08654)
  • Volume declining in measures due to case sampling can be compensated in chart and flowchart by using a Statistical calculation method. (B-08598)
  • In object-centric models, Object ID, Event ID, Event timestamp, and Event type attribute names are shown correctly. (B-08680)
  • Snowflake native app has now application roles for user (for using app) and administrator (for managing app). (B-08660)
  • For Snowflake native app, IMPORTED PRIVILEGES ON SNOWFLAKE DB privilege is removed and instead the CORTEX_USER database role can be assigned. (B-08718)
  • Native app logging has been improved and now sharing application logs with QPR is possible. (B-08661)
  • Added CsvToDataFrame function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)

Fixed issues

  • Fixed "Invalid identifier" error when opening attribute selection list for case attribute preset caused by object id columns which differed only by letter capitalization. (D-14539)
  • When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
  • Filters created from dimensions having dimension-specific filter rules will now create expression filter rule where dimensions-specific filter is embedded, for accurately following the selection. (D-14499)
  • Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
  • Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
  • Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
  • In in-memory models, array type of data was not dimensioned correctly. (D-14518)
  • AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
  • Table grouping header labels were not formatted correctly. (D-14514)
  • Fixed Root causes analysis to work with object-centric models. (D-14515)
  • Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
  • Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
  • Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
  • Flowchart SVG export did not show start and end symbols. (D-12401)
  • Fixed issue where join operation didn't find renamed columns in SqlDataFrames. (D-14512)
  • Improved chart filtering button positions to work with small chart sizes. (D-14509)
  • Datatable foreign key columns dictionary data type was incorrect preventing reading columns information. (D-14505)
  • Workspace scripts editor allowed to change script code for viewer users (altough not save it). (D-14534)
  • In chart custom sorting, trying to refer to measure that had None aggregation, caused SQL compilation error. (D-14526)
  • Model validation check crashed when the datatables were in different datasources. (D-14502)

Other improvements

  • Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
  • Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
  • Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
  • Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
  • Frontend components have been updated. (B-08695)
  • Backend components has been updated. (B-08696)

Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)

New features

  • Navigation menu is now displaying dashboards from open dashboard's project or from selected Workspace project (earlier dashboards were shown from the selected model's project). (B-08673)

Fixed issues

  • Fixed issue where AI Agent made unnecessary queries when filtering dashboard, and also opening dashboard with lot of chart may have been slow. (D-14503)
  • When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
  • Clustering analysis didn't work with object-centric models. (D-14486)
  • When a new groups is added, it's selected by default in the Manage Users dialog. Also clicking a selected group does not deselect it. (D-14491)
  • Deleting last group didn't remove the group from the list. (D-14504)

Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)

There is an issue causing some dashboards having more than 50 charts to open slowly. The issue has been fixed in the next release by D-14503.

Fixed Issues

  • Fixed issue where system stopped responding after opening Scripts tab several times (error in logs: Timeout expired prior to obtaining a connection from the pool). (D-14506)
  • Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
  • Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
  • Fixed issue in User Management where assigning role to project or adding user to group was not saved when there was a column filter. (D-14124)

QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)

New features presentation: QPR_ProcessAnalyzer_2025_3.pdf

There is a potentially serious issue that can cause the system to stop responding, when opening the Scripts tab in the Workspace. The issue has been fixed in the next release (build 9725) by D-14506.

Object-centric model simplification in the story B-08667 (object attributes can only have a single value) doesn't work with this release. The issue has been fixed in the next release (build 9725) by B-08683.

New features

  • Enhanced AI Agent with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
  • In object-centric models, object-to-object relations are now followed by traversing once all object types. (B-08606)
  • In object-centric models, event type and object type tables are not mandatory anymore, and common attributes can be specified in events and objects tables. (B-08663)
  • Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
  • "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
  • Snowflake Event Types preset has been improved by adding suggestion of desired and undesired activities based on frequency of occurrence. (B-08656)
  • Added checkbox for disabling filtering for individual dimensions or columns. (B-08589)
  • Case and event attributes dropdown lists show number of unique values in Snowflake models (instead of attribute datatype as previously). (B-08316)
  • SAML authentication can now synchronize user groups from identity provider. (B-08612)
  • Groups can be deleted in user management. (B-08330)
  • Secrets can be defines as global that can be used by all projects. To set global secrets, SetSecret function works also in the generic context. (B-08599)
  • Snowflake Clustering analysis shows now number of event occurrences as features describing clusters. (B-08353)
  • Model validity check has been extended to find issues in the eventlog data for Snowflake case-centric models. (B-07910)

Fixed issues

  • Fixed a potential issue which could have leaked database connections and caused connection pool starvation. (D-14414)
  • Renewed self-signed certificate used by SAML 2.0 authentication with ten years of validity. (D-14424)
  • Improved CallWebService function to send request body when using DELETE method. (D-14488)
  • Login page now shows correct error message when there are serious system errors during login. (D-14480)
  • "Datatable contents (in-memory)" option now works also with Snowflake datatables. (D-14391)
  • Added maximum data size limitation to AI assistant to avoid error with large datasets. (D-14419)
  • Day of the Year/Week/Month/Quater selection didn't work with specific event time in in-memory chart. (D-14421)
  • KPI card now shows a scrollbar when content doesn't fit to the available space. (D-13428)
  • Workspace projects hierarchy tooltips didn't show special characters correctly. (D-14430)
  • BPMN editor crashed when creating filter from tasks giving following error: Cannot read properties of null (reading 'querySelector'). (D-14399)
  • Value expressions didn't work that are referred in dimension and containing aggregation. (D-13624)
  • Fixed issue where object-centric flowchart filter selection gave error when case-centric model was selected. (D-14408)
  • Fixed issue where query to non-existing model incorrectly returned "Sequence contains no elements". (D-14402)
  • Incorrect StringifiedValues in chart settings and expression filter rule caused UI to stuck. (D-14485)
  • Table column filter value list didn't show the null value label correctly. (D-13844)
  • "Visualize list items with colors" setting didn't work with the "Last Row Aggregates Over-limit Rows" setting. (D-14357)
  • Made sure that failed queries are not added to model filter cache. (D-14484)
  • Chart settings crashed when trying to use without model selected giving following error: Cannot read properties of undefined (reading 'injectValue'). (D-14395)
  • Fixed issue where chart settings opened on top of full screen BPMN editor. (D-14472)
  • Show details button in some error messages didn't have any effect when pressed. (D-14490)
  • Model validation message was incorrect for model where other datatable is Snowflake and other SQL Server. (D-14475)

Other improvements

  • Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
  • Datatable duplication is now synchronous in Snowflake until 30 seconds to avoid showing the created duplicate datatable with zero rows while the operation is still in progress. (B-08634)
  • Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
  • Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
  • Frontend components have been updated. (B-08638)
  • Backend components have been updated. (B-08639)
  • Translations have been updated. (B-08640)

Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)

Fixed issues

  • Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
  • Fixed issue where AI Agent and LLMComplete function didn't work in Native App. (D-14410)
  • Fixed translations for Workspace Scripts tab column filter for Status and Result columns. (D-14393)
  • Fixed issue where Volume Distribution of Flow Analyzed object type didn't work. (D-14390)
  • Removed reference to fonts.googleapis.com for stylesheets to avoid content-security-policy error. (D-14373)
  • Syncfusion dialog headers now show special characters correctly. (D-14407)
  • Object attribute filter gave null reference error when object type didn't exist in model. (D-14379)

QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)

New features presentation: QPR_ProcessAnalyzer_2025_2.pdf

Detection of models with incomplete datasource configuration has been improved, and now models where the event timestamp column type is string, are not anymore considered valid models. Earlier the string type of data was accepted and converted into dates when model was loaded (for in-memory models) or in SQL queries (in Snowflake models).

The following query can be run in the Expression Designer (with System administrator user) to list models where the events datatable timestamp column type is string: 

Models.Where({
	let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
	return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
}).(Name + " (id: " + Id + ")");

For Snowflake dashboards, table actions to set dashboard variables now set the variable values in the stringified format instead of as raw values. This makes the variables set by table actions compatible with the linked settings which also use the stringified format by default for the Snowflake models.

New features

  • Introduced AI Agent which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
  • Added filtering by object attributes for object-centric models. Filters can be created from dialog or selecting items from charts. (B-08547)
  • In object-centric models, object-to-object relations are followed only forward and backward directions. Additionally, there are performance improvements for object-centric models. (B-08577)
  • Snowflake warehouse can be specified for each model allowing to use optimal type of warehouse for different sizes of models. (B-08610)
  • Home screen has been removed, and Workspace has new card layout and other UX improvements. (B-08541)
  • Added filter description field to filter properties dialog. (B-08451)
  • Removed event type existence check from charts, so that non-existing event types are allowed. (B-08585)
  • Snowflake Native App configuration data can be backed up to a snapshot and restored. (B-08591)
  • Improved detection of invalid models by adding CheckModelValidity function returning model validation errors. (B-08426)

Fixed issues

  • Prevented following error in Snowflake dashboards: Object "qprpa_dt_cache_..." already exists when creating a cache table. (D-14348)
  • In-memory chart "Cases filtered by attribute" didn't work for date type of attributes. (D-14387)
  • Fixed issue where each dashboard element resize made element width or height increase when chart margin was more than zero. (D-14361)
  • Chart related buttons are now hidden in datatable content preview. (D-14360)
  • Fixed issue where gateway based data import didn't write SAP errors into script log. (D-14351)
  • Snowflake chart gave error when "Last Row Aggregates Over-limit Rows" setting was used with list aggregation. (D-14352)
  • "Users" system report performance has been improved by adding EffectivePermissionTypesFor function. (D-14266)
  • Fixed issue where AI Assistant crashed when used with a model having ODBC or expression datasource. (D-14340)
  • Fixed issue where AI Assistant explaining charts crashed when applying to Label component. (D-14344)
  • Improved client-side import not to perform redundant datatable configuration data queries. (D-14347)
  • Model was incorrectly identified as in-memory model when datatables were missing. (D-14325)
  • Model default filter is now in use when model is opened from Workspace. (D-14376)

Other improvements

  • Changed Snowflake charts to store variable change actions in stringified format to make them compatible with linked settings. (B-08587)
  • Backend support for object-centric filter rules Disabled flag. (B-08611)
  • Implemented Entity Framework based database initialization and migrations. (B-08566)
  • Added support for following Entity Framework database providers: SQL Server (full), Snowflake Hybrid Tables (experimental), PostgreSQL (experimental). (B-08581)
  • Frontend components have been updated. (B-08597)
  • Backend components have been updated. (B-08596)
  • Translations have been updated for release 2025.2. (B-08607)

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.

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=27214"