QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(330 intermediate revisions by 4 users not shown)
Line 1: Line 1:
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release. See also the [[Next_Release_Content|next release content]].
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.


== Next Release: QPR ProcessAnalyzer 2024.5 (planned release date 2024-06-25) ==
== Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11) ==
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]


'''Features:'''
== Latest Release: QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01) ==
* B-08314: Snowflake connection string can be [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Connection|specified for each project]] to allow projects connecting to different Snowflake accounts, databases or schemas.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_6.pdf QPR_ProcessAnalyzer_2025_6.pdf]
* B-08318: Improved Snowflake Events preset performance by adding a filter that picks a subset of cases.
* B-08342: Added DashboardName and DashboardProjectName properties to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* B-08311: Changed QPR ScriptLauncher interaction with the server by changing the long polling to short calls to improve robustness.
 
'''Fixed issues:'''
* D-14137: AI Assistant incorrectly appeared on top of chart in the fullscreen mode.
* D-14132: Snowflake model object counts were not shown when opening dashboard while model metadata was still loading.
* D-14129: Imported model name was incorrectly cut if it contained dots.
* D-14131: Some popup messages had incorrect html escaping.
* D-14058: Login page was incorrectly shown when SAML authentication is configured and user is directed to the identity provider.
* D-14106: Having only a template string in the #expr{...} block didn't work.
* D-14146: "Unable to get on-premise gateway named..." when running an Expression Language script from a SQL script using ScriptLauncher
* D-14010: Occurrences of specific flow measure didn't work with the Root causes analysis weighting expression (in-memory).
* D-14008: "Root Causes contribution" and "Comparison eventlog cases percentage" columns didn't work (in-memory).
 
== Latest Release: QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14) ==
 
'''Features:'''
* B-08227: Dashboards have [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] (powered by ChatGPT) helping users in process analysis. AI Assistant can answer general questions about the process, create filters based on user prompt, and explain charts and analyses.
* B-08277: QPR ProcessAnalyzer now detects automatically when cases or events data in Snowflake updates. Check is done every 5 minutes which is the maximum delay of detecting new data. ([[Snowflake_Connection_Configuration#Automatic_data_update_detection|more information]])
* B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
* B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
* B-08276: Adjusted permissions for [[Roles_and_Permissions#Project_Permissions|moving projects]].
* B-08310: Added Details property to [[Generic_Objects_in_Expression_Language#Exception|Exception object]] in expression language.
* B-08328: Language translations have been updated to 2024.4.
* B-08312: Frontend components have been updated.
* B-08308: Backend components have been updated.
 
'''Fixed issues:'''
* D-14084: Filter rule for first and last event in case couldn't be edited if there were more than one event selected.
* D-14091: Duration multi-unit didn't work in big data chart.
* D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
* D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
* D-14107: Snowflake model that has earlier been an in-memory model showed case count and estimated memory incorrectly.
* D-14074: Fixed issue in QPR ScriptLauncher when calling the script from other script.
* D-14104: Fixed expression language parsing issue with in-memory DataFrame and filter using "In" function.
* D-14121: Datatable UpdateRows function now supports column names given as expressions.
* D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
* D-14123: There was an error of unable to get on-premise gateway when using ExtractSap function in expression language script from SQL script called from expression language script.
* D-14128: Table without title was incorrectly exported as .txt file.
* D-14112: Convert to custom expression button didn't work in design diagram.
* D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
* D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed in chart settings.
* D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
* D-14096: Highcharts tooltip square icons were slightly misaligned.
* D-14099: There was a console warning when opening the business calendar dialog.
* D-14118: Design diagram sometimes gave following JavaScript error: Cannot read properties of undefined (reading 'parentNode').
* D-14024: If quickly logging out after changing model, the model change might not be been saved.
* D-14120: User.getAttribute function returned values from incorrect context.
* D-14102: Pivot table cannot read properties of undefined.
 
== QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04) ==
 
'''Features:'''
* B-08024: [[Design_Diagram|Design diagram]] has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
* B-08242: Script based [[Actions_to_Run_Script_in_Table|actions]] can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
* B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
* B-08288: Added expression language functions to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Start|start and stop]] scripts.
* B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
* B-07906: Implemented cross joins to SQL dataframes.
* B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
* B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
* B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
* B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
* B-03047: Removed support for dashboard panels.
* B-08214: Removed unused columns from the PA_VIEW table.
* B-08254: Frontend components have been updated.
* B-08255: Backend components have been updated.
* B-08233: Language translations have been updated to 2024.3.
 
'''Fixed issues:'''
* D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
* D-14035: In design diagram, BPMN event and gateway symbols are now circular.
* D-14049: Added some missing translations for table column filter and BPMN editor.
* D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
* D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
* D-13976: Fixed issue where gateway-based imports were not synchronous.
* D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
* D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
* D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
* D-14071: Business calendar button press caused error when user didn't have access to any model.
* D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
* D-11268: There were inconsistent button colors in Workspace.
* D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
* D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
* D-14081: Fixed null references error when logging null in expression script.
 
== Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27) ==
 
'''Features:'''
 
* B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.
 
'''Fixed issues:'''
 
* D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.
 
== QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21) ==


<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;">
Known issue: Snowflake models and dashboards don't work with Viewer and Analyzer role permisions. The reason is that cache tables created to Snowflake incorrectly require the write permissions. Workaround is to give users the Designer role which will give the needed permissions. Note that the Designer role gives many permissions to the user for the project [[Roles_and_Permissions#Roles_and_Permissions|(more information)]]. This issue has been fixed in the next release (D-14045).
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).
</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 legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Models.Filters]] and [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property.
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;">
New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).
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===
* B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
* [[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)
* B-08232: Entire future eventlogs can be [[Create_Predicted_Eventlog|predicted]] based on generative AI models running in Snowflake.
* 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)
* B-08166: Added expression language function [[Generic_Functions_in_QPR_ProcessAnalyzer#OpenAIChatCompletion|OpenAIChatCompletion]] to answer natural language prompts based on OpenAI ChatGPT API.
* 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)
* B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
* Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* B-08196: Conditional formatting rules can be defined for [[QPR_ProcessAnalyzer_Table#Textual_equal_rules_for_background_color|textual and boolean values]].
* 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)
* B-08213: Big data chart expressions event type selections to be multi-select where applicable.
* 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)
* B-08205: Expression language API is available for storing [[Storing_Secrets_for_Scripts|secrets]] for scripts.
* Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
* B-07780: Chart [[QPR_ProcessAnalyzer_Chart#Variable_mappings|variable mappings]] has been removed - use the [[Chart_Linked_Settings|linked settings]] instead. Dashboards using variable mappings are automatically converted to use linked settings.
* 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)
* B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
* 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)
* B-08174: Only non-default parameters values are written to the operation log.
* B-08200: Timestamps in System reports are shown in user workstation local time.
* B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
* B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
* B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
* B-08202: Updated copyright for year 2024.
* B-08199: Frontend components have been updated.
* B-08203: Backend components have been updated.
* B-08209: Translations updated for release 2024.2.


'''Fixed issues:'''
===Fixed issues===
* D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
* Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
* D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
* When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
* D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
* Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
* D-13962: System variable values were interpreted incorrectly when used in linked settings.
* Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
* D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
* In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
* D-13959: Removed possibility to add datatable columns with the legacy "any" data type.
* Event type mapping in charts didn't work in object-centric models. (D-14620)
* D-13991: Improved drop-down selector component to handle empty strings as variable values.
* Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
* D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
* Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
* D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
* Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
* D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
* In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
* D-13960: Added missing translations for list of permission list and 12-hour clock format.
* Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
* D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
* Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
* D-13969: Datatable column schema export sometimes showed empty for the key column.
* Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
* D-13862: Session token was not accepted when url path capitalization is different.
* Translation was missing from error messages when deleting items from recycle bin. (D-14652)
* D-13942: Datatable could not be dimensioned if it has column named "CaseId".
* Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
* D-13980: Business calendar dialog crashed when tried to open it for a model without access.
* Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
* D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
* Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
* D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
* Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
* D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
* Fixed incorrect data types in some project, user and group related measures. (D-14619)
* D-13977: Multi-select dropdown lists showed some special characters incorrectly.
* Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
* D-13945: Syncfusion toast message didn't work when text contains ${[]}.
* Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
* D-13930: Pivot table throws javascript error when certain clicks.
* Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
* D-13273: Duplicate datatable row count didn't shown correctly.
* Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
* D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
* Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
* D-13985: Models list dots menu had texts misaligned in narrow screens.
* Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)
* D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
* D-13997: Workspace tables column filtering search caused JavaScript errors.
* D-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
* D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
* D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
* D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
* D-14004: Removed empty filters from queries to optimize them.
* D-13988: Fixed issue where data grid context menu rendered initially as too high.
* D-13979: BPMN model editor element settings use now Open Sans font.
* D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
* D-13984: Fixed the error of refusing to run the JavaScript URL.
* D-14031: ThrownObject property was not included to http error response when error came from the script.


== QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10) ==
===Other improvements===
* 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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
== QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21) ==
Known issue fixed in QPR ProcessAnalyzer 2024.2: In Big data chart, some measures, dimensions and columns have the filtering option missing. The issue concerns for example Duration between events, Path starting/until between specific events, and Cases where event occurs before other selections. Workaround is to set the filter in the chart json settings: the filter can be configured to another expression and copied to the correct expression.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.pdf]
</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 Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime ([[Updating_QPR_ProcessAnalyzer_Server|see more]]). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.
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.
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.
* [[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)
</div>
* [[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)


'''Features:'''
===Fixed issues===
* B-08019: New component [[Design_Diagram|Design Diagram]] for showing user-created diagrams in dashboards where to visualize process mining metrics.
* Fixed following error when performing client-side SAP import: Could not find a part of the path (QPR_ImportSource_Chunk_*.tmp). (D-14589)
* B-08087: Generic [[Dropdown_List_Selector|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* Fixed issue where ManageProjects permission was incorrectly required when running scripts using QPR ScriptLauncher non-legacy mode. (D-14562)
* B-08163: Linked settings support for binding to [[Chart_Linked_Settings#Binding_to_case_attribute_filters_with_attribute_name_and_attribute_values|case attribute filter values without defining case attribute name]].
* 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)
* B-08170: Snowflake model filters can be [[Filtering_in_QPR_ProcessAnalyzer#Filter_actions|saved as new models]] which can be used to create snapshots of part of models.
* Some analyses didn't work, when case ID columns for cases and events datatables differed only in upper/lowercase letters. (D-14556)
* B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
* Business calendar didn't work for some measures/dimensions/columns and some had business calendar checkboxes missing. (D-14563)
* B-08161: Added [[Datatable_in_Expression_Language#Modify|Modify]] function to change datatable properties and improved [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CreateDatatable|CreateDatatable]] function for creating datatables.
* Prediction failed to following error: transformer_model_next_activity/event_year_input_embedding. (D-14551)
* B-08122: Added new system report to list dashboards.
* Scripting now works correctly after rows from PA_OPERATION_STATUS table have been deleted. (D-14545)
* B-08173: Removed legacy filters that didn't have any filter rules.
* Fixed issue where case-centric flowchart was very slow for object-centric model. (D-14544)
* B-07961: In OperationLog, changed parameters to json format and added request id.
* Prevented creating dashboards, models and scripts with duplicate names in the same project. (D-09480)
* B-08069: Added DashboardId property to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* KPI Card now shows line breaks correctly in textual values. (D-14546)
* B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* Improved table Excel export for list data to show items with separator character instead of showing as JSON. (D-14479)
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|DeleteRows]] function to delete rows in datatables with similar logic than SQL delete.
* Column showing non-conformance reason was incorrectly aligned to right. (D-14570)
* B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
* GetRelatedValueFrom function caused column name conflict when used multiple times in same query. (D-14591)
* B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
* Fixed issue where in-memory sorting for arrays gave "Error in sorting analysis result rows possibly due to multiple types of values ...". (D-14592)
* B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
* Array type of values were shown incorrectly when used Last Row Aggregates Over-limit Rows setting. (D-14616)
* B-07689: For datatables, [[Datatable_in_Expression_Language#ForeignKeys|foreign keys]] to other datatables can be defined using expression language.
* Fixed the "Most common" text aggregation sorting error for in-memory calculation. (D-14573)
* B-08176: Translation updates for release 2024.1.
* Snowflake model validation gave incorrect error message when mapped column didn't exist in datatable. (D-14565)
* B-08175: Workspace should show timestamps in user's local time.
* 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)


'''Fixed issues:'''
===Other improvements===
* D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
* D-13916: Chart filter could not be defined for some expressions in Big data chart.
* Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
* D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
* Stringified value format supports also json objects. (B-08766)
* D-13906: In Conformance Analysis, deviating flows were not translated.
* Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
* D-13907: Improved translation related to datatable properties dialog "Used by models" field.
* Translations have been updated. (B-08757)
* D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
* Frontend components have been updated. (B-08760)
* D-13911: Fixed small glitches in the opening and closing of drop-down lists.
* Backend components have been updated. (B-08759)
* D-13918: Datatable could be configured incorrectly to use table for other datatable.
* D-13932: Duplicating datatable with custom table in datasource losed all data.
* D-11002: Removed legacy in-memory prediction preset.
* D-13912: Added check that array cannot be stored to dashboard Content property.
* D-13936: Query designer default query didn't work with Snowflake models.
* D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
* D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
* D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
* D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.


== QPR ProcessAnalyzer 2023.7 (build 4326) (released 2023-11-28) ==
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]
Limitation for the maximum amount of data (B-07636) causes a behavior change in in-memory charts that have the Maximum rows settings empty and have the sorting defined. In certain cases, the order in which measures are evaluated changes (due to an internal performance optimization). If there are custom expressions that define variables, the variables may not be available in other measures anymore. As a resolution, either redefine the variables in those measure expressions or add those measures secondarily to the sorting.
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Default query timeout of 30 minutes has been added for --#ImportOdbcQuery, --#ImportSqlQuery and --#ImportOleDbQuery commands. If a query run is taking longer than the timeout, the query is stopped. The timeout can be adjusted using the '''QueryExecutionTimeout''' parameter. Previously, there has been no timeout, so queries that take more than 30 minutes require configuring a longer timeout.
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
Incorrectly configured [[Chart_Linked_Settings|linked settings]] in charts (available in the ''Advanced'' tab) give now an error message, if they are referring to non-existing measures, dimensions or columns. Previously, incorrect linked settings were ignored. To fix the error message, remove the incorrect linked settings.
* 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)
</div>
* Added a [[Filter_Selectors#Filter_selector|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 [[Measure,_Dimension_and_Column_Settings#Statistical_calculations|Statistical calculation method]]. (B-08598)
* 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)
* 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)
* 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)
* [[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===
* B-07511: Datatables have a [[Datatable_Properties_Dialog|dialog]] to view datatable properties, write description, set the Snowflake source table, add/modify/delete columns, and set the datatable key.
* 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)
* B-08150: Added setting [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters first]] to determine whether chart filter rules or dashboard filter rules are applied first when chart queries are filtered.
* When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
* B-08091: When filtering charts in Snowflake, case attribute filter is created instead of case id filter.
* 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)
* B-08091: [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|New setting]] to define whether cases or events are filtered by default.
* Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
* B-08091: New preset "Looping paths" to detect whether there are repeating patterns of events.
* Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
* B-08091: Duration between events calculation ignores negative durations in Snowflake.
* Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
* B-08091: Chart loading animation has been renewed.
* In in-memory models, array type of data was not dimensioned correctly. (D-14518)
* B-07636: To prevent dashboards from jamming when querying too much data, added [[QPR_ProcessAnalyzer_Chart#Available_Visualizations|limitations]] to the amount of data that charts can visualize. Note that the limitation concerns the aggregated data that is visualized, not the source event log data.
* AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
* B-08017: [[Dashboard_in_Expression_Language|Dashboards API]] has been added to expression language, allowing to create, modify and delete dashboards in scripts.
* Table grouping header labels were not formatted correctly. (D-14514)
* B-08056: Following properties have been added to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|user objects]] in expression language: IsLocked, LastLockedDate, LastLoginDate.
* Fixed Root causes analysis to work with object-centric models. (D-14515)
* B-08053: [[Navigation_Menu#System_Reports|User rights report]] has been refactored to use [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property in the expression language. The change also simplifies the report as now it only shows the direct role assignments that are visible in the [[Manage_Users_and_Groups|User Management]].
* Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
* B-08151: For Snowflake expressions support for following [[SQL_Expressions#Window_functions|windowing functions]]: sum, average, median, min, and max.
* Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
* B-08050: When a model is created, the default filter is not created anymore (this is a refactoring that doesn't have any impact on user interface).
* Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
* B-08123: Translation updates for 2023.7.
* Flowchart SVG export did not show start and end symbols. (D-12401)
* B-08092: Updated backend components.
* 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 issues:'''
===Other improvements===
* D-13876: In CreateSnowflakeConnection function, ProjectId parameter is optional when OdbcConnectionStringKey is not specified.
* Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
* D-13898: Snowflake: Exclude case attribute filter didn't work when there was null values and was selecting at least two values.
* Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
* D-13890: Fixed XES file import to work.
* Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
* D-13894: Business calendar based duration calculation was incorrect in some durations that spanned to several weeks (for Snowflake and in-memory models).
* Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
* D-13899: Using broken OdbcConnectionString in a datatable prevented the datatable from being deleted.
* Frontend components have been updated. (B-08695)
* D-13883: Script run stucked after running a script with error that uses client-side ODBC import.
* Backend components has been updated. (B-08696)
* D-13879: SqlExpressionValue filter when excluding events didn't work with filter rule root expression only.
* D-13896: Adding or removing columns to datatable didn't change the LastModifiedDate.
* D-13882: User details weren't written to operation log when creating or modifying users.
* D-13771: User rights system report didn't give error when changing columns.
* D-13893: Some event filtering caused null pointer error when primary key had been defined.
* D-13873: Fixed pivot table visual issues after component update.
* D-13900: When adding, renaming or removing columns for Snowflake table fails, operation is now rolled back without any changes.
* D-13866: Querying GET api/uielements was quite slow right after server start.
* D-13864: Combinations of translatable and hardcoded strings didn't get translated in UI.


== Additional release for QPR ProcessAnalyzer 2023.6 (build 3933) (released 2023-10-24) ==
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==


'''Features:'''
===New features===
* B-08055: Error message for locked account has been replaced with generic error message, so that username enumeration is not possible.
* 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 issues===
* D-13884: Attributes dialog crashed with some older model configurations.
* 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)
* D-13843: In charts, selected case and event attributes switched away when attribute data type was ShortString.
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
* D-13877: Some Snowflake expressions gave error "exceeds maximum length limit of 255 characters" when selecting lot of items.
* Clustering analysis didn't work with object-centric models. (D-14486)
* D-13878: Snowflake expression filters for case attribute values didn't accept other than string type of case attributes.
* 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)
* D-13871: Some statistical calculations with percentages didn't work with Last Row Aggregates Over-limit Rows setting.
* Deleting last group didn't remove the group from the list. (D-14504)
* D-13875: Using some case level filters in a model without cases datatable didn't work.
* D-13861: Dashboard opens are now logged to the Task log (i.e., calling GET /api/dashboards/{dashboardid}).
* D-13870: Workspace projects hierarchy focused project showed light grey background making the project name not readable.
* D-13867: When starting datatable refresh and going to other tab, went back to Datatables tab when query completed.
* D-13853: If chart Custom Layout settings had extra series defined, chart may have crashed.
* D-13869: Export as CSV button didn't work in the datatable contents dialog when dialog was still loading.
* D-13872: Main progress spinner had unnecessary small scrollbar on top right.
* D-13863: In the REST API method GET /api/users, password field (that has always been null) has been removed.


== QPR ProcessAnalyzer 2023.6 (build 3847) (released 2023-10-17) ==
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==


<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;">
Big data chart support of models with local datatables (i.e., SQL Server stored) is removed in this release. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).
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.
</div>
</div>


'''Features:'''
=== Fixed Issues ===
* B-07992: Added 10 new presets including Queue analysis, Four eyes principle, Self-looping events, and Path until selected event. There are also presets for Individual Cases Flow and Range of event type occurrences which use Gantt chart.
* 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)
* B-08011: Added following date related operations for Snowflake: Day of year, Day of month, Day of week, Week of year, Half-year only, Quarter only, Month only, Hours only, Minutes only, Seconds only, and Milliseconds only. These are available when calculating with date type of data.
* Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
* B-08016: [[QPR_ProcessAnalyzer_Table#Table_actions|Table actions to set variables]] can also be opened to a new browser tab. Also improved user interface for table actions.
* Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
* B-08018: For Snowflake expressions, added Flows aggregations FromEventType and ToEventType to get starting/ending event type, and FlowOccurrences aggregations FromEvent and ToEvent to get starting/ending event.
* 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)
* B-08001: Added [[Generic_Functions_in_QPR_ProcessAnalyzer#CallStoredProcedure|CallStoredProcedure]] function to call Snowflake stored procedures. This allows to start ETL transformation in Snowflake orchestrated by QPR ProcessAnalyzer script.
* B-08013: Added [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property to expression language to replace the legacy UserPermissions analysis (11).
* B-07976: Snowflake [[Filtering_in_QPR_ProcessAnalyzer_Queries#Expression|expression based filter rules]] support additional expression columns allowing more Big data chart expressions to be filterable.
* B-08015: Big data chart doesn't anymore support calculation in SQL Server (using local datatables).
* B-06270: Improved error messages and made them translatable by taking into use exception codes provided by server.
* B-08021: Added possibility to store [[Diagram_in_Expression_Language|designed diagrams]] for models and expression language API for reading and modifying diagrams.
* B-08037: Dropped following unused tables database: PA_IDEA, PA_IDEA_VOTE, PA_REPORT, PA_REPORT_SETTING, PA_SESSION_SERVICE, PA_VIEW_FILTER_RULE, PA_VIEW_FILTER_RULE_PARAMETER.
* B-08052: Language translations have been updated to 2023.6.
* B-08051: Frontend side components have been updated.
* B-08034: Backend side components have been updated.
 
'''Fixed issues:'''
* D-13830: Object counts indicator in header showed incorrect counts when there was disabled filter rules in Snowflake models.
* D-13833: In-memory charts didn't work with boolean type of dimensions when filtering with the false value.
* D-13858: Target value measures didn't update chart when controlled using an on-screen setting.
* D-13827: Calculated attributes data type was incorrectly set as Any by the Attributes dialog.
* D-13849: Multiselect list search didn't allow spaces.
* D-13829: Multiselect dropdown lists height jumped couple of pixels when selecting values.
* D-13835: Deselecting a selected data point didn't remove chart filter rule.
* D-13702: Improved Snowflake query performance in situations when there are lot of filter rules (by decreasing number of CTE's).
* D-13819: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
* D-13820: Fixed incorrect manifest.json file to avoid "not found" errors when fetching web site icon.
* D-13865: Break, continue, and return statements didn't work properly when called from inside a catch block.
* D-13795: There was a Python error in clustering analysis with Snowflake model.
* D-13823: Some tooltips in Workspace project hierarchy didn't work and caused a JavaScript error.
* D-13824: BPMN editor align context menu layout looked strange.
* D-13813: QPR logo button in the top left was misaligned in Firefox.
* D-13797: Snowflake query may have given following error when using sampling: ambiguous column name '_EventType_NotNull_1'.
* D-13774: TakeSample function with certain columns caused SQL compilation error: ambiguous column name 'Case Name'.
* D-13782: Snowflake: Aggregating from variations didn't work when using sampling.
* D-13836: Some tooltips had a strange two-colored background.
* D-13834: Removed Model statistics column from clustering and root causes analysis.
* D-13860: Removed filter button from the custom expressions in Task log analyzed objects.
* D-13838: Removed Split data by filtering column from clustering analysis.
* D-13832: Script and model status updates incorrectly sent next update when previous was still pending.
* D-13839: Charts reset zoom button font size was too small.
* D-13817: Importing data to Snowflake datatable with Append=0 doesn't now drop the underlying Snowflake table.
* D-13825: Some models could not have been deleted from recycle bin.
* D-13852: Recycle bin Projects and Models tab didn't show correct content when Recycle bin only contained either models or projects.
* D-13841: In-memory chart Data type selection type has been corrected to string.
* D-13842: Second time and Third time selections has been hidden in in-memory chart measures.
* D-13850: In Chrome, there were console errors related in incorrect text field autocomplete type and text field without form.
* D-13847: Improved browser side performance by removing unnecessary operations.
* D-13859: Chart without dimensions showed an unnecessary Remove dimension button.
* D-12598: When script is stopped in server, ScriptLauncher could still incorrectly continue to import data.
 
== Additional release for QPR ProcessAnalyzer 2023.5 (build 3334) (released 2023-09-07) ==
 
'''Fixed issues:'''
* D-13826: Measures or dimensions with case or event attribute and value selections incorrectly removed calculated attributes when dashboard was opened or chart settings were changed.
* D-13821: Font size of some Highcharts tooltips was too small. Issue appeared when there were tooltips mappings in measures or dimensions.
* D-13810: Simplified help links: now all Help buttons go to the QPR ProcessAnalyzer wiki main page.
* D-13822: Snowflake clustering analysis showed empty strings and nulls as case attribute values in an unclear way as just nothing.
 
== QPR ProcessAnalyzer 2023.5 (build 3304) (released 2023-09-05) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
== QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)==
In Big Data Chart, the '''Case conformance''' measure and dimension has changed in a way that now it provides boolean values (true/false) instead of integer values (1/0). If [[Measure,_Dimension_and_Column_Settings#Other_settings|colorMappings]] are used for this measure or dimension to set specific colors to visualize conformant and nonconformant cases, the mapped values need to be changed as follows: '''1''' -> '''true''' and '''0''' -> '''false'''. Without the change, the mapped colors are not effective.


Exmaple: Old configuration:
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
<pre>
"colorMappings": {
  "1": "#36d475ff",
  "0": "#f5403bff"
}
</pre>
New configuration:
<pre>
"colorMappings": {
  "true": "#36d475ff",
  "false": "#f5403bff"
}
</pre>
</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;">
Big data chart support of models with local datatables (i.e., SQL Server stored) is deprecated. Big data chart has allowed to process data both in Snowflake and SQL Server. Now the support for SQL Server is deprecated and the Big data chart will only support calculation in Snowflake. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).
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.
</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;">
Following legacy analyses have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). The OperationLog analysis is replaced by the [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog function]] and the Infcluencers analysis is replaced by the [[FindRootCauses_Function|FindRootCauses function]].
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.
 
Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
<pre>
let removedAnalyses = [12, 14, 15, 16, 29];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
By default, Snowflake ODBC driver generates quite much logging to files which might unnecessarily fill up the disk space. It's recommended to set the LogLevel parameter to value 0. The path where the logs are created can be seen in Windows registry (key LogPath). More information about configuring Snowflake ODBC parameters: https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters.
* Enhanced [[AI_Agent|AI Agent]] with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
</div>
* In [[Object-centric_Process_Mining_Model|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 [[Measure,_Dimension_and_Column_Settings#Advanced_settings|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_2.0_Federated_Authentication|SAML authentication]] can now synchronize user groups from identity provider. (B-08612)
* Groups can be [[Manage_Users_and_Groups#Deleting_Group|deleted]] in user management. (B-08330)
* [[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)
* Snowflake [[Clustering_Analysis|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)


'''Features:'''
===Fixed issues===
* B-07971: Machine learning based [[Clustering_Analysis|Clustering analysis]] can be run in Snowflake.
* Fixed a potential issue which could have leaked database connections and caused connection pool starvation. (D-14414)
* B-07989: In dashboard designer the stacking order of charts can be changed with buttons [[QPR_ProcessAnalyzer_Dashboard_Designer#Viewing_and_Editing_Dashboards|Bring to front, Send to back, Bring forward and Send backward]].
* Renewed self-signed certificate used by SAML 2.0 authentication with ten years of validity. (D-14424)
* B-07977: For [[Sankey_Chart|sankey diagram]], added Start level and End level mappings to define custom start and end level for the sankey flows. Implemented also color mappings to define specific colors for specific values.
* Improved CallWebService function to send request body when using DELETE method. (D-14488)
* B-08010: To improve performance, charts are loaded and updated only when they are visible in the dashboard.
* Login page now shows correct error message when there are serious system errors during login. (D-14480)
* B-07975: Added following [[SQL_Expressions#Date_functions|date related functions]] to Snowflake: DayOfYear, DayOfWeek, WeekOfYear, Quarter.
* "Datatable contents (in-memory)" option now works also with Snowflake datatables. (D-14391)
* B-07908: When [[QPR_ProcessAnalyzer_Project_Workspace#Duplicating_Model|model is duplicated]], also filters in the model are also duplicated.
* Added maximum data size limitation to AI assistant to avoid error with large datasets. (D-14419)
* B-07904: Filters and models API for expression language has been completed.
* Day of the Year/Week/Month/Quater selection didn't work with specific event time in in-memory chart. (D-14421)
* B-07991: In [[Filter_Selectors|case and event type filter selectors]], threshold whether the dropdown list or search dialog is shown can be defined using the ''Maximum Rows'' setting. Also the search dialog filters search results by other filter rules in the dashboard.
* KPI card now shows a scrollbar when content doesn't fit to the available space. (D-13428)
* B-07999: Filters report has been changed to use the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|expression language API for filters]].
* Workspace projects hierarchy tooltips didn't show special characters correctly. (D-14430)
* B-07540: Added [[QPR_ProcessAnalyzer_Expressions#Throwing_objects|throw statement]] to expression language.
* BPMN editor crashed when creating filter from tasks giving following error: Cannot read properties of null (reading 'querySelector'). (D-14399)
* B-07813: UI components are updated. There are small visual improvements, such as in flowchart flows are routed a bit differently and in charts the hidden series is shown as strike-through in the legend.
* Value expressions didn't work that are referred in dimension and containing aggregation. (D-13624)
* B-07963: Following legacy analysis types have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29) (see more information in the note above).
* 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)


'''Fixed issues:'''
===Other improvements===
* D-13777: Filters could not be created in charts when "Update Filter During Selection" setting was disabled.
* Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
* D-13767: Automation per Event Types preset in in-memory incorrectly showed only one event type.
* 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)
* D-13756: Changing background color in KPI card didn't have any effect.
* Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
* D-13812: "Exclude events" was incorrectly translated to "Exclure les cas" in French.
* Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
* D-13815: Dashboard designer background grid was not visible in entire area in edit mode. Improved also the grid to match to snapping in move and resize.
* Frontend components have been updated. (B-08638)
* D-13674: Business calendar dialog layout was incorrect when a model with a long name was selected to copy holidays.
* Backend components have been updated. (B-08639)
* D-13811: Table actions link to a new window didn't go to dashboard if there were other parameters in the link.
* Translations have been updated. (B-08640)
* D-13601: Fixed issue where some presets may have given error when attribute value selection and the automatically selected attribute conflicted by the data type.
* D-13753: While Snowflake model was selected, in Filters and User Rights reports the Columns list could not be opened.
* D-13720: Now table column filter and sorting are preserved when resizing or zooming page.
* D-13785: In tables increased number of rows to 20000 that are inspected to get available items shown in Excel-style column filter.
* D-13759: Some statistical calculations had bad performance with large number of rows.
* D-13787: Conformance statistics component didn't have scrollbars when text didn't fit to the visible area.
* D-13788: In-memory "Nonconformance reason" selection caused error when two of them was selected in the same chart.
* D-13783: When Analyzed objects was Generic analysis, column selection incorrectly caused "Analysis has not been selected" error.
* D-13776: When measure name contained quotation mark, notification preview didn't work.
* D-13747: Filtering with integer type of case id with case attribute value filter caused error in Snowflake.
* D-13791: In Firefox, model selection in chart settings didn't show models in the first open.
* D-11984: Recycle bin buttons didn't fit to the screen when screen width was small.
* D-13780: Using CaseId case attribute in clustering analysis did not work with Snowflake 106 cases standard model.
* D-13781: Clustering analysis produced Python error with a certain simple Snowflake model.
* D-13730: Snowflake: Case attribute filtering didn't work when there are cases without row in cases table.
* D-13803: There was chart configuration validation error in browser console when measures were moved into dimensions in Big data chart.
* D-13758: There was performance issue with the Recent tasks system preset.
* D-13793: Snowflake clustering failed when cluster count is larger than case count.
* D-13763: SQL expression based filter rule with Where function to filter events didn't filter anything in Snowflake.
* D-13804: Added missing Millisecond function to Snowflake.
* D-13772: Expression EventLog.Cases.Events caused error "Value cannot be null".
* D-13755: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
* D-13739: When switching between System reports there was error: "Uncaught Error: 2nd dimension not found. at y.getExpressionConfiguration".
* D-12109: Sometimes flowcharts showed message "Error in querying event type measures. Input string was not in a correct format".
* D-12473: Cost Savings by Automation preset gave sometimes error "Unable to cast object of type 'System.Double' to type 'System.String'".
* D-13750: Snowflake model didn't work with the Case Duration vs. Manual Activities preset.
* D-13657: There was error converting data type nvarchar to bigint.
* D-13796: Some Snowflake operations didn't work with zero rows and columns.
* D-12494: Now when chart size changes, the table column filters and sorting are preserved.
* D-13736: In Performance benchmarking dialog, the Export result button exported wrong benchmark performance analysis result.
* D-13609: Improved conformance analysis related filter names.
* D-13594: Recycle bin buttons were not visible when opening recycle bin in a narrow screen.
* D-13226: Tooltips in the model properties dialog are now translated.
* D-12569: Table incorrectly showed ellipsis for narrow boolean type of columns showing checkboxes.
* D-13391: Emptying date or datetime picker value was not registered and it didn't trigger functionality.
* D-12621: Value search dialog didn't work with values containing backslashes.
* D-13796: Some Snowflake operation didn't work with zero rows/columns.


== QPR ProcessAnalyzer 2023.4 (build 2628) (released 2023-06-14) ==
==Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)==


'''Features:'''
=== Fixed issues ===
* B-07767: Added [[Gantt_Chart|Gantt chart]] to visualize timeline of cases and events divided into swimlanes.
* Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
* B-06383: Added [[Sankey_Chart|Sankey chart]] to visualize flow from one set of values to another.
* Fixed issue where AI Agent and LLMComplete function didn't work in Native App. (D-14410)
* B-07941: Implemented many more presets running in Snowflake models for compliance and operational excellence use cases. There are also presets for the path analysis and process bottlenecks identification.
* Fixed translations for Workspace Scripts tab column filter for Status and Result columns. (D-14393)
* B-07864: Snowflake conformance analysis shows now [[Conformance_Analysis#Top_Deviations_(in-memory)_/_Deviating_Flows_(Snowflake)|reasons for conformance deviations]], such as which event occurrences deviated from the design model.
* Fixed issue where Volume Distribution of Flow Analyzed object type didn't work. (D-14390)
* B-07909: Snowflake conformance analysis visualizes [[Conformance_Analysis#Undesired_Events_(Snowflake)|undesired event types]] in table and flowchart.
* Removed reference to fonts.googleapis.com for stylesheets to avoid content-security-policy error. (D-14373)
* B-07823: Flowchart Bottlenecks preset has been changed to show bottlenecks for event types. Also renewed the [[QPR_ProcessAnalyzer_Logs#Task_Log|Tasks reports]] to use expression language based interface.
* Syncfusion dialog headers now show special characters correctly. (D-14407)
* B-07891: User interface has been [[Languages_and_Localization|translated into Portuguese]].
* Object attribute filter gave null reference error when object type didn't exist in model. (D-14379)
* B-07873: Improved [[QPR_ProcessAnalyzer_Pivot_Table|pivot table]] visual layout to highlight totals and aggregated rows. Also the row titles are now visible in the top left.
* B-07905: Added [[SQL_Expressions#Rank_functions|Rank related functions]] to Snowflake for writing more versatile custom KPI's, e.g., FirstValue, LastValue, NthValue, Lead and Lag.
* B-07912: Added more SQL expression [[SQL_Expressions#Array_functions|array functions ArrayToString and ArrayOverlap]] to Snowflake.
* B-06449: Added SQL expression functions ToTimestamp and TryToTimestamp for parsing timestamps from strings using provided format.
* B-07959: Added new functions Base64Encode and Base64Decode to help using basic HTTP authentication when calling web services.
* B-07206: SQL expressions support data [[SqlDataFrame_in_Expression_Language#WithClusterColumn|clustering]] which is an unsupervised machine learning algorithm to group data based on similarities.
* B-07848: Data can be extracted from SAP using the encrypted [[Importing_Data_from_SAP#SNC_encrypted_connection|SNC connection]].
* B-07903: Added expression language API to create and modify filters and models.
* B-03103: [[QPR_ProcessAnalyzer_Logs#Task_Log|Task log]] (operation log) can be accessed in expression language.
* B-07872: List aggregation with Distinct=true orders now items by their value.
* B-07940: Removed "Count" aggregation from textual values in Big data chart (you can use the Case count, Event count, etc. selection instead).
* B-07757: Backend support for datatables linking to user-definable Snowflake database, schema and table.
* B-07825: Improved error message when trying to use non-existing attributes in Snowflake queries.
* B-03101: To expression language, added try-catch-finally statement to handle thrown exceptions.
* B-07861: Removed available and total virtual memory information from User settings dialog.
* B-07902: Optimized sequences of joins in Snowflake queries to improve performance.
* B-07837: Updated backend components.


'''Fixed issues:'''
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==
* D-13709: If image width-to-height ratio was lower than container's ratio, image was incorrectly stretched to fit the container.
* D-13660: Disabling filter rules didn't work in Snowflake models.
* D-13526: Passing dataframes from SQL scripts to expression scripts didn't work.
* D-13661: Snowflake conformance analysis crashed when there was no access to conformance related Snowflake UDF's.
* D-13693: Resolved major Snowflake conformance analysis performance issues in the BPMN model handling.
* D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
* D-13707: In SQL Scripting, the datatable analysis (number 18) didn't always copy the data table contents to the target table correctly.
* D-13653: Big data flowchart Root causes preset showed incorrect legend.
* D-13626: Flowchart froze when converting into big data flowchart and vice versa by modifying chart json settings.
* D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
* D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
* D-13704: In CSV file import, parsing now allows spaces between column separator and text quotation mark.
* D-13598: Chart gave unclear error message when events datatable was not defined.
* D-13655: Improved error messages for BPMN editor and conformance statistics.
* D-13528: Error message for certain erroneous SQL expressions was unclear.
* D-13677: "Flow occurrences with specific case attribute value" selection didn't work for in-memory chart.
* D-13663: Pivot table border line was slightly broken in the header area.
* D-13608: There was incorrect alignment of items in the table paging controls.
* D-13703: Importing CSV file with some special characters to Snowflake failed (due to incorrect escaping in Snowflake staging files).
* D-13708: Duplicating datatable using user defined table, removed data the source table.
* D-13717: Dependency wheel crashed when there were zero weights and showing data labels.
* D-13348: There was an unclear error message when Snowflake query had a certain incorrect expression.
* D-13732: Pivot table Excel export contained headers formatted incorrectly.
* D-13729: There was a JavaScript error when limited user tried to access business calendar.
* D-13662: Percentile function didn't always work with timespan types.
* D-13646: Using incorrectly configured model without cases datatable caused null reference error.
* D-13629: When tried to use chart with a non-existing model, there is now a proper translated error message.


== QPR ProcessAnalyzer 2023.3 (build 1990) (released 2023-05-03) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]


'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* B-07818: [[Conformance_Analysis|Conformance analysis]] is supported in Snowflake with following dashboard components: Big data chart, BPMN editor, Conformance statistics, and Design model selector.
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).
* B-07833: [[Root_Causes#Root_causes_in_flowchart|Root causes analysis for flowchart]] is available for Snowflake showing how the event and flow occurrences explain selected phenomena.
* B-07786: Big data chart has more [[Big_Data_Chart#Measure_aggregations|measure aggregations]], such as median, percentile, standard deviation and variance. Also for textual items, unique values can be listed.
* B-07795: [[QPR_ProcessAnalyzer_Table#Conditional_formatting|Conditional formatting]] supports also columns with non-numerical contents.
* B-07830: [[Big_Data_Chart#Measure_aggregations|None and Any aggregations]] for Snowflake and user-friendly formatting for conformance violations.
* B-06527: Error messages in [[Importing_Data_to_Datatable_from_CSV_File|CSV file import]] show also the column number to help working with CSV files with lot of columns.
* B-07747: In-memory conformance checking accepts design models with multiple tasks having same name (same is followed by the Snowflake implementation).
* B-07659: In-memory flowchart preset Case Conformance to visualize conformance checking violations.
* B-07571: Added function IsConformant to backend to check whether cases are conformant.
* B-07863: Added function ConformanceViolationsFlows to backend to return nonconformance reasons for violating cases.
* B-07844: Support for "array" aggregation to return aggregated items as array.
* B-07856: Support for creating and accessing arrays and objects in SQL expressions.
* B-07860: Array handling functions and Tasks property for DesignModel entity.
* B-07847: Added throttling for QPR ScriptLauncher client-side imports to limit memory usage.
* B-07811: Snowflake query optimization to omit columns that are not used by the query.


'''Fixed issues:'''
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:
* D-13632: Going from variations to event types led to very poor performance with certain models.
<pre>
* D-13628: Statistical calculations were incorrectly not applied in chart CSV export.
Models.Where({
* D-13575: SQL script may have given error "Operand type clash: nvarchar(max) was incompatible with sql_variant".
let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
* D-13597: UI supports now datatable column type "ShortString" (previously datatable contents preview and CSV import didn't work).
return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
* D-13536: Using business calendar sometimes gave error "System.InvalidOperationException: Collection was modified".
}).(Name + " (id: " + Id + ")");
* D-13477: Chart types without y-axis mapping caused an error when series mapping was used.
</pre>
* D-13453: _model variable was not available for Snowflake expression filter rules.
</div>
* D-13527: Checkbox height didn't increase when long label needed to span to multiple lines.
* D-13363: Snowflake query with EvaluateAfterAggregations and IsHidden failed when dimensioning by case id column.
* D-13383: Snowflake query gave error "Invalid column name 'FromCase Name'".
* D-13523: Request id was incorrectly shown as zeros in error messages.
* D-13541: In CSV import, error message for maximum number of columns exceeded is improved (maximum is 300 column for SQL Server).
* D-13583: Objects count in header didn't work for empty Snowflake model.
* D-13553: Larger pacm files can now be imported, as there isn't error "Request body too large. The max request body size is 30000000 bytes".
* D-13306: Stack overflow error was given when using SqlDataFrames.
* D-13487: When Flows root and there was filter in Values expression, some flows were lost.
* D-13540: SqlDataFrame query with 300 columns failed to error "WithExpressionColumn: No name given for the new column".
* D-13429: Ordering in List aggregation couldn't find columns in dataframe query.
* D-13406: Dataframe query with root FlowOccurrences and get value from cases caused error.
* D-13538: There was incorrect handling of escaping characters in column names used in dimensions.
* D-13633: Fixed ordering in List aggregation with null and empty values.
* D-13636: Query that dimensions by numeric case attribute with AggregateOthers true, caused error.
* D-13589: Creating Snowflake datatable did not connect to Snowflake.
* D-13623: Value expressions without aggregation didn't work with AggregateOthers setting.
* D-13554: In in-memory chart, percentile function might have return both Int64 and Double type of objects which cannot be sorted.
* D-13481: Improved error message when trying to use deleted model.
* D-13621: Dynamic value search dialog had incorrect font in lists.
* D-13610: Some invalid BPMN files crashed BPMN editor.
* D-13614: Checkbox label texts overflowed to right.
* D-13520: Removed excessive parameters from the Query Designer for generic context queries.
* D-12998: QPR icon was incorrectly positioned in header in Safari.
* D-13480: Import to duration data type is removed from Snowflake datatables, and for local datatables duration type maximum size is checked.
* D-13517: In Highcharts-based visualizationsm conditional formatting didn't work for other than the first y-axis mapping.
* D-13529: In some presets containing several on-screen settings, when chart showed in error message, on-screen settings showed invalid selection.
* D-13530: Opening dropdown list caused JavaScript error when the list contents should be empty after it previously contained items.
* D-13486: Removed unreachable error message in CSV import.
* D-13524: Fixed in-memory chart flow occurrences root measures "Event attribute (text)" and "Event attribute (number)" that caused error.


== QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
 
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.
'''Features:'''
</div>
* B-07755: [[Business_Calendar|Business calendar]] for duration calculation is available for Snowflake models.
* B-07719: In Snowflake dashboards, [[Big_Data_Chart#Using_measure_variables|measures can be assigned to variables]] and use the variables in other measures to create combined measures.
* B-07746: Changed in-memory conformance checking to not show invalid flow violations where starting or ending event type is invalid.
* B-07743: [[PA_Configuration_database_table#General_Settings|Default datasource]] can be configured for datatables created by scripts, allowing to set Snowflake as default.
* B-07740: System memory indicator moved from the header to User settings Version information dialog.
* B-07776: New SQL expressions functions Unicode, Char and Regexp, as a basis for future rule-based process mining.
* B-07741: Backend support for aggregation operations Median, Percentile, Stdev, Stdevp, Var and Varp to Snowflake.
* B-07742: Backend support for aggregation operation to list unique items in Snowflake.
* B-07770: Optimized Snowflake SQL generation by combining consecutive WithColumn function calls into one select.


'''Fixed issues:'''
===New features===
* D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
* D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
*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)
* D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
*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)
* D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
*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)
* D-13405: Images take now always all available space in image component area.
*Home screen has been removed, and [[QPR_ProcessAnalyzer_Project_Workspace|Workspace]] has new card layout and other UX improvements. (B-08541)
* D-13417: KPI card without title was slightly misaligned vertically.
* Added [[Filtering_in_QPR_ProcessAnalyzer#Saving_filters|filter description]] field to filter properties dialog. (B-08451)
* D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
*Removed event type existence check from charts, so that non-existing event types are allowed. (B-08585)
* D-13350: Task log and Script log default filter end date is now empty by default.
*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)
* D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
*Improved detection of invalid models by adding [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CheckModelValidity|CheckModelValidity]] function returning model validation errors. (B-08426)
* D-13347: Improved performance for in-memory business calendar calculation.
* D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
* D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
* D-13451: Exported filter file is now named based on selected filter name.
* D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
* D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
* D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
* D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
* D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
* D-13456: Improved error messages for incorrectly configured on-screen settings.
* D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
* D-13421: Improved error messages when trying to use model having some column mappings missing.
* D-13485: Snowflake business calendar gave error when calendar contained Sunday.
* D-13218: Windows event viewer incorrectly contained log entries that are not errors.
* D-12634: Multiline text boxes width is set to non-changeable.
* D-13034: Confirmation dialog to delete items permanently has been updated.
* D-13288: In dialogs, the Create button didn't show the disabled state correctly.
* D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
* D-13483: In Workspace, the new items menu was too narrow for Spanish texts.


== Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24) ==
===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)


'''Features:'''
===Other improvements===
* B-07690: System setting [[PA_Configuration_database_table#General_Settings|DatabaseId]] can be defined by administrator to get more simple table names in Snowflake.
*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)
* B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
*Backend support for [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|object-centric filter rules Disabled flag]]. (B-08611)
* B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
*Implemented Entity Framework based database initialization and migrations. (B-08566)
* B-07663: In [[Chart_On-screen_Settings|on-screen settings]], when case/event attribute is selected, related attribute values list are reset.
*Added support for following Entity Framework database providers: SQL Server (full), Snowflake Hybrid Tables (experimental), PostgreSQL (experimental). (B-08581)
* B-07570: Backend support for [[Business_Calendar|business calendars]] in Snowflake.
*Frontend components have been updated. (B-08597)
* B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
*Backend components have been updated. (B-08596)
* B-07610: Memory counter related technical properties have been removed from expression language.
*Translations have been updated for release 2025.2. (B-08607)
 
'''Fixed issues:'''
* D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
* D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
* D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
* D-13358: Calculation results caching works also across different user sessions.
* D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
* D-13230: SAP import did not automatically create columns to use the correct column types.
* D-12857: Deeply recursive functions caused a crash without any trace.
* D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
* D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
* D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
* D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
* D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
* D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
* D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
* D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
* D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
* D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
* D-12991: Dropdown list texts had some translations missing.
 
== QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing <pre>"preset": "RootCauses"</pre> and the comma from the preceding line.
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
==QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)==
Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
<pre>
let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
Starting from QPR ProcessAnalyzer 2023.1, the '''.NET Desktop Runtime''' is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, ''.NET Desktop Runtime'' is not needed, but instead install the '''.NET Runtime''' (which is more lightweight). ''.NET Desktop Runtime'' contains the ''.NET Runtime'', so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.
*B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
</div>
*B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
*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]].


'''Features:'''
===Fixed issues===
* B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* B-07383: Improvements to linked settings to allow binding to variables, tags and filter rules [[Chart_Linked_Settings|(more information)]].
*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.
* B-07508: Flowchart preset colors have been renewed to be more intuitive.
*D-14346: Fixed issue where manual activation using activation utility didn't work.
* B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|(more information)]].
*D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* B-07440: Date when the release was made is now shown in User settings.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
* B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
*D-14331: Flowchart lost selection when flowchart used linked variables with array values.
* B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
*D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
* B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
*D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
* B-07637: Language selector now shows the language options in local languages.
*D-14342: Flow step and Zoom settings control have same size and layout is aligned.
* B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
*D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
* B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
*D-14327: AI Assistant had console error when pressing send button without text.
* B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
*D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
* B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
*D-14321: Added error message for AI Assistant when trying to use it without model selected.
* B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
* B-07716: ShortString columns are now properly detected in SQL Server queries.
* B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
* B-07688: AddColumns function for Datatables to create multiple columns in one call.


'''Fixed issues:'''
===Other improvements===
* D-13092: Table conditional formatting didn't work when color code was fetched from other column.
* B-08391: Datatable access has been optimized improving performance for object-centric models.
* D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
*B-08529: Added support for array type in stringified value format.
* D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
*B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
* D-13104: In BPMN model editor, context menus to edit elements didn't appear.
*B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
* D-12939: Script editor tabs Close buttons didn't work.
*B-08544: Frontend components have been updated.
* D-13154: "Search by case ID" didn't work in in-memory chart.
*B-08561: Updated translations for release 2025.1.
* D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
* D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
* D-12928: Pivot table headers were empty when there were two column levels and two values.
* D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
* D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
* D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
* D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
* D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
* D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
* D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
* D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
* D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
* D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
* D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
* D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
* D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
* D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
* D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
* D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
* D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
* D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
* D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
* D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
* D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
* D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
* D-12937: Added maximum value limitation to several number input fields in charts.
* D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
* D-12948: Defining column setting caused error when Measure Expression was not defined.
* D-12946: Filter rule text couldn't be seen entirely from tooltip.
* D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
* D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
* D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
* D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
* D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
* D-13116: BPMN editor had some translations missing.
* D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
* D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
* D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
* D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
* D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
* D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
* D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
* D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
* D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
* D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.


== Old Releases ==
== Old Releases==
See older releases in [[QPR ProcessAnalyzer Release Archive]]
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"