QPR ProcessAnalyzer Release Notes: Difference between revisions

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


For information on the compatibility of different release versions, see [[Version_Compatibility_Matrix|Version Compatibility Matrix]].
== Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11) ==
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]


== Latest Release: QPR ProcessAnalyzer 2015.3 (release date 20.5.2015, life cycle phase: Active) ==
===New features===
* Presets for [[AI_Root_Causes|AI Root Causes analysis]] based on Snowflake Top Insights. (B-08889)
* Added new [[Range_Filter|filter selector]] to easily filter date and number ranges. (B-08877)
* Projects can be browsed in the [[Navigation_Menu|navigation menu]] to access all dashboards, and organized the menu into two columns. (B-08708)
* When [[Embed_to_Website|embedded to another website]], SAML authentication is performed in a separate window for more robust operation. (B-08871)
* [[AI_Agent|AI Agent]] runs the language model query using the Snowflake account where the selected model is located. (B-08860)


'''Features:'''<br/>
===Fixed issues===
- 306343: The SQL Server Express LocalDB Instance API has been taken into use for LocalDB instance startup. This makes it possible to support multiple different versions of LocalDB.<br/>
* If DefaultUiLanguage in PA_CONFIGURATION table was not defined, users who haven't changed language could not login. (D-14706)
- 306358: Several performance improvements have been implemented to enhance the Cancel operation, importing of attributes, and updating of variations, among other things. There is also a new ValidateModel function available for QPR ProcessAnalyzer [[Web Service API]].<br/>
* Improved performance when opening dashboard was sometimes very slow. (D-14705)
- 306372: There is a a new tool, [[Using QPR ProcessAnalyzer Integration Kit|QPR ProcessAnalyzer Integration Kit]], which consists of QPR ProcessAnalyzer ETL scripts making integration to other systems, such as your own SAP or SQL system, easier.<br/>
* Native App didn't show the version number and build timestamp correctly. (D-14703)
- 306377: A new [[Analysis Parameters|analysis parameter]], IncludeEventIds, has been added for use in the [[Data_Extraction,_Transformation,_and_Loading#--.23GetAnalysis|GetAnalysis]] command with Event Analysis when running scripts. This enables, for example, removing certain events from the model with the [[Data_Extraction,_Transformation,_and_Loading#--.23RemoveEvents|RemoveEvents]] command.
* Snowflake Native App activation failed with a custom compute pool if container service was in the suspended state. (D-14722)
<br/>
* Server stuck when trying to generate SQL for SqlDataFrame having multiple columns with the same name. (D-14730)
- 306382: There is a new tool called [[QPR ProcessAnalyzer ScriptLauncher]] which enables running scripts on a QPR ProcessAnalyzer Server.
* 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)


'''Fixed Bugs:'''<br/>
===Other improvements===
- 215322: Fixed an issue where attribute value selection in Flow Analysis was not working in Web Client.<br/>
* [[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)
- 215422: Fixed an error preventing the use of Web Client when clicking hyperlinks while the page is loading.<br/>
* 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)
- 215490: Fixed an issue where the analysis parameters could not all be shown in the comment field of the A1 cell due to an Excel length limit.<br/>
* Implemented backend support for [[SqlDataFrame_in_Expression_Language#:~:text=TopInsights|Snowflake Top Insights for AI root causes analysis]]. (B-08664)
- 215775: Fixed an issue where having dots in database names was causing an error.<br/>
* Optimized database queries and reduced log writing. (B-08870)
- 216117: Fixed an issue with changing Analysis settings when Excel table filter was applied.<br/>
* For more understandable error messages, error handling and error message generation have been refactored. (B-08754)
- 216130: It is no longer allowed to delete a filter when there are bookmarks using that filter in benchmark settings.<br/>
* Frontend components have been updated. (B-08899)
- 216135: Fixed an issue with Variation Analysis where an Event Type string was shown as empty.<br/>
* Backend components have been updated. (B-08898)
- 216148: Fixed an error which occurred when the model was saved as a new model from Filter Properties.<br/>
- 216159: Fixed an issue where the QPR ProcessAnalyzer Activation Utility did not display the options properly.<br/>
- 216162: Fixed an error which occurred when opening Case Analysis.<br/>
- 216163: Fixed an error which occurred when a user's default filter had been deleted by another user.<br/>
- 216175: Fixed an issue with showing the Flowchart when a bookmark was opened in Web Client.<br/>
- 216184: Fixed an issue with cancelling logging in when the server for QPR ProcessAnalyzer was not configured properly.<br/>
- 216190: Fixed a performance issue related to reading scripts from the server.<br/>


== Next Release: QPR ProcessAnalyzer 2015.4 (planned release date 11.8.2015)==
== Latest Release: QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_6.pdf QPR_ProcessAnalyzer_2025_6.pdf]


'''Features:'''<br/>
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- 306379: Scripts now have the [[Data_Extraction,_Transformation,_and_Loading#--.23Run|Run command]] available enabling you to run another script with specified parameters.<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).
- 306401: [[Template:Activating_QPR_ProcessAnalyzer#Activation Levels|The product activation limits]] for QPR ProcessAnalyzer Xpress and Xpress Evaluation have been changed.<br/>
</div>
- 306406: Scripts can now be [[Script Encryption|encrypted]].


'''Fixed Bugs''':<br/>
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- 214282: Fixed an issue in old databases to comply with the current implementation where all models are considered base models (i.e. there are no child models anymore).<br/>
Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:
- 215227: Fixed an issue when the value "(others)" is selected as a filter in Profiling Analysis so that an error message will now be shown.<br/>
* object-src 'none'
- 215832: Fixed an issue with the delay after a user cancels an operation in Excel Client.<br/>
* frame-ancestors 'self'
- 215854: Fixed the inconsistency issue in the operation ID which caused a failure in Excel Client progress bar.<br/>
* form-action 'none'
- 215886: Fixed the issue where Excel was not responding when a user tried to open a sample file.<br/>
* base-uri 'none'
- 215998: Fixed an issue where an Evaluator user was able to create an unlimited amount of models.<br/>
* worker-src blob:
- 215999: Fixed an issue with user roles so that creating new data tables requires now also any one of the following global roles: Administrator, Model Creator or Evaluator.<br/>
- 216057: Fixed an issue where QPR ProcessAnalyzer Excel Add-in crashed when a user opened an Excel file in protected mode and tried to enable editing.<br/>
- 216070: Fixed an issue related to Evaluator user rights.<br/>
- 216079: Fixed an issue with Profiling and Influence Analysis failing if the SQL value is of type FLOAT.<br/>
- 216084: Fixed an issue where the error text did not show the script name when an error occurred in the running of a script.<br/>
- 216152: Fixed an issue where old data still existed in a temporary table when importing data to a temporary table with the import Data Table commands using the parameter Append = 0.<br/>
- 216153: Fixed an issue where old temporary table was not deleted before it was used in [[Data_Extraction,_Transformation,_and_Loading#--.23GetAnalysis|GetAnalysis command]].<br/>
- 216183: Fixed an issue in Influence Analysis where the subset of zero values could not be selected for drilldown.<br/>
- 216189: Fixed an issue where the QPR ProcessAnalyzer Excel Client was connected to a database initialized with newer initialization script versions than the used client.<br/>
- 216192: Fixed an issue with case attribute import in case the first column has the name "Id".<br/>
- 216211: Fixed a connection slowness issue in QPR ProcessAnalyzer Xpress after the LocalDB instance was stopped.<br/>
- 216215: Fixed the error message in QPR ProcessAnalyzer Web Client when a user tried to open a bookmark of unsupported type.<br/>
- 216218: Fixed the error message for a network connection problem.<br/>
- 216238: Fixed an issue where hidden Excel sheets were created every time a user would open Excel.<br/>
- 216249: Fixed an error that occurred when trying to copy a model multiple times in a row.<br/>
- 216255: Fixed an issue where deleted filters were still visible in the list of filters accessible from the Change button in the ribbon.<br/>
- 216256: Fixed an issue where QPR ProcessAnalyzer Web Client became unresponsive when user tried to relate an idea to a deleted filter.<br/>
- 216262: Fixed an issue where after each import, all the variations that were not used by any case existing in the model were removed, causing variation dependent filters to no longer work as expected.<br/>
- 216269: Fixed an incorrect label in the Bookmark Properties dialog.<br/>
- 216312: Fixed the URL of the link for "Forgot your Product Activation Code?" in the QPR ProcessAnalyzer Activation Utility dialog.<br/>
- 216329: Fixed the [[Data_Extraction,_Transformation,_and_Loading#--.23GetAnalysis|GetAnalysis command]] so that deleted models, projects, scripts or data tables are not returned in the analysis by default.<br/>
- 216338: Fixed an issue where an unhandled timeout exception was thrown when restoring a big model.<br/>
- 216350: Fixed an issue with slow Variation Analysis in models having lots of variations.<br/>
- 216352: Fixed an issue where import of a model caused variations to be updated for all models.<br/>
- 216355: Fixed an issue with the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23ShowReport|ShowReport command]] related to an Excel limitation of showing only 1 million rows of data.<br/>
- 216357: Fixed an issue where QPR ProcessAnalyzer Integration Kit failed in case there was no data to be loaded.<br/>
- 216359: Fixed an error which appeared when user tried to use Excel client newer than the recommended client version in the service.<br/>
- 216361: Fixed an issue where the stack trace was not always written to the log file when an error occured.<br/>
- 216375: Fixed the QPR ProcessAnalyzer ScriptLauncher to be a 64-bit application instead of 32-bit.<br/>
- 216380: Fixed the build errors which appeared in the installer log of QPR ProcessAnalyzer.<br/>
- 216422: Fixed an issue in QPR ProcessAnalyzer Excel Client where Run Scripts button in some cases was visible for a user without RunScripts rights.<br/>
- 216423: Fixed an issue with an error occurring when trying to open Project Workspace after an expired session in QPR ProcessAnalyzer Xpress.<br/>
- 216425: Fixed an issue where QPR ProcessAnalyzer Web Client became unresponsive when user tried to open a deleted bookmark.<br/>
- 216433: Fixed an issue where case-related data was incorrectly shown in Project Workspace after importing a new model.
<br/>
- 216436: Fixed an issue with filters not working in a customer production environment.
__TOC__


== 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 2015.2 (release date 17.3.2015, life cycle phase: Mature) ===
<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===
- There's a new QueryObjectProperties function available for QPR ProcessAnalyzer [[Web Service API]].<br/>
* [[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)
- The [[Influence Analysis]] now supports the [[Filtering#Include / Exclude Filters|Include and Exclude cases filtering]] and [[Filtering#Runtime Selection|Runtime Selection filtering]].<br/>
* 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)
- For users with Administrator rights, it is now possible to set any configured filter to be the Model Default filter in the [[Filters|Filter Manager]].
* 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===
- 216050: Fixed an issue in Influence Analysis where empty and non-existing attribute values were combined into '(blank)' subset.<br/>
* Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
- 216051: Fixed an issue in Influence Analysis where whitespace characters were cut at the end of attribute values.<br/>
* When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
- 216062: Fixed an issue where the Settings pane disappeared from a bookmarked view.<br/>
* Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
- 216088: Fixed an issue where Excel Add-in for QPR ProcessAnalyzer crashed on Excel start-up.<br/>
* Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
- 216091: Fixed an issue with importing data tables where the parameter "Append=0" did not remove the contents of the data table before the import.<br/>
* In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
- 216122: Optimized the Workspace opening to take less time.
* 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)


=== QPR ProcessAnalyzer 2015.1 (release date 5.2.2015, life cycle phase: Mature) ===
===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) ==
- 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_5.pdf QPR_ProcessAnalyzer_2025_5.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;">
When using Snowflake Cortex, the AI Assistant is not showing the results table in the assistant's response. This issue has been fixed by the next release.
</div>


- 215360: Fixed an issue where the selections on the Settings pane were not updated after running a script.<br/>
===New features===
- 215515: Fixed a performance issue related to selecting several groups or models in Project Workspace.<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)
- 215707: Fixed an issue where the user received an error message when opening a bookmarked view.<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)
- 215818, 215969: Fixed layout related issues when using the 150% font size setting in the operating system.<br/>
* [[Filtering_in_QPR_ProcessAnalyzer|Flows and variations can be filtered]] from any event attribute viewpoint in Snowflake. (B-08737)
- 215855: Fixed an issue related to timestamps when importing events.<br/>
* Added [[Project_Properties_Dialog|project properties dialog]] for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
- 215867: Fixed a memory issue which occurred when using the ExecuteInClientSide function.<br/>
* [[QPR_ProcessAnalyzer_Project_Workspace#Validating_Model|Model validity check]] easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
- 215959: Fixed a performance issue related to importing events.<br/>
* Projects can be [[QPR_ProcessAnalyzer_Project_Workspace#Exporting_Project|exported]] to json files and imported as new projects. (B-08717)
- 215960: Fixed a performance issue related to opening Project Workspace.<br/>
* Action buttons can be added to dashboard by defining [[Label_and_Link|label component]] that can change dashboard variables and run scripts. (B-08694)
- 215980: Fixed a layout related issue for drop-down menus in some Analysis views.<br/>
* Web user interface is available in [[Languages_and_Localization|Ukrainian language]]. (B-08734)
- 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/>
- 215966: The "Append = 0" parameter not working with ImportOdbcQuery, ImportOleQuery, ImportSapQuery, and ImportSqlQuery when importing data to temporary tables was fixed.<br/>
- 215968: Fixed an issue where the number of events in a model that was copied was not correct.<br/>


=== QPR ProcessAnalyzer 2014.4 (release date 28.11.2014, life cycle phase: Mature) ===
===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)


'''Features''':<br/>
===Other improvements===
- It is now possible to configure LDAP authentication to be used as [[Authentication Methods|a user authentication method]].<br/>
* When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
- 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/>
* Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
- There is a new [[Progress Log]] listing the recent operations and their progress.<br/>
* Stringified value format supports also json objects. (B-08766)
- Microsoft .NET 4.5.1 Framework has been taken into use.<br/>
* Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
- 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/>
* Translations have been updated. (B-08757)
- The [[Template:Activating QPR ProcessAnalyzer|activation level limits]] have been updated.
* Frontend components have been updated. (B-08760)
* Backend components have been updated. (B-08759)


'''Fixed Bugs''':<br/>
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==
- 213258: Fixed an issue where generating the Operation Log using the "All" option for the maximum row count caused an error.<br/>
- 213703: Fixed an issue where list customization was lost when opening an element.<br/>
- 215330: Fixed an issue where some unicode characters were not properly handled in equality checks.<br/>
- 215381: A warning message is now displayed to the user before the start of copying a large model.<br/>
- 215474: The HealthcareData sample file now contains instructions for using the sample data.<br/>
- 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/>
- 215677: Fixed an issue where illegal characters in an Excel sheet tab name caused the model import to fail.<br/>
- 215678: Fixed an issue related to the handling of broken bookmarks.<br/>
- 215691: Fixed an issue where no log was written when opening a sample file failed.<br/>
- 215695: Fixed an issue where the View setting panel disappeared in Excel Client when a bookmark was opened.<br/>
- 215715: Fixed an issue where Event Analysis showed an incorrect number of events in the A1 cell.<br/>
- 215741: Fixed an issue where Variation Analysis was not working correctly on Finnish and German Excel.<br/>
- 215773: Fixed an issue where sandbox related information was missing from the Excel log.<br/>
- 215837: Fixed an issue where running a script with ImportSAPQuery commands failed randomly.<br/>


=== QPR ProcessAnalyzer 2014.3 (release date 16.9.2014, life cycle phase: Mature) ===
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]


'''Features''':<br/>
===New features===
- Activation is now required for running a [[Installing_QPR_ProcessAnalyzer#Installing_QPR_ProcessAnalyzer_Service|QPR ProcessAnalyzer Service]].
* 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 [[Filter_Selectors#Filter_selector|generic filtering component]] that can be configured for creating any type of filters for distinct values. (B-08654)
* Volume declining in measures due to case sampling can be compensated in chart and flowchart by using a [[Measure,_Dimension_and_Column_Settings#Statistical_calculations|Statistical calculation method]]. (B-08598)
* In object-centric models, Object ID, Event ID, Event timestamp, and Event type [[Object-centric_Process_Mining_Model#Object-centric_perspectives|attribute names]] are shown correctly. (B-08680)
* Snowflake native app has now [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#User_access_to_application|application roles]] for user (for using app) and administrator (for managing app). (B-08660)
* For Snowflake native app, IMPORTED PRIVILEGES ON SNOWFLAKE DB privilege is removed and instead the [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Optional_privilege_for_AI_Agent|CORTEX_USER database role]] can be assigned. (B-08718)
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Logging|Native app logging]] has been improved and now sharing application logs with QPR is possible. (B-08661)
* Added [[DataFrame_in_Expression_Language#CsvToDataFrame|CsvToDataFrame]] function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)


'''Fixed Bugs''':<br/>
===Fixed issues===
- 213234: Fixed an issue where an error message occurred after deleting a model.<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)
- 213784: Fixed an issue in which the internal SQL data type was not supported by Excel for showing in the report.<br/>
* When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
- 213785: Fixed an issue where an overflow of text data in a single cell occurred.<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)
- 213811: Fixed an issue where opening the Path analysis of some models hanged the Excel client.<br/>
* Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
- 214106: Fixed a script import issue by removing the support for .pasql import.<br/>
* Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
- 214612: Fixed an issue where a violation of unique key constraint occurred due to duplicate global ID's.<br/>
* Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
- 215017: Fixed an issue where cancelling an open Workspace dialog caused an exception.<br/>
* In in-memory models, array type of data was not dimensioned correctly. (D-14518)
- 215026: Fixed an issue where trying to import a Data Table via SQL query as an administrator resulted in an error message.<br/>
* AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
- 215044: Fixed an issue with client version mismatch dialog.<br/>
* Table grouping header labels were not formatted correctly. (D-14514)
- 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/>
* Fixed Root causes analysis to work with object-centric models. (D-14515)
- 215183: In the Activation Utility, 'Next' is now the default button instead of 'Back'.<br/>
* Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
- 215230: Fixed an issue where the first cell of a column in the Excel client was in a different format than the others.<br/>
* Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
- 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/>
* Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
- 215331: Fixed an issue where you couldn't log in to another database after the current database was deleted.<br/>
* Flowchart SVG export did not show start and end symbols. (D-12401)
- 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 issue where join operation didn't find renamed columns in SqlDataFrames. (D-14512)
- 215449: Fixed an issue where the official sample file, SAP_OrderToCash, could not be opened from the Excel client.<br/>
* Improved chart filtering button positions to work with small chart sizes. (D-14509)
- 215453: Fixed an issue where an error occurred when trying to import event data to a model as a case attribute.<br/>
* Datatable foreign key columns dictionary data type was incorrect preventing reading columns information. (D-14505)
- 215472: Fixed an issue where deleted filters were not removed completely from a model.<br/>
* Workspace scripts editor allowed to change script code for viewer users (altough not save it). (D-14534)
- 215473: Fixed an issue where an empty Flowchart view caused the View title also to disappear from the current view.<br/>
* In chart custom sorting, trying to refer to measure that had None aggregation, caused SQL compilation error. (D-14526)
- 215482: Fixed an issue where copying a model failed if the attribute type was GUI.<br/>
* Model validation check crashed when the datatables were in different datasources. (D-14502)
- 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/>
- 215498: Fixed an issue where an error occurred when the database connection to QPR ProcessAnalyzer was lost.<br/>
- 215506: Fixed an issue where the analysis drawing duration in Excel was missing.<br/>
- 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/>
- 215515: Fixed an issue where selecting a group of models/projects in Project Workspace caused slowness.<br/>
- 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, life cycle phase: Mature) ===
===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)


'''Features''':<br/>
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==
- 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/>
- 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/>
===New features===
- 214783: Fixed an issue where animation did not work correctly when using Flowchart benchmarking view.<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)
- 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/>
- 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, life cycle phase: Retired) ===
===Fixed issues===
'''Features''':<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)
- The [[Operation Log|Operation Log]] now shows the Last Polling Time related to the new asynchronous web service interface in QPR ProcessAnalyzer.<br/>
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
- Version numbering scheme in QPR ProcessAnalyzer was updated.<br/>
* Clustering analysis didn't work with object-centric models. (D-14486)
- 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/>
* 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)
- 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/>
* Deleting last group didn't remove the group from the list. (D-14504)


'''Fixed Bugs''':<br/>
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==
- 214640: Fixed an issue where opening the Workspace dialog as an Administrator user took long.<br/>
- 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/>
- 214661: Fixed an issue where variation string was incorrect in Case Analysis if Event Types had been filtered.<br/>
- 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/>
- 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/>
- 215006: Fixed an issue where the "Append = 0" parameter didn't work when importing data into Data Tables.


=== QPR ProcessAnalyzer 4.7 (release date 20.11.2013, life cycle phase: End-of-life) ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Features''':<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.
- 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/>
</div>
- The Flowchart Analysis can now be made to show the progress of each case as an [[Flowchart Animation|animation]].


=== QPR ProcessAnalyzer 4.6 (release date 9.10.2013, life cycle phase: End-of-life) ===
=== Fixed Issues ===
'''Features''':<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)
- 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/>
* Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
- 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/>
* Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
- 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/>
* 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)
- Scripts now have a [[Data_Extraction,_Transformation,_and_Loading#--.23SendEmail|SendEmail]] command available for use with notification purposes.<br/>


'''Fixed Bugs''':<br/>
== QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)==


- 214286: Fixed an issue where in some cases it was impossible to log in to the PA service.<br/>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
- 214354: Fixed an issue where an exception was thrown when a large CSV file was imported to a data table.<br/>
- 214393: Fixed an issue where bookmarks didn't remember excluded cases.<br/>
- 214404: Fixed an issue where an error occurred after a project was deleted.<br/>
- 214422: Running an empty script caused ProcessAnalyzer Excel client to hang. Now it doesn't.<br/>
- 214437: Fixed an issue where importing case attributes or events from a large CSV file created multiple models.<br/>
- 214441: Fixed an issue where the @_FilterId variable was not updated properly.<br/>
- 214455: Fixed an upgrade issue in QPR ProcessAnalyzer installer.<br/>
- 214458: Fixed an issue where an exception was thrown when Manage Scripts button was clicked after the session had expired.<br/>
- 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, life cycle phase: End-of-life) ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Features''':<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.
- [[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/>
</div>
- 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/>
- There are now [[Script Management#Script Manager|Script Manager]] and [[Script Management#Script Properties|Script Properties]] dialogs available for managing and developing scripts.<br/>
- 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 Bugs''':<br/>
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- 213970: The import functionality was refactored.<br/>
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.
- 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/>
</div>
- 213965: Fixed an issue where a "ButtonClick" error was given when the Cancel button was clicked on login after the session had expired.<br/>
- 214134: Fixed an issue where the QPR ProcessAnalyzer installer didn't install sample files when installing to Microsoft Office 2013.<br/>
- 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/>
- 213871: Fixed an issue where some QPR ProcessAnalyzer Service users were not visible to even Administrator users.<br/>
- 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, life cycle phase: End-of-life) ===
===New features===
'''Features''':<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)
- [[Data Extraction, Transformation, and Loading#--.23ShowReport|ShowReport]] command providing customized reporting.<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)
- Importing data to [[Data Table|Data Tables]] using the Excel Client.<br/>
* 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)
- Support for Windows 8 and Microsoft Office 2013.<br/>
* Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
- [[Data Extraction, Transformation, and Loading#--.23Exit|Exit]] command for stopping script execution.<br/>
* "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
- [[Data Extraction, Transformation, and Loading#--.23ImportDataTable|ImportDataTable]] command for importing data into [[Data Table|Data Tables]] using a script.
* 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)


'''Fixed Bugs''':<br/>
===Fixed issues===
- 213486: Querying event attribute values in Case Analysis is now faster.<br/>
* Fixed a potential issue which could have leaked database connections and caused connection pool starvation. (D-14414)
- 213565: Fixed the issue where the progress indicator moves back and forth between 100% and 90% when copying or importing large models.<br/>
* Renewed self-signed certificate used by SAML 2.0 authentication with ten years of validity. (D-14424)
- 213780: Fixed the wrong date format in 64-bit Excel Operation Log.<br/>
* Improved CallWebService function to send request body when using DELETE method. (D-14488)
- 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/>
* Login page now shows correct error message when there are serious system errors during login. (D-14480)
- 213832: Added scrollbar for the QPR ProcessAnalyzer Web Client Bookmark view's Navigator pane.<br/>
* "Datatable contents (in-memory)" option now works also with Snowflake datatables. (D-14391)
- 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/>
* Added maximum data size limitation to AI assistant to avoid error with large datasets. (D-14419)
- 213540: Fixed the formatting of Duration Days values to include only two decimals in QPR ProcessAnalyzer Excel Client Case Analysis.<br/>
* Day of the Year/Week/Month/Quater selection didn't work with specific event time in in-memory chart. (D-14421)
- 213946: Fixed an issue where model export didn't work in QPR ProcessAnalyzer Excel Client.<br/>
* KPI card now shows a scrollbar when content doesn't fit to the available space. (D-13428)
- 213993: Improved performance of Flowchart Analysis when benchmarking by both start and event attributes.<br/>
* 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)


=== QPR ProcessAnalyzer 4.3 (release date 23.4.2013, life cycle phase: End-of-life) ===
===Other improvements===
- [[Data Extraction, Transformation, and Loading|ETL]] capabilities within QPR ProcessAnalyzer for script based transformations, data validations, and extended analysis using load scripts<br/>
* Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
- [[Duration Analysis]] - added grouping by Week, Quarter, and Year for easier analysis<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)
- Variation Ids in [[Cases|Case Analysis]] for allowing benchmarking by process variation<br/>
* Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
- Enhanced [[User Rights Report]] for easier user administration and access rights settings<br/>
* Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
- 32-bit and 64-bit versions available from one installer package for easier delivery<br/>
* Frontend components have been updated. (B-08638)
- New [[Start]] button and Login window allow automatic login and now also support logout<br/>
* Backend components have been updated. (B-08639)
- [[Full Screen Mode|Web Client Full Screen Mode]] for maximixing screen space for large graphs and allowing browser based zoom<br/>
* Translations have been updated. (B-08640)
- 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 (life cycle phase: End-of-life) ===
==Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)==
- '''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 (life cycle phase: End-of-life) ===
=== Fixed issues ===
- '''BETA version''' of the new '''Web User Interface''' for QPR ProcessAnalyzer <br/>
* Fixed issue where charts axis labels had unnecessary line breaks on spaces. (D-14413)
- '''Salesforce Lead process''' supported by Integration Service for Salesforce Cloud <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.10 - Maintenance Release (life cycle phase: End-of-life) ===
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==
- Improved '''Security''' <br/>
- Improved '''Performance''' <br/>


=== QPR ProcessAnalyzer 3.9 - the Real-Time Analysis Release (life cycle phase: End-of-life) ===
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]
- '''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 (life cycle phase: End-of-life) ===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
- Enhanced [[User Manager|User Management]] includes '''creation of new User Accounts and Groups''' <br/>
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).
- '''[[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 (life cycle phase: End-of-life) ===
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:
- New '''[[Influence Analysis]]''' reveals '''reasons''' for process variations <br/>
<pre>
- '''User Groups''' for easier access rights settings <br/>
Models.Where({
- More informative '''Model, View & Report Managers''' <br/>
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.6 - the Attribute Analysis Release (life cycle phase: End-of-life) ===
<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>


- Show '''Case Attributes''' in Process Analysis <br/>
===New features===
- Show '''Event Attributes''' in Process Analysis <br/>
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
- Profiling for '''Event Attributes''' <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.5 - the Reporting Release (life cycle phase: End-of-life) ===
===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)


- 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/>
*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)
- '''64-bit version''' for 64-bit Microsoft Excel users <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 3.4 - the Salesforce Release (life cycle phase: End-of-life) ===
==QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)==


- [[Flows|'''Flow Analysis''']] for benchmarking duration and amount differences in flow level <br/>
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
- [[Benchmarking|'''Benchmarking''']] for process analysis view <br/>
- [[Integration Service for Salesforce Cloud|'''Integration Service for Salesforce Cloud''']] – Automated analysis of sales process <br/>


=== QPR ProcessAnalyzer 3.3 - the Benchmarking Release (life cycle phase: End-of-life) ===
===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]].


- [[Benchmarking|'''Benchmarking''']] based on '''Case Attributes''' in Path Analysis <br/>
===Fixed issues===
- [[Benchmarking|'''Benchmarking''']] for different views in Path Analysis <br/>
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
- [[QPR Connector for QPR ProcessAnalyzer|'''QPR Connector for QPR ProcessAnalyzer''']] product launch for integrating on-premise IT systems <br/>
*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.


=== QPR ProcessAnalyzer 3.2 - the Analysis Release (life cycle phase: End-of-life) ===
===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.


- '''Event Type Chart''' showing the order of activities as a Gantt chart <br/>
== Old Releases==
- '''Process Cost Analysis''' with '''Weighted Durations''' <br/>
See older releases in [[QPR ProcessAnalyzer Release Archive]]
- Improved filtering for '''Path Analysis''' <br/>


=== QPR ProcessAnalyzer 3.1 - the Navigation Release (life cycle phase: End-of-life) ===
__NOTOC__


- '''Easy navigation''' between filtered views <br/>
[[Category: QPR ProcessAnalyzer]]
- '''Graphical variation''' charts <br/>
- '''Event attributes''' available in Cases list <br/>
 
=== QPR ProcessAnalyzer 3.0 - the Cloud Release (life cycle phase: End-of-life) ===
 
- '''Automated Business Process Discovery''' (ABPD) from Cloud <br/>
- Support for '''large databases''' <br/>
- Integration to '''SAP''' <br/>

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