QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
(216023)
 
Line 1: Line 1:
This page introduces each new QPR ProcessAnalyzer release.
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.


== Latest Release: QPR ProcessAnalyzer 2014.4 (release date 28.11.2014)==
== Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11) ==
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]


'''Features''':<br/>
===New features===
- It is now possible to configure LDAP authentication to be used as [[Authentication Methods|a user authentication method]].<br/>
* Presets for [[AI_Root_Causes|AI Root Causes analysis]] based on Snowflake Top Insights. (B-08889)
- When performing an operation in QPR ProcessAnalyzer, the status of each operation is now shown in more detail in the [[Progress Status]] dialog to enable monitoring its progress.<br/>
* Added new [[Range_Filter|filter selector]] to easily filter date and number ranges. (B-08877)
- There is a new [[Progress Log]] listing the recent operations and their progress.<br/>
* Projects can be browsed in the [[Navigation_Menu|navigation menu]] to access all dashboards, and organized the menu into two columns. (B-08708)
- Microsoft .NET 4.5.1 Framework has been taken into use.<br/>
* When [[Embed_to_Website|embedded to another website]], SAML authentication is performed in a separate window for more robust operation. (B-08871)
- The contents of the SAP where clause parameters used in the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]] are now visible in the [[Script Log]] after the script is finished.<br/>
* [[AI_Agent|AI Agent]] runs the language model query using the Snowflake account where the selected model is located. (B-08860)
- The [[Template:Activating QPR ProcessAnalyzer|activation level limits]] have been updated.


'''Fixed Bugs''':<br/>
===Fixed issues===
- 213258: Fixed an issue where generating the Operation Log using the "All" option for the maximum row count caused an error.<br/>
* If DefaultUiLanguage in PA_CONFIGURATION table was not defined, users who haven't changed language could not login. (D-14706)
- 213703: Fixed an issue where list customization was lost when opening an element.<br/>
* Improved performance when opening dashboard was sometimes very slow. (D-14705)
- 215330: Fixed an issue where some unicode characters were not properly handled in equality checks.<br/>
* Native App didn't show the version number and build timestamp correctly. (D-14703)
- 215381: A warning message is now displayed to the user before the start of copying a large model.<br/>
* Snowflake Native App activation failed with a custom compute pool if container service was in the suspended state. (D-14722)
- 215474: The HealthcareData sample file now contains instructions for using the sample data.<br/>
* Server stuck when trying to generate SQL for SqlDataFrame having multiple columns with the same name. (D-14730)
- 215517: Fixed an issue where the user got a system exception when trying to open a model that was larger than allowed for the user's product activation.<br/>
* Snowflake DurationBetweenDates function calculated incorrectly when used in a in divisor. (D-14723)
- 215677: Fixed an issue where illegal characters in an Excel sheet tab name caused the model import to fail.<br/>
* In eventlog prediction, fixed issues preventing the usage of case attribute value prediction. (D-14702)
- 215678: Fixed an issue related to the handling of broken bookmarks.<br/>
* Import now succeeds when importing Snowflake datatables refering to data where there is no access. (D-14694)
- 215691: Fixed an issue where no log was written when opening a sample file failed.<br/>
* Fixed incorrect color in table column filters, and Workspace loading time has been improved. (D-14704)
- 215695: Fixed an issue where the View setting panel disappeared in Excel Client when a bookmark was opened.<br/>
* Fixed issue where dropdown list with projects shows "undefined" in place of project id. (D-14659)
- 215715: Fixed an issue where Event Analysis showed an incorrect number of events in the A1 cell.<br/>
* Fixed issue where specifying a secret name longer than 440 characters, prevented saving the secret and resulted in an error. (D-14674)
- 215741: Fixed an issue where Variation Analysis was not working correctly on Finnish and German Excel.<br/>
* SAML authentication failed when it needed to create a new user to QPR ProcessAnalyzer user management. (D-14717)
- 215773: Fixed an issue where sandbox related information was missing from the Excel log.<br/>
* Fixed issue where SQL dataframe queries didn't work if root expression ended to a semicolon. (D-14714)
- 215837: Fixed an issue where running a script with ImportSAPQuery commands failed randomly.<br/>
* Specific Snowflake query with comparison criteria, AggregateFrom and GetValueFrom functions gave error about invalid identifier. (D-14718)


== Next Release: QPR ProcessAnalyzer 2015.1 ==
===Other improvements===
* [[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|Content-Security-Policy HTTP header]] has been changed to more secure by removing the script-src 'unsafe-eval' directive. (B-08897)
* Added [[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|security related HTTP headers]]: X-Permitted-Cross-Domain-Policies, Cross-Origin-Embedder-Policy, Cross-Origin-Opener-Policy, Cross-Origin-Resource-Policy, Referrer-Policy, Permissions-Policy, and remove  img-src &quot;blob&quot; from CSP. (B-08879)
* Implemented backend support for [[SqlDataFrame_in_Expression_Language#:~:text=TopInsights|Snowflake Top Insights for AI root causes analysis]]. (B-08664)
* Optimized database queries and reduced log writing. (B-08870)
* For more understandable error messages, error handling and error message generation have been refactored. (B-08754)
* Frontend components have been updated. (B-08899)
* Backend components have been updated. (B-08898)


'''Features''':<br/>
== Latest Release: QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01) ==
- Four new analysis types (Model Report, Project Report, Data Table Report, and Script Report) are now available for the [[Data_Extraction,_Transformation,_and_Loading#--.23GetAnalysis|GetAnalysis]] command when running scripts.<br/>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_6.pdf QPR_ProcessAnalyzer_2025_6.pdf]
- The [[Progress Status|Progress Status dialog]] now shows the Excel add-in activity figures for ongoing operations.<br/>
- A new CatchOperationExceptions parameter and related script variables are now supported by QPR ProcessAnalyzer [[Data_Extraction,_Transformation,_and_Loading|script commands]].<br/>


'''Fixed Bugs''':<br/>
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- 215229: Fixed an issue related to the limit of model creation as the Evaluator user.<br/>
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).
- 215360: Fixed an issue where the selections on the Settings pane were not updated after running a script.<br/>
</div>
- 215515: Fixed a performance issue related to selecting several groups or models in Project Workspace.<br/>
- 215707: Fixed an issue where the user received an error message when opening a bookmarked view.<br/>
- 215818, 215969: Fixed layout related issues when using the 150% font size setting in the operating system.<br/>
- 215855: Fixed an issue related to timestamps when importing events.<br/>
- 215867: Fixed a memory issue which occurred when using the ExecuteInClientSide function.<br/>
- 215959: Fixed a performance issue related to importing events.<br/>
- 215960: Fixed a performance issue related to opening Project Workspace.<br/>
- 215980: Fixed a layout related issue for drop-down menus in some Analysis views.<br/>
- 216023: Instead of the Exit script command accepting invalid RunScriptId parameter values, an exception is now thrown. In addition, the RunScriptId parameter can now have an empty value.<br/>


__TOC__
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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:


== Past Releases ==
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>


=== QPR ProcessAnalyzer 2014.3 (release date 16.9.2014) ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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>


'''Features''':<br/>
===New features===
- Activation is now required for running a [[Installing_QPR_ProcessAnalyzer#Installing_QPR_ProcessAnalyzer_Service|QPR ProcessAnalyzer Service]].
* [[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)
* 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)
* 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)
* Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* 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)
* 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)
* 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 [[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)
* 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)


'''Fixed Bugs''':<br/>
===Fixed issues===
- 213234: Fixed an issue where an error message occurred after deleting a model.<br/>
* Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
- 213784: Fixed an issue in which the internal SQL data type was not supported by Excel for showing in the report.<br/>
* When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
- 213785: Fixed an issue where an overflow of text data in a single cell occurred.<br/>
* Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
- 213811: Fixed an issue where opening the Path analysis of some models hanged the Excel client.<br/>
* Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
- 214106: Fixed a script import issue by removing the support for .pasql import.<br/>
* In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
- 214612: Fixed an issue where a violation of unique key constraint occurred due to duplicate global ID's.<br/>
* Event type mapping in charts didn't work in object-centric models. (D-14620)
- 215017: Fixed an issue where cancelling an open Workspace dialog caused an exception.<br/>
* Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
- 215026: Fixed an issue where trying to import a Data Table via SQL query as an administrator resulted in an error message.<br/>
* Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
- 215044: Fixed an issue with client version mismatch dialog.<br/>
* Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
- 215165: Fixed an issue where opening a Data Table with the name 'Events' in the Excel client resulted in opening the Settings pane for Event analysis.<br/>
* In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
- 215183: In the Activation Utility, 'Next' is now the default button instead of 'Back'.<br/>
* Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
- 215230: Fixed an issue where the first cell of a column in the Excel client was in a different format than the others.<br/>
* Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
- 215276: Fixed an issue where an error occurred when an ETL script tried to create a table that already existed in the sandbox database.<br/>
* Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
- 215331: Fixed an issue where you couldn't log in to another database after the current database was deleted.<br/>
* Translation was missing from error messages when deleting items from recycle bin. (D-14652)
- 215394: Fixed an issue in the Web Client where event attributes in the Influence analysis were included in the attributes list in the Settings pane.<br/>
* Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
- 215449: Fixed an issue where the official sample file, SAP_OrderToCash, could not be opened from the Excel client.<br/>
* Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
- 215453: Fixed an issue where an error occurred when trying to import event data to a model as a case attribute.<br/>
* Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
- 215472: Fixed an issue where deleted filters were not removed completely from a model.<br/>
* Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
- 215473: Fixed an issue where an empty Flowchart view caused the View title also to disappear from the current view.<br/>
* Fixed incorrect data types in some project, user and group related measures. (D-14619)
- 215482: Fixed an issue where copying a model failed if the attribute type was GUI.<br/>
* Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
- 215492: Fixed an issue where an error message was shown if a user tried to import large amount of case attributes, event attributes or a data table with many columns.<br/>
* Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
- 215498: Fixed an issue where an error occurred when the database connection to QPR ProcessAnalyzer was lost.<br/>
* Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
- 215506: Fixed an issue where the analysis drawing duration in Excel was missing.<br/>
* Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
- 215513: Fixed an issue where an error occurred when trying to load a big table to a temporary table in the script with the GetAnalysis command.<br/>
* Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
- 215515: Fixed an issue where selecting a group of models/projects in Project Workspace caused slowness.<br/>
* Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)
- 215630: Logs were added for checking the sandbox connection when QPR ProcessAnalyzer Xpress is connected to LocalDB.<br/>


=== QPR ProcessAnalyzer 2014.2 (release date 18.6.2014) ===
===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)


'''Features''':<br/>
== QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21) ==
- For optimization purposes, the internal database format has been changed for event and case attributes (see [[Migrating_to_QPR_ProcessAnalyzer_2014.2|Migrating to QPR ProcessAnalyzer 2014.2]]). <br/>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.pdf]
- A limit has been introduced for the number of attributes in a model, so there can now be a maximum of 300 case attributes or event attributes in one model.<br/>
- Scripts now have the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSqlQuery|ImportSqlQuery]] command available for extracting data from an ADO.NET source (the SQL Server database) and importing it to QPR ProcessAnalyzer.<br/>
- Scripts now have the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportOleDbQuery|ImportOleDbQuery]] command available for extracting data from an OLE DB source and importing it to QPR ProcessAnalyzer.<br/>
- The commands [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]], [[Data_Extraction,_Transformation,_and_Loading#--.23ImportOdbcQuery|ImportOdbcQuery]], [[Data_Extraction,_Transformation,_and_Loading#--.23ImportOleDbQuery|ImportOleDbQuery]] and [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSqlQuery|ImportSqlQuery]] now have a new parameter 'ExecuteInClientSide' which makes it possible to execute these commands in the client side also when using QPR ProcessAnalyzer Pro.<br/>
- The [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]] command now has a new parameter 'SapFunction' which makes it possible to specify the value for the SAP function to be called.


'''Fixed Bugs''':<br/>
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- 214783: Fixed an issue where animation did not work correctly when using Flowchart benchmarking view.<br/>
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.
- 214842: Fixed an issue where there are projects with the same name, calling the project by its name in an ETL script targeted one of the projects randomly.<br/>
</div>
- 215160: Fixed an issue where animation did not work for cases with empty attribute values in benchmark settings.<br/>


=== QPR ProcessAnalyzer 2014.1 (release date 23.1.2014) ===
===New features===
'''Features''':<br/>
* [[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)
- The [[Operation Log|Operation Log]] now shows the Last Polling Time related to the new asynchronous web service interface in QPR ProcessAnalyzer.<br/>
* [[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)
- Version numbering scheme in QPR ProcessAnalyzer was updated.<br/>
* [[Filtering_in_QPR_ProcessAnalyzer|Flows and variations can be filtered]] from any event attribute viewpoint in Snowflake. (B-08737)
- Scripts now have the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportOdbcQuery|ImportOdbcQuery]] command available for extracting data from an ODBC source and importing it to QPR ProcessAnalyzer.<br/>
* Added [[Project_Properties_Dialog|project properties dialog]] for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
- In [[Flowchart_Animation#Selecting_a_Case_for_Drill-down_Analysis|animation]], it is now possible to select one or several cases and perform drill-down analysis on them.<br/>
* [[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)


'''Fixed Bugs''':<br/>
===Fixed issues===
- 214640: Fixed an issue where opening the Workspace dialog as an Administrator user took long.<br/>
* Fixed following error when performing client-side SAP import: Could not find a part of the path (QPR_ImportSource_Chunk_*.tmp). (D-14589)
- 215003: Fixed an issue where opening the Workspace dialog took a long time when there were many Data Tables containing a lot of rows.<br/>
* Fixed issue where ManageProjects permission was incorrectly required when running scripts using QPR ScriptLauncher non-legacy mode. (D-14562)
- 214661: Fixed an issue where variation string was incorrect in Case Analysis if Event Types had been filtered.<br/>
* 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)
- 214736: Fixed an issue where transferring a large Data Table (1000000 rows containing more than 1GB data) to a temporary table resulted in a timeout exception.<br/>
* Some analyses didn't work, when case ID columns for cases and events datatables differed only in upper/lowercase letters. (D-14556)
- 214995: Fixed an issue where importing a large .csv file into a single Data Table in a project created multiple projects and Data Tables.<br/>
* Business calendar didn't work for some measures/dimensions/columns and some had business calendar checkboxes missing. (D-14563)
- 215006: Fixed an issue where the "Append = 0" parameter didn't work when importing data into Data Tables.
* 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)


=== QPR ProcessAnalyzer 4.7 (release date 20.11.2013) ===
===Other improvements===
'''Features''':<br/>
* When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
- Scripts now have the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]] command available for extracting data from a SAP system and importing it to QPR ProcessAnalyzer.<br/>
* Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
- The Flowchart Analysis can now be made to show the progress of each case as an [[Flowchart Animation|animation]].
* 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 4.6 (release date 9.10.2013) ===
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==
'''Features''':<br/>
- Added the "Show", "Title", and "SheetName" parameters for the [[Data Extraction, Transformation, and Loading#--.23GetAnalysis|GetAnalysis]] command and the "SheetName" parameter for the [[Data Extraction, Transformation, and Loading#--.23ShowReport|ShowReport]] command.<br/>
- It is now possible to start executing other scripts by using the new "RunScriptId" parameter of the [[Data Extraction, Transformation, and Loading#--.23Exit|Exit]] command.<br/>
- Added support for a number of [[Data_Extraction,_Transformation,_and_Loading#Script_Variables|Script Variables]] that can be used for getting various information about the QPR ProcessAnalyzer environment as well as the Analysis Settings and analysis object selections that the current user has made.<br/>
- Scripts now have a [[Data_Extraction,_Transformation,_and_Loading#--.23SendEmail|SendEmail]] command available for use with notification purposes.<br/>


'''Fixed Bugs''':<br/>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]


- 214286: Fixed an issue where in some cases it was impossible to log in to the PA service.<br/>
===New features===
- 214354: Fixed an issue where an exception was thrown when a large CSV file was imported to a data table.<br/>
* 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)
- 214393: Fixed an issue where bookmarks didn't remember excluded cases.<br/>
* Added a [[Filter_Selectors#Filter_selector|generic filtering component]] that can be configured for creating any type of filters for distinct values. (B-08654)
- 214404: Fixed an issue where an error occurred after a project was deleted.<br/>
* 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)
- 214422: Running an empty script caused ProcessAnalyzer Excel client to hang. Now it doesn't.<br/>
* 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)
- 214437: Fixed an issue where importing case attributes or events from a large CSV file created multiple models.<br/>
* 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)
- 214441: Fixed an issue where the @_FilterId variable was not updated properly.<br/>
* 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)
- 214455: Fixed an upgrade issue in QPR ProcessAnalyzer installer.<br/>
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Logging|Native app logging]] has been improved and now sharing application logs with QPR is possible. (B-08661)
- 214458: Fixed an issue where an exception was thrown when Manage Scripts button was clicked after the session had expired.<br/>
* Added [[DataFrame_in_Expression_Language#CsvToDataFrame|CsvToDataFrame]] function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)
- 214407: QPR ProcessAnalyzer now remembers the SQL Import Connection String and SQL Query values during the login session.<br/>
- 214254: Increased the size of the drop-down selection list of import target models so that longer names can be shown.<br/>
- 214271: Added some descriptions for the [[Filters#Filters|Filter Rules]].<br/>


=== QPR ProcessAnalyzer 4.5 (release date 28.8.2013) ===
===Fixed issues===
'''Features''':<br/>
* 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)
- [[Data Extraction, Transformation, and Loading#--.23ImportSalesforceQuery|ImportSalesforceQuery]] command for importing data from Salesforce cloud into [[Data Table|Data Tables]] and temporary tables using a script.<br/>
* When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
- To help in developing scripts, the Project Workspace dialog now has a tab that lists all the [[Workspace#Data_Tables|Data Tables]] in the selected project.<br/>
* 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)
- There are now [[Script Management#Script Manager|Script Manager]] and [[Script Management#Script Properties|Script Properties]] dialogs available for managing and developing scripts.<br/>
* Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
- It is now possible to define the target model for the ImportEvents, ImportCaseAttributes (formerly "ImportCaseData"), and RemoveEvents [[Data Extraction, Transformation, and Loading|script]] commands.
* 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)


'''Fixed Bugs''':<br/>
===Other improvements===
- 213970: The import functionality was refactored.<br/>
* Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
- 213988: The values shown in various analysis fields are now rounded to two or three decimal fractions depending on the analysis. In addition, if a value is exactly 0, only 0 is shown.<br/>
* Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
- 213965: Fixed an issue where a "ButtonClick" error was given when the Cancel button was clicked on login after the session had expired.<br/>
* Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
- 214134: Fixed an issue where the QPR ProcessAnalyzer installer didn't install sample files when installing to Microsoft Office 2013.<br/>
* Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
- 214015: Added a note to QPR ProcessAnalyzer Wiki, that in some scenarios when installing QPR ProcessAnalyzer, the computer may reboot without prompting the user.<br/>
* Frontend components have been updated. (B-08695)
- 213871: Fixed an issue where some QPR ProcessAnalyzer Service users were not visible to even Administrator users.<br/>
* Backend components has been updated. (B-08696)
- 213966: Fixed an issue where an error message was given when filter properties of a deleted model were opened.<br/>
- 213903: Fixed an issue where the user was thrown out of QPR ProcessAnalyzer Service after a failed import operation.<br/>
- 211971: Fixed an issue where Path Analysis event boxes were incorrectly named when a long name was given to them.<br/>
- 214181: Added troubleshooting instructions for dealing with "Invalid Object Name" exception when running a script with #GetAnalysis and #ImportEvents commands.<br/>
- 214053: Added notes to QPR ProcessAnalyzer installer and Wiki, that Microsoft Excel should not be running or started during installation.<br/>
- 214040: Fixed an issue where the copied model and the source model were not identical.<br/>
- 214052: Fixed an issue where the selected filter name was not updated in the Benchmark Filter menu.<br/>
- 214249: Some terminology changes were made: "Script Text" -> "Script Code", "ViewId" -> "FilterId", "ViewName" -> "FilterName", and "@_ViewId" -> "@_FilterId".<br/>
- 213686: The Flow Analysis performance was optimized a bit.<br/>
- 213841: The Include Only and Exclude buttons are now enabled in Path Analysis.<br/>
- 214115: Fixed an issue where exporting a deleted model caused an error.<br/>


=== QPR ProcessAnalyzer 4.4 (release date 10.6.2013) ===
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==
'''Features''':<br/>
- [[Data Extraction, Transformation, and Loading#--.23ShowReport|ShowReport]] command providing customized reporting.<br/>
- Importing data to [[Data Table|Data Tables]] using the Excel Client.<br/>
- Support for Windows 8 and Microsoft Office 2013.<br/>
- [[Data Extraction, Transformation, and Loading#--.23Exit|Exit]] command for stopping script execution.<br/>
- [[Data Extraction, Transformation, and Loading#--.23ImportDataTable|ImportDataTable]] command for importing data into [[Data Table|Data Tables]] using a script.


'''Fixed Bugs''':<br/>
===New features===
- 213486: Querying event attribute values in Case Analysis is now faster.<br/>
* 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)
- 213565: Fixed the issue where the progress indicator moves back and forth between 100% and 90% when copying or importing large models.<br/>
- 213780: Fixed the wrong date format in 64-bit Excel Operation Log.<br/>
- 213736: It is no longer possible to try login to the QPR ProcessAnalyzer Web Client unless both Login name and Password have been given.<br/>
- 213832: Added scrollbar for the QPR ProcessAnalyzer Web Client Bookmark view's Navigator pane.<br/>
- 213873: In QPR ProcessAnalyzer Excel Client, fixed an issue where error was given if the A1 cell was in edit mode and a button was clicked.<br/>
- 213540: Fixed the formatting of Duration Days values to include only two decimals in QPR ProcessAnalyzer Excel Client Case Analysis.<br/>
- 213946: Fixed an issue where model export didn't work in QPR ProcessAnalyzer Excel Client.<br/>
- 213993: Improved performance of Flowchart Analysis when benchmarking by both start and event attributes.<br/>


=== QPR ProcessAnalyzer 4.3 (release date 23.4.2013) ===
===Fixed issues===
- [[Data Extraction, Transformation, and Loading|ETL]] capabilities within QPR ProcessAnalyzer for script based transformations, data validations, and extended analysis using load scripts<br/>
* 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)
- [[Duration Analysis]] - added grouping by Week, Quarter, and Year for easier analysis<br/>
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
- Variation Ids in [[Cases|Case Analysis]] for allowing benchmarking by process variation<br/>
* Clustering analysis didn't work with object-centric models. (D-14486)
- Enhanced [[User Rights Report]] for easier user administration and access rights settings<br/>
* 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)
- 32-bit and 64-bit versions available from one installer package for easier delivery<br/>
* Deleting last group didn't remove the group from the list. (D-14504)
- New [[Start]] button and Login window allow automatic login and now also support logout<br/>
- [[Full Screen Mode|Web Client Full Screen Mode]] for maximixing screen space for large graphs and allowing browser based zoom<br/>
- Web Client - improved [[Variation Analysis (Web Client)|Variation Analysis]] visualization for showing the variations in a graphical format<br/>
- Updated product names: As an existing user, sign-up normally by choosing the Pro option. More options to be released soon...<br/>


=== QPR ProcessAnalyzer 4.0 - Collaboration Release ===
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==
- '''Web User Interface''' – Interactive Process Discovery & Analysis with web browser <br/>
- '''Collaboration''' – Share analysis results, comments and ideas within the project group <br/>
- '''Project Workspace''' – Process models are grouped to projects <br/>


=== QPR ProcessAnalyzer 3.11 - Web Portal ‘BETA’ Release ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- '''BETA version''' of the new '''Web User Interface''' for QPR ProcessAnalyzer <br/>
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.
- '''Salesforce Lead process''' supported by Integration Service for Salesforce Cloud <br/>
</div>


=== QPR ProcessAnalyzer 3.10 - Maintenance Release ===
=== Fixed Issues ===
- Improved '''Security''' <br/>
* 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)
- Improved '''Performance''' <br/>
* 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 3.9 - the Real-Time Analysis Release ===
== QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)==
- '''Real-Time analysis''' of continuous event streams using '''Automatic Recalculation''' <br/>
- Keep track of 'include/exclude' actions with '''View Filters''' <br/>
- '''Improved performance''' utilizing new algorithms and SQL Server 2012 <br/>


=== QPR ProcessAnalyzer 3.8 - the User Group Management Release ===
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
- Enhanced [[User Manager|User Management]] includes '''creation of new User Accounts and Groups''' <br/>
- '''[[Influence Analysis]]''' for '''continuous values''' using subsets <br/>
- '''[[Use Cases#Filtering Example|Clear filter for Event Types]]''' only – keeps other filters active <br/>


=== QPR ProcessAnalyzer 3.7 - the Influence Analysis Release ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- New '''[[Influence Analysis]]''' reveals '''reasons''' for process variations <br/>
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.
- '''User Groups''' for easier access rights settings <br/>
</div>
- More informative '''Model, View & Report Managers''' <br/>


=== QPR ProcessAnalyzer 3.6 - the Attribute Analysis Release ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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.
</div>


- Show '''Case Attributes''' in Process Analysis <br/>
===New features===
- Show '''Event Attributes''' in Process Analysis <br/>
* Enhanced [[AI_Agent|AI Agent]] with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
- Profiling for '''Event Attributes''' <br/>
* 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)


=== QPR ProcessAnalyzer 3.5 - the Reporting Release ===
===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)


- Save Analysis views as [[Report|'''Interactive Reports''']] for easy distribution <br/>
===Other improvements===
- '''On-line product documentation''' available in QPR ProcessAnalyzer Wiki at http://devnet.qpr.com/pawiki/ <br/>
* Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
- '''64-bit version''' for 64-bit Microsoft Excel users <br/>
* 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)


=== QPR ProcessAnalyzer 3.4 - the Salesforce Release ===
==Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)==


- [[Flows|'''Flow Analysis''']] for benchmarking duration and amount differences in flow level <br/>
=== Fixed issues ===
- [[Benchmarking|'''Benchmarking''']] for process analysis view <br/>
* Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
- [[Integration Service for Salesforce Cloud|'''Integration Service for Salesforce Cloud''']] – Automated analysis of sales process <br/>
* 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 3.3 - the Benchmarking Release ===
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==


- [[Benchmarking|'''Benchmarking''']] based on '''Case Attributes''' in Path Analysis <br/>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]
- [[Benchmarking|'''Benchmarking''']] for different views in Path Analysis <br/>
- [[QPR Connector for QPR ProcessAnalyzer|'''QPR Connector for QPR ProcessAnalyzer''']] product launch for integrating on-premise IT systems <br/>


=== QPR ProcessAnalyzer 3.2 - the Analysis Release ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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).


- '''Event Type Chart''' showing the order of activities as a Gantt chart <br/>
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:
- '''Process Cost Analysis''' with '''Weighted Durations''' <br/>
<pre>
- Improved filtering for '''Path Analysis''' <br/>
Models.Where({
let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
}).(Name + " (id: " + Id + ")");
</pre>
</div>


=== QPR ProcessAnalyzer 3.1 - the Navigation Release ===
<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.
</div>


- '''Easy navigation''' between filtered views <br/>
===New features===
- '''Graphical variation''' charts <br/>
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
- '''Event attributes''' available in Cases list <br/>
*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)
*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 [[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)
*Home screen has been removed, and [[QPR_ProcessAnalyzer_Project_Workspace|Workspace]] has new card layout and other UX improvements. (B-08541)
* Added [[Filtering_in_QPR_ProcessAnalyzer#Saving_filters|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 [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Backup_configuration_data|backed up to a snapshot and restored]]. (B-08591)
*Improved detection of invalid models by adding [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CheckModelValidity|CheckModelValidity]] function returning model validation errors. (B-08426)


=== QPR ProcessAnalyzer 3.0 - the Cloud Release ===
===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)


- '''Automated Business Process Discovery''' (ABPD) from Cloud <br/>
===Other improvements===
- Support for '''large databases''' <br/>
*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)
- Integration to '''SAP''' <br/>
*Backend support for [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|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: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf 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 [[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]].
 
===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]]
 
__NOTOC__
 
[[Category: QPR ProcessAnalyzer]]

Latest revision as of 10:48, 12 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

New features

  • Presets for AI Root Causes analysis based on Snowflake Top Insights. (B-08889)
  • Added new filter selector to easily filter date and number ranges. (B-08877)
  • Projects can be browsed in the navigation menu to access all dashboards, and organized the menu into two columns. (B-08708)
  • When embedded to another website, SAML authentication is performed in a separate window for more robust operation. (B-08871)
  • AI Agent runs the language model query using the Snowflake account where the selected model is located. (B-08860)

Fixed issues

  • If DefaultUiLanguage in PA_CONFIGURATION table was not defined, users who haven't changed language could not login. (D-14706)
  • Improved performance when opening dashboard was sometimes very slow. (D-14705)
  • Native App didn't show the version number and build timestamp correctly. (D-14703)
  • Snowflake Native App activation failed with a custom compute pool if container service was in the suspended state. (D-14722)
  • Server stuck when trying to generate SQL for SqlDataFrame having multiple columns with the same name. (D-14730)
  • Snowflake DurationBetweenDates function calculated incorrectly when used in a in divisor. (D-14723)
  • In eventlog prediction, fixed issues preventing the usage of case attribute value prediction. (D-14702)
  • Import now succeeds when importing Snowflake datatables refering to data where there is no access. (D-14694)
  • Fixed incorrect color in table column filters, and Workspace loading time has been improved. (D-14704)
  • Fixed issue where dropdown list with projects shows "undefined" in place of project id. (D-14659)
  • Fixed issue where specifying a secret name longer than 440 characters, prevented saving the secret and resulted in an error. (D-14674)
  • SAML authentication failed when it needed to create a new user to QPR ProcessAnalyzer user management. (D-14717)
  • Fixed issue where SQL dataframe queries didn't work if root expression ended to a semicolon. (D-14714)
  • Specific Snowflake query with comparison criteria, AggregateFrom and GetValueFrom functions gave error about invalid identifier. (D-14718)

Other improvements

  • Content-Security-Policy HTTP header has been changed to more secure by removing the script-src 'unsafe-eval' directive. (B-08897)
  • Added security related HTTP headers: X-Permitted-Cross-Domain-Policies, Cross-Origin-Embedder-Policy, Cross-Origin-Opener-Policy, Cross-Origin-Resource-Policy, Referrer-Policy, Permissions-Policy, and remove img-src "blob" from CSP. (B-08879)
  • Implemented backend support for Snowflake Top Insights for AI root causes analysis. (B-08664)
  • Optimized database queries and reduced log writing. (B-08870)
  • For more understandable error messages, error handling and error message generation have been refactored. (B-08754)
  • Frontend components have been updated. (B-08899)
  • Backend components have been updated. (B-08898)

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