QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(997 intermediate revisions by 8 users not shown)
Line 1: Line 1:
This page contains new features and fixed issues for each QPR ProcessAnalyzer release.
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.
 
== 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 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]


== Next Release: QPR ProcessAnalyzer 2022.8 (planned release date 2022-12-27) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Creating datatables with duplicate names in the same project is prevented in this release, and also possible existing duplicate names will be automatically renamed to contain unique names. If there are these kinds of datatables, they need to be renamed manually after the update. Creating duplicate datatables has already been prevented in the UI, but the improved method is more robust.
Known issue: If the [[PA_Configuration_database_table#:~:text=DefaultUiLanguage|DefaultUiLanguage]] system configuration is not defined, users who haven't changed their own language, are unable to login. To prevent this problem, please ensure the DefaultUiLanguage is defined. The next release will fix this issue (D-14706).
</div>
</div>


'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* B-07518: Added Query function to expression language to run call /api/expression/query.
Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:
* B-07294: In Workspace, the left side projects hierarchy can be collapsed and expanded to make more space to the project contents.
* object-src 'none'
* B-06814: In SQL expressions, new function to calculate duration between timestamps precisely.
* frame-ancestors 'self'
* B-07531: In SQL expressions, new mathematical functions Abs, Log, Mod, Power, Rand, Sign and Sqrt.
* form-action 'none'
* B-07297: To optimize performance, Snowflake queries are automatically cancelled if they are not needed by UI.
* base-uri 'none'
* B-07569: To optimize performance, TakeSample function implementation is improved for Snowflake.
* worker-src blob:
* B-07198: Performance improvements to DataFrame queries.
* B-07464: Added Lead and Lag functions to SqlDataFrames.
* B-07470: Added ExtractSap function to fetch data from SAP using expression language.
* B-07515: Added RootCauseAnalysis function to SqlDataFrames.
* B-07488: Primary keys can be set to datatables.
* B-07536: Added  Pivot function to SqlDataFrames.
* B-03052: Support for user-defined variables in /api/expression/query.
* B-07565: Support for NumberPrecision, DatetimeTruncation and TimespanPrecision properties for Values section in in-memory query.
* B-07513: For product activation file handling, replaced mutex based implementation with exclusive file lock.


'''Fixed issues:'''
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]].
* D-12660: Removed unnecessary float conversions in SQL expressions.
</div>
* D-12662: Some special literals in custom expressions didn't work.
* D-12403: Setting Notifications on a model had some visual issues.
* D-12702: For BPMN Editor component "Something went wrong" error was given when switching from inMemory to snowflake model.
* D-12704: Durations as quarters was shown incorrectly.
* D-12706: Linebreaks in data were shown in many places where it's undesired.
* D-12719: Syncfusion dialogs showed backslaces incorrectly.
* D-12372: Refused to run the JavaScript URL because it violated the Content Security Policy directive.
* D-12730: Logging out when filter selection is in progress, gave javascript error.
* D-12705: Header object counts tooltip was sometimes messed after logout.
* D-12089: Include conforming/nonconforming cases made BPMN editor no responding.
* D-12384: Selected project was not highlighted for whole project name string.
* D-12581: Prevented creating duplicate datatable names in same project in parallel execution.
* D-12715: Snowflake calculated imprecisely some operations containing division and aggregation.
* D-12722: There was incorrect syntax near '<' when running SqlDataFrame expressions.
* D-12736: Swedish and Finnish translation improvements for counter tooltips.
* D-12653: In-memory: OrderByColumns with mixed values failed.
* D-12712: TypeError: Cannot read properties of undefined (reading 'id').
* D-12738: Business calendar showed total business time when calendar configuration is invalid.
* D-12776: Special character filter caused JavaScript SyntaxError.
* D-12785: Unnecessary vertical scrollbar displayed for main header toolbar.


== Latest Release: QPR ProcessAnalyzer 2022.7 (build 1331) (released 2022-11-15) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Starting from QPR ProcessAnalyzer 2022.7, to improve security expression language operations that modify data or connect to external datasources are prevented in dashboard custom expressions. The limitation is required, because when a dashboard is opened, its expressions are run with the user's permissions, and the user need to trust the expressions don't perform any unexpected operations, such as delete data. The full functionality of the expression language is available in the scripts and in the Expression Designer.
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).
 
The following functions and operations are prevented in dashboards: SendEmail(), CallWebService(), ImportOdbc(), ImportOdbcSecure(), Model.DeletePermanently(), Model.Restore(), Model.TriggerNotifications(), Project.DeletePermanently(), Project.Restore(), Project.CreateDatatable(), Datatable.AddColumn(), Datatable.DeletePermanently(), Datatable.Import(), Datatable.Merge(), Datatable.RemoveColumns(), Datatable.RenameColumns(), Datatable.Truncate(), RecycleBin.DeletePermanently(), and call SQL script. Calling expression scripts is allowed, but in the script all previously mentioned operations are prevented.
 
Following SQL query can be executed in the QPR ProcessAnalyzer metadata database to reveal dashboards that potentially have prevented expressions:
SELECT * FROM [PA_UI_ELEMENT] WHERE [UIE_PROPERTIES] LIKE '%SendEmail(%' OR [UIE_PROPERTIES] LIKE '%CallWebService(%' OR [UIE_PROPERTIES] LIKE '%ImportOdbc(%' OR [UIE_PROPERTIES] LIKE '%ImportOdbcSecure(%' OR [UIE_PROPERTIES] LIKE '%DeletePermanently(%' OR [UIE_PROPERTIES] LIKE '%Restore(%' OR [UIE_PROPERTIES] LIKE '%TriggerNotifications(%' OR [UIE_PROPERTIES] LIKE '%CreateDatatable(%' OR [UIE_PROPERTIES] LIKE '%AddColumn(%' OR [UIE_PROPERTIES] LIKE '%DeletePermanently(%' OR [UIE_PROPERTIES] LIKE '%Import(%' OR [UIE_PROPERTIES] LIKE '%Merge(%' OR [UIE_PROPERTIES] LIKE '%RemoveColumns(%' OR [UIE_PROPERTIES] LIKE '%RenameColumns(%'
</div>
</div>


'''Features:'''
===New features===
* B-07287: Process Discovery and most important presets for Snowflake.
* [[User_Settings#Starting_dashboard|Starting dashboard]] after login can be defined for user groups, allowing to create customized starting pages for easy navigation. (B-08791)
* B-07271: "Last Row Aggregates Over-limit Rows" setting for big data chart.
* Snowflake [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|chart's event filters]] are now embedded to filters created from chart, to precisely follow chart calculation. (B-08845)
* B-06431: Snowflake datatables support for database views in the datasource.
* Result data can be filtered in Snowflake charts using [[QPR_ProcessAnalyzer_Chart#:~:text=Result%20filtering%20expression|result filtering expression]] which works for any datasets. (B-08751)
* B-07266: Security: "limited mode" to prevent data modifications and external calls from dashboard expressions.
* Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* B-07097: Improved flowchart root causes color scales.
* Added model setting [[QPR_ProcessAnalyzer_Project_Workspace#Hiding_Object_Count_Statistics|Show object count statistics]] to hide object counts information in dropdown lists to optimize performance. (B-08849)
* B-07363: SQL LIKE function support for escape character.
* Added support for [[Chart_On-screen_Settings#:~:text=showStatistics|hiding statistics for on-screen setting]] dropdown lists to improve performance, and in addition the case ID is hidden Case/Event attribute profiling presets. (B-08840)
* B-06877: Improved variation queries performance in Snowflake, part 1.
* Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
* B-07444: Improved variation queries performance in Snowflake, part 2.
* Snowflake Native App: Added procedure to that [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Recover_administrator_access|creates administrator user to Native App]] if access to the app has been lost. Also, prevented user management operations that remove own access. (B-08733)
* B-07382: Support for empty strings and nulls in event type names in dataframe processing.
* Snowflake Native App: Added procedure to [[Change_Native_App_Compute_Pool_Size|change Native App compute pool size]]. Changed new Native Apps to use CPU_X64_S size compute pool, and improved Native App stability. (B-08859)
* B-07273: WithRowNumberColumn, WithRankColumn, WithDenseRankColumn support for descending sorting.
* B-07303: FindRootCauses function support for weighting expression.
* B-07327: Unpivot function for SqlDataFrames (for root cause analysis).
* B-07385: Align token lifetime with SESSION_MAXIMUM_DURATION setting.
* B-07500: ColumnMappings property for IDataFrame and DataTables.
* B-07499: IDataFrame.ApplyFilter function to filter events data using a JSON-based filter.
* B-07469: Translation updates for release 2022.7.


'''Fixed issues:'''
===Fixed issues===
* D-11630: Drag and drop from chart settings to main header was working incorrectly for filter and root cause rules.
* Snowflake Cortex based AI Assistant didn't show the results table. (D-14643)
* D-12455: Moving a chart filter from one chart to another created a root cause analysis filter.
* When percent stacking is used, Y-axis values are now shown as percentages in data label and tooltip. (D-14633)
* D-12266: Root causes analysis showed incorrect results when certain combination of filters.
* Fixed issue where Label&Link component had sometimes unnecessary vertical scrollbar. (D-14685)
* D-12525: Numerical values in Excel export in data grid was formatted incorrectly.
* Model validation showed incorrect error message for models with numeric duplicate case ID's. (D-14687)
* D-12534: Restoring item from recycle bin changed project from Bin to previous project.
* In Workspace, scripts "View current run log" dialog didn't update log correctly when new entries were added. (D-14662)
* D-12529: Measure specific datalabel mapping did not work correctly when also mapped to Y-axis.
* Event type mapping in charts didn't work in object-centric models. (D-14620)
* D-12532: Multi-selection options caused layout issue for Chart setting.
* Model generation didn't work as transformation step using _system.ML.ApplyTransformation function. (D-14654)
* D-12541: Layout issue for Polish in multiselect list search dialog.
* Others aggregation has been removed from date type of dimensions because tables don't work with textual data in date columns. (D-14623)
* D-11277: Increase/decrease Icons were missing in the dimension sorting for Mac.
* Fixed issue in AI Assistant where using both Snowflake Cortex and OpenAI modes caused error. (D-14646)
* D-12552: Uncaught Error: Diagram.selectCollection given something that is not a Part: null.
* In User Management Effective permissions table, column filter incorrectly showed "true" and "false" as options. (D-14639)
* D-12567: Tooltip incorrectly showed for label component containing only spaces.
* Pivot table incorrectly showed "Numeric value is not recognized" error when Count or Unique count aggregations were used. (D-14559)
* D-12438: Operation was cancelled because it was replaced by a new operation.
* Workspace buttons are now visible in small screens spanning to multiple lines. (D-14587)
* D-12551: Some expressions didn't work as calculated case/event attributes.
* Added tooltip text to "Move to" submenu containing projects so that long project names can be seen. (D-14612)
* D-11720: Chart buttons were not visible in Apple Safari and iPad.
* Translation was missing from error messages when deleting items from recycle bin. (D-14652)
* D-12544: On-screen settings "options" parameter did not work.
* Fixed data type related issues with in-memory Floor, Ceiling and aggregation functions. (D-14622)
* D-12528: Multi-unit time unit selection appeared where it's not applicable.
* Optimized resource loading by getting rid of unnecessary file assets/i18n/en_US.json. (D-14641)
* D-12583: Error message should be provided for invalid settings input  than just  display JS errors.
* Fixed issue where opening script editor gave javascript error about content-security-policy violation. (D-14627)
* D-12599: Tooltips didn't show correct measures/dimensions when "Show in tooltip" mappings are used.
* Fixed issue in charts showing datatable content had a strange error when datatable was not selected. (D-14650)
* D-12561: Chart settings content was incorrectly drawn outside of the chart dialog.
* Fixed incorrect data types in some project, user and group related measures. (D-14619)
* D-12568: Reload UI sometimes crashed chart having multiselect on-screen settings.
* Fixed issue where moving expression scripts was not possible when SQL Scripting was not allowed. (D-14624)
* D-12572: Main header toolbar lost when refresh maximized PA chart.
* Deleting and renaming scripts were not available for expression scripts when SQL Scripting was not allowed. (D-14625)
* D-12612: Drop Unused Filters After setting incorrectly allowed zero seconds.
* Improved documentation for situation when non-existing Snowflake warehouse is configured for a model. (D-14543)
* D-12533: Error message keeped blinking in Analysis view.
* Project properties dialog shows a descriptive text when no secrets have been defined instead of an empty table. (D-14611)
* D-12608: User could not select or add new case attribute when current select attribute doesn't exist.
* Improved messages and New project button visibility in Workspace top level when no projects are shown. (D-14609)
* D-12451: Prevented deleting running script.
* Event preset gave error if enabling Apply with Chart Filters setting and trying to create filters. (D-14695)
* D-12516: Windows event viewer warning: Failed to gracefully shutdown application.
* D-12523: Business calendar performance - part 2.
* D-12538: Column with same name could be added multiple times to datatable using expression language.
* D-12582: Improved EMS mutex code to support multiple PA service in one server.
* D-12624: Synchronize new (empty) data table generated failed queries in Snowflake.
* D-12622: Advanced setting page reserved room for the expression editor frame that did not exist.
* D-11295: In on-screen settings, some UI controls were vertically misaligned.
* D-11625: The heights of the parameter option menu in the clustering tab was not well aligned.
* D-12103: Small dropdown list layout issue.
* D-12633: Align issue for Column related Advanced settings.
* D-12505: Search dialog didn't escape % and _ characters correctly in dataframe processing.
* D-12645: Tabs in expression settings dialog were partly hidden when dialog is narrow.
* D-11382: Moving of flowchart was sometimes shaky.
* D-12655: Filter rule tooltips in header were styled incorrectly.
* D-12656: Large integer values in filter jsons were incorrectly presented as small integers.
* D-12661: Some exported filters contained unnecessary "invert" property.
* D-12500: Model with numeric case id's and filtering with the attribute mapped as case id: ERROR [22018] Numeric value <nowiki>''</nowiki> is not recognized.
* D-12509: Filtering null values didn't work in boolean attributes in Snowflake.
* D-12571: In dataframe processing in SQL Server, dividing two integers should not make rounding to integer.
* D-12610: Setting for global DropUnusedFiltersAfter was missing.
* D-12613: Filtering with case/event attributes with null values didn't match in Snowflake models.
* D-12617: Model didn't work when DropUnusedFiltersAfter is 00:00:00.
* D-12618: If model ConfigurationJson is null, Configuration property didn't work.
* D-12620: Filtering didn't work when there are backslaces in attribute names in Snowflake models.
* D-12643: AttributeFunctionCallExpression did not always work properly in array context.
* D-12647: SqlDataFrame with SQL Server: Comparing literals to variant column values failed.
* D-12648: Models that have DropUnusedModelsAfter setting caused "The sliding expiration value must be positive" error.
* D-11526: It was unable to translate Unicode character \uD83D at index 176 to specified code page.
* D-12637: In application startup arised FATAL Application startup exception System.UnauthorizedAccessException: Access to the path 'Global\MutexQPRPAActivation' is denied.


== Additional release for QPR ProcessAnalyzer 2022.6 (build 1262) (released 2022-10-19) ==
===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)


'''Fixed issues:'''
== QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21) ==
* D-12586: Scripts using client-side import with older version of QPR ScriptLauncher didn't work.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.pdf]
* D-12597: QPR ScriptLauncher was not sending heartbeats during import, which might have stopped the script prematurely.
* D-12589: Pressing Add measure/Add dimension button crashed chart.
* D-12558: In chart settings, setting expression to "(none)" gave error.
 
== QPR ProcessAnalyzer 2022.6 (build 1259) (released 2022-10-05) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release has the following issues which will be fixed in a hotfix (to be released soon):
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.
* Older QPR ScriptLauncher versions (<=2022.5) don't work with this release, when using the client side import. As a workaround, if updating to QPR ProcessAnalyzer 2022.6, also update QPR ScriptLauncher. Hotfix will be released to recover the backwards compatibility.
* When pressing the Add measure/Add dimension button in the chart settings, the chart settings dialog stop working. The workaround is to add the new measure/dimension to the bottom and use the Move up button to get the desired order of measures/dimensions. This issue will also be fixed in the hotfix.
* ETL scripts run using QPR ScriptLauncher in the client side import mode don't work if there is an import operation taking more than 10 minutes. This is because during the import, QPR ScriptLauncher erroneusly doesn't send the heartbeats to QPR ProcessAnalyzer Server, which then stops the script, believing QPR ScriptLauncher has stopped working. This issue occurs in all QPR ScriptLauncher versions. This issue will be fixed to QPR ProcessAnalyzer Server in the hotfix (i.e., no need to update ScriptLauncher).
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
QPR ProcessAnalyzer Server and QPR ScriptLauncher use now .NET 6 (instead of legacy .NET Framework). The hardware requirements are same, but the .NET 6 Runtime needs to be installed to machines running QPR ProcessAnalyzer Server and QPR ScriptLauncher. See more on the [[Updating_QPR_ProcessAnalyzer_Server|updating QPR ProcessAnalyzer]] instructions. Note that the IIS deployment script is not available anymore. QPR ScriptLauncher update is not mandatory (i.e., .Net Framework based QPR ScriptLauncher works with the .Net 6 based QPR ProcessAnalyzer Server), but update is recommended due to bug fixes made to the QPR ScriptLauncher.
* [[Object-Centric_Flowchart|Object-centric flowchart]] can also use object-to-object relations to link events and objects simplifying event-to-object configuration. (B-08671)
</div>
* [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] can provide precise quantitative analysis by making queries to eventlog data (powered by Snowflake Cortex Analyst and Agents). (B-08652)
* [[Filtering_in_QPR_ProcessAnalyzer|Flows and variations can be filtered]] from any event attribute viewpoint in Snowflake. (B-08737)
* Added [[Project_Properties_Dialog|project properties dialog]] for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
* [[QPR_ProcessAnalyzer_Project_Workspace#Validating_Model|Model validity check]] easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
* Projects can be [[QPR_ProcessAnalyzer_Project_Workspace#Exporting_Project|exported]] to json files and imported as new projects. (B-08717)
* Action buttons can be added to dashboard by defining [[Label_and_Link|label component]] that can change dashboard variables and run scripts. (B-08694)
* Web user interface is available in [[Languages_and_Localization|Ukrainian language]]. (B-08734)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Fixed issues===
Following legacy analyses have been removed: Flowchart (analysis number: 0), Variations (8), Duration (9), Profiling (10), and Flows (13). This functionality may have been used in the SQL scripts. Note that this change doesn't affect the functionality available in the QPR ProcessAnalyzer web UI.
* 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)


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts in the system that likely use the removed analyses:
===Other improvements===
<pre>
* When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
let removedAnalyses = Flatten([0,8,9,10,13].(["'AnalysisType','" + _ + "')", "'AnalysisType', '" + _ + "')"]));
* Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
OrderByDescending(Flatten(Projects.Scripts).Where({
* Stringified value format supports also json objects. (B-08766)
  let scr = _;Sum(removedAnalyses.{let num=_;scr.code?.Contains(num)})>0;
* Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
}),LastRunStart).(Project.Name + ": " + name + " (last run: " + (LastRunStart ?? "N/A") + ")");
* Translations have been updated. (B-08757)
</pre>
* Frontend components have been updated. (B-08760)
* Backend components have been updated. (B-08759)


</div>
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==


'''Features:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]
* B-06524: Search dialog for finding and selecting multi-select items.
* B-07173: CSV file importing supports date columns for row matching.
* B-07277: Query timeout for dashboards.
* B-06921: Expression language: For loop.
* B-07307: Expression language: DataTable.Synchronize().
* B-07288: SQL expression functions ToLower and ToUpper.
* B-07335: Expression language: Datatable.NameInDataSource-property.
* B-07336: ScriptLauncher client side import heartbeat.
* B-07176: Dataframe queries run in SQL Server are stopped when operation is cancelled.
* B-06986: Support for AggregateOthers setting in dataframe processing.
* B-07342: Improved validation for dashboard import.
* B-07267: Support for Comparison parameter in SQLExpression filter rule.
* B-06533: Timeout to /api/expression/query.
* B-07208: Remove deprecated analyses (part 2).
* B-07295: Frontend components update.
* B-07290: Translation updates for release 2022.6.
* B-07326: .NET 6 migration merge.
* B-07398: Improvements to PA service log writing during client-side import.


'''Fixed issues:'''
===New features===
* D-12098: Attribute function worked incorrectly inside Switch statement.
* 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)
* D-12491: Case filter was not shown in header if case id column is integer.
* Added a [[Filter_Selectors#Filter_selector|generic filtering component]] that can be configured for creating any type of filters for distinct values. (B-08654)
* D-12535: Variables disappeared when going to other dashboard.
* 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)
* D-12480: ScriptLauncher client side import stucked without error.
* 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)
* D-12501: Snowflake model gave error: ERROR [42P13] Invalid argument types for function 'SUM': (BOOLEAN).
* 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)
* D-12112: Added validation for allowed values of standard context variables.
* 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)
* D-12470: Truncating datatable made it unreadable.
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Logging|Native app logging]] has been improved and now sharing application logs with QPR is possible. (B-08661)
* D-12383: Chart settings export options didn't change when visualization is changed.
* Added [[DataFrame_in_Expression_Language#CsvToDataFrame|CsvToDataFrame]] function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)
* D-11424: Multiselect dropdown lists were shown partly out of screen in smaller screens.
* D-12270: Old version Big data chart didn't show correct error message.
* D-12471: Expression query windowing didn't take Criteria parameter into account.
* D-12461: Several datagrid column menus were incorrectly visible at the same time.
* D-12430: Dashboard gave error: Uncaught SyntaxError occurred: Invalid or unexpected token  at new Function (<anonymous>).
* D-12436: When query specific mapping was used, variations indicate flow that didn't exist in flows query.
* D-12432: SqlExpressionValue filter rule using Datediff function didn't work.
* D-12393: Expression generated with "Show Expression" in query designer did not support column role mappings.
* D-11272: Measure/Dimension/Column settings icon was changed to be more understandable.
* D-12416: Some UI strings were not translated properly.
* D-12153: Removed logging when defining functions.
* D-12485: Business calendar performance issue - part 1.
* D-12537: Variables didn't work in PA opening url when SAML is in use.
* D-12506: Root Analysis gave error "Operations that change non-concurrent collections must have exclude access".


== QPR ProcessAnalyzer 2022.5 (build 1179) (released 2022-08-24) ==
===Fixed issues===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 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)
Datatables can be stored to a separate SQL Server database, i.e., the datatables are not anymore created to the QPR ProcessAnalyzer metadata database. This improves performance as data intensive operations are isolated from metadata operations. To take the feature into use, create a new database in SQL Server and set the [[PA_Configuration_database_table#General_Settings|SqlServerConnectionString]] setting in the configuration table to connect to that database. When the configuration has been made, all new datatables are created to the datatables database. Pre-existing datatables are still located in the metadata database. To get the pre-existing datatables to the new database, they need to be recreated, which can be done by creating a duplicate of the datatable. Support for the metadata database stored datatables is continued, but deprecating the support in future will be considered.
* When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
</div>
* 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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Other improvements===
Following legacy analyses have been removed: Variations Chart (analysis number: 1), Event Types Chart (4), Models (17), Model Report (21), Project Report (22), Datatable Report (23), and Script Report (24). To replace these analyses, use the corresponding native functionality in the expression language.
* 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)


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts in the system that likely use the removed analyses:
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==
<pre>
let removedAnalyses = Flatten([1,4,17,21,22,23,24].(["'AnalysisType','" + _ + "')", "'AnalysisType', '" + _ + "')"]));
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.{let num=_;scr.code?.Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
Security hardening instructions to set the [[QPR_ProcessAnalyzer_Security_Hardening#Add_Security_Related_HTTP_Headers_in_IIS|Content-Security-Policy]] http header, has changed. In addition, the '''img-src''' directive includes also '''blob:''' urls (this allows to export Highcharts charts).
* 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)
</div>


'''Features:'''
===Fixed issues===
* B-06898: In Snowflake models, events can be filtered based on event attribute values.
* 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)
* B-06996: In Snowflake models, event type mapping can be defined for each chart.
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
* B-07069: Datatables can be stored to separate SQL Server database to reduce load from metadata database.
* Clustering analysis didn't work with object-centric models. (D-14486)
* B-06525: In dashboard editor, the background alignment grid is now better visible with any background color.
* 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)
* B-06844: In script editor, the script status is automatic refreshed.
* Deleting last group didn't remove the group from the list. (D-14504)
* B-06643: Links in header changed, e.g., the eLearning library link.
* B-06981: Chart settings remember the last opened tab, and the settings are always for the active chart.
* B-06467: Added SelectDistinct function for dataframes for selecting distinct rows.
* B-06933: Added "Like" function to SQL expressions for string pattern matching.
* B-06543: Generic Eval function for evaluating an expression given in a string.
* B-06944: Truncate function to efficiently delete all rows from datatable.
* B-07207: Access to properties CreatedBy, LastModifiedBy and LastImportBy for datatables using expression language.
* B-06906: Added Configuration property to Model and Datatable objects to get configuration json as dictionary.
* B-07170: Added ScriptByName and ModelByName functions for project objects and changed behavior for DatatableByName function.
* B-06919: Expression language: Increment (++) and decrement (--) operators.
* B-06829: UI remembers the user's last selected model in next login.
* B-07000: Workspace Models and Scripts tab auto-refresh has been optimized for performance.
* B-06456: Changed icons in chart Visualization selection.
* B-07175: Removed deprecated analyses.
* B-07205: Replaced Scripts analysis (24) with expression language property.
* B-06813: Pacm file support case and event attribute data types.
* B-06907: Define start row for the returned data in dataframe processing.
* B-06879: NumberPrecision and DatetimeTruncation support for dataframe queries Values columns.
* B-06998: Implemented referrer policy HTTP header.
* B-06936: Prevented using outdated caches in dataframe processing.
* B-07066: Snowflake queries has been optimized by removing unnecessary metadata queries.
* B-06900: Backend support for expression filter rules to dataframe processing.
* B-06987: Add caching for Project objects.
* B-06910: Frontend components have been updated.
* B-07117: Translation updates for release 2022.5.


'''Fixed issues:'''
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==
* D-12075: DashboardFilter variable rules were applied in incorrect order.
* D-12351: Pivot table columns headers had unnecessary prefix when there are multiple measures and no dimensions in columns.
* D-11946: Content security policy violation occurred when exporting Highcharts charts as images.
* D-12064: Chart pending query was incorrectly cancelled when going to and from Add component mode.
* D-11606: Scripts and Projects tab slightly covered the top borderline of workspace datagrid and entire grid was not visible.
* D-12389: When using AggregateFrom, filters were always applied on the completely unfiltered set of events even if a "top level" filter existed also.
* D-12324: The visibility stepper counter didn't follow changed variations.
* D-12373: CSV import may have failed when there are line breaks in strings.
* D-12045: Column filter was not cleared when user switched to other view in Recycle bin.
* D-11590: Two context menus were visible at the same time.
* D-11131: It was not possible to move data grid column Custom filter dialog.
* D-11401: For datatables filter popup menu was opened outside visible dialog and required more scrolling to be seen.
* D-11650: In Workspace, sub context menu for target projects to move items didn't open with latest Syncfusion.
* D-11651: Multiselect list lost some items when using search.
* D-11657: Combobox autofill was broken.
* D-11639: User's default model did not behave as it should.
* D-12085: Filter rules in header were lost when pressing F5.
* D-12142: KPI card value is now visible for non-numeric values.
* D-12105: Nullable object must have value error displayed  when trying to open Enhanced BPMN dashboard.
* D-12157: Root causes analysis in the Conformance Root Causes Analysis didn't work.
* D-12067: Some tooltips, e.g., in BPMN button, didn't disappear at all.
* D-12069: User got querying variation error when first time created big data flowchart.
* D-12177: In models list, search and cancel icons were vertically misaligned.
* D-12116: Add and delete filter rule from Create Filter dialogue did not work.
* D-11445: When using very large value for border corner roundness, chart settings were not visible.
* D-12166: External content presentation object was broken due to too strict content security policy.
* D-12151: KPI card incorrectly showed error "Measure data type needs to be numeric" when numerical measure has null value.
* D-12150: Event data column named "Case ID" mapping to both Case ID and Event Type caused error "An item with the same key has already been added".
* D-12325: Workspace root level had too many New items in context menu.
* D-12326: Wrong menu displayed for sub projects if first click create new option for root level from project tree view.
* D-12000: Script log system report default time interval was too long making report very slow.
* D-12119: Uncaught (in promise) TypeError occured: Cannot set properties of undefined (setting 'isAnimate').
* D-12293: "Cannot read properties of undefined (reading 'id') at o.checkTabNames" error occured.
* D-12294: Term ID was incorrectly translated.
* D-12353: Dialogs broke when there are quotation marks in header.
* D-11978: Soft deleted project could incorrectly be queried by admins.
* D-11982: Null reference error when filter contained attribute value with null.
* D-11706: Deadlocks during tests in Concurrency test category.
* D-11893: User.Globalpermissions returned incorrectly Hashset for inactive users (should return array).
* D-11892: Project-specific user role could be assigned without project id (as global).
* D-12114: In-memory core gave now and then error: The given key was not present in the dictionary.
* D-12138: Timespan function incorrectly assumed 32-bit integers.
* D-11548: Removed setting of default model and view.
* D-12230: Column mappings didn't work for some dataframe processing operations.
* D-12100: Giving project name (possibly id too) for DataFrame.Persist did not work when persisting a SqlDataFrame.
* D-12099: Querying SqlDataFrame for an empty table returned an empty in-memory DataFrame.
* D-12301: Duplicating local datatable didn't create datatable in sqlserver.
* D-12097: Error "Unable to join two tables without specified binding columns", when dimensioning events by two case attributes.
* D-11862: Filter with integer stringifiedvalues raised an exception when running in in-memory.
* D-12087: Error: Ambiguous column name 'CaseId'. The column 'CaseId' was specified multiple times for 'df_5'.
* D-12297: The datediff function resulted in an overflow when using high precision in SQL Server.
* D-12288: Error in querying event type measures: An item with the same key has already been added.
* D-12329: Filters using boolean attributes didn't work in SQL Server/Snowflake.
* D-12054: Backslashes in string literals gave null reference error in dataframe processing.
* D-12065: Case attribute filtering with column mapped to case id didn't work in filters.
* D-12070: PA server incorrectly modified dashboard json.
* D-12046: Expression language DateTime.Ticks was always UTC time.
* D-12102: SQL Expression: Variable-function did not work if the variable has upper-case letters.
* D-11950: Using list aggregation with different orderings in a single select did not work.
* D-12345: Mapping columns and using Columns function caused error 'invalid identifier'.
* D-12082: SourceData definition to events effected case attributes.
* D-12348: DateDiff did not support milliseconds in-memory.
* D-12374: Overflow error occurred when calculating standard deviation for case durations in large model.


== QPR ProcessAnalyzer 2022.4 (build 1001) (released 2022-05-31) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Expression language has new function [[Generic_Functions_in_QPR_ProcessAnalyzer#Data_source_connectors|CallWebService]] for extracting data from web API's and make generic http calls. This function replaces the ReadWebService function which was a pre-production version of the same functionality. The ReadWebService function is thus now deprecated and it will be removed in future.  
There is an issue causing some dashboards having more than 50 charts to open slowly. The issue has been fixed in the next release by D-14503.
</div>
</div>


'''Features:'''
=== Fixed Issues ===
* B-06864: New dashboard component: Big data flowchart that calculates in Snowflake.
* Fixed issue where system stopped responding after opening Scripts tab several times (error in logs: Timeout expired prior to obtaining a connection from the pool). (D-14506)
* B-06434: Flowchart has been improved by adding e.g., presets, tabs and title (both in in-memory and big data flowchart).
* Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
* B-06515: New setting for chart to prevent applying chart filter to other charts ([[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters to dashboard]]).
* Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
* B-06450: Log in screen visual layout has been renewed.
* Fixed issue in User Management where assigning role to project or adding user to group was not saved when there was a column filter. (D-14124)
* B-06876: User management system reports including used license for each user.
* B-05981: Expression language function CallWebService for web api and http calls.
* B-06789: Datetime truncation function support for half-year and millisecond time units.
* B-06497: SqlExpression function for getting string length.
* B-06581: SqlExpression function for trimming white spaces from strings (Trim).
* B-06630: SqlExpression function to add duration to date (DateAdd).
* B-06631: SqlExpression function for getting a substring of a string (Substring).
* B-06860: SqlDataFrame function to remove columns (RemoveColumns).
* B-06832: When error occurs in script run in client side, error message is shown in script log.
* B-06818: Russian language has been removed from UI.
* B-06445: Datatable row counts are cached to avoid querying the information from Snowflake.
* B-06843: Backend support for filter rule to filter events by event attribute values.
* B-06871: Translation updates for 2022.4 release.


'''Fixed issues:'''
== QPR ProcessAnalyzer 2025.3 (build 9699) (released 2025-04-16)==
* D-11802: When closing fullscreen, sometimes main header stayed invisible.
 
* D-11947: Dynamic dropdown lists didn't open in first click in certain situations in Firefox.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
* D-11783: Flowchart start/end flow measure label showed in incorrect place when there are only one starting/ending flow.
* D-11796: Data export in pivot table didn't work.
* D-11530: When model is moved to other project, linked datatables are now not moved.
* D-11714: Scripts list hover buttons didn't work in Firefox.
* D-11500: Duplicated name check for workspace items was missing.
* D-11782: Some in-memory chart expressions gave parse exception: token recognition error at: '\n'.
* D-11871: Importing large number of rows to Snowflake could be very slow, as it incorrectly used SQL insert.
* D-11781: Persisting more complicated SqlDataFrames did not work.
* D-11849: Script log was not generated when running tasks in parallel using AsParallel function.
* D-11789: Changing expression to "none" crashed UI, and line breaks were incorrectly removed in multiline text fields.
* D-11817: Error missing when trying to run --#CallWebService with ExecuteInClientSide=1 in web UI.
* D-11716: Deleted models were incorrectly listed in main header.
* D-11912: User management dialog showed global roles incorrectly after they have been changed.
* D-11940: Datatable rows column didn't show all when there is over 1 billion rows.
* D-11596: Event count calculated incorrectly using AggregateFrom events.
* D-11588: EventTypes root dimensioned by case count with AggregateFrom did not work.
* D-11778: Variations dimensioned by flow count gave error in SQLDataFrames.
* D-11788: User roles did not work in expression language.
* D-11815: Variation case count showed as too large when there was other value joining events.
* D-11818: Flow case count calculated incorrectly in dataframes.
* D-11794: Switch statement returned null reference exception when condition expression evaluates to null.
* D-11820: Variation duration calculation gave error in dataframes.
* D-11867: Variations were not deterministic if there were events with same timestamps.
* D-11891: Snowflake data import could fail in SQL insert mode due to too many statements.
* D-11848: Configuration needed to be defined as valid JSON 'null'.
* D-11784: Memorycache root gave errors when measures were used.
* D-11913: Root causes icon was missing on the header.
* D-11938: Design model was incorrectly not stored to the dashboard.
* D-11939: Filter rule dialog showed incorrectly case/event attribute datatype in eventlog mode.
* D-12004: Adjustment expression and Custom aggregation expression could not be emptied.
* D-12034: All filter rules were not visible in main header when there are lot of them.
* D-11821: Flow count of variation is incorrectly null for some variations.
* D-11834: Error when dimensioning flows by case count in dataframes.


== QPR ProcessAnalyzer 2022.3 (build 925) (released 2022-04-20) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
In Workspace, dashboards and scripts cannot be created anymore to the Workspace topmost level. All existing dashboards and scripts in the topmost level are moved to a new project named System, where administrators can access them. If dashboards and scripts are moved away from the Workspace level before the QPR ProcessAnalyzer 2022.3 update, the System project is not created.
There is a potentially serious issue that can cause the system to stop responding, when opening the Scripts tab in the Workspace. The issue has been fixed in the next release (build 9725) by D-14506.
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
In QPR ProcessAnalyzer 2022.3, the legacy ''SAP NetWeaver RFC'' library for SAP connections has been removed, and now SAP connections use the new ''SAP NetWeaver RFC'' library. Also the related SapProvider setting in the SAP import command is not anymore in use.
Object-centric model simplification in the story B-08667 (object attributes can only have a single value) doesn't work with this release. The issue has been fixed in the next release (build 9725) by B-08683.
</div>
</div>


'''Features:'''
===New features===
* B-06310: [[Big_Data_Chart|Big data chart]] to perform calculation in Snowflake.
* Enhanced [[AI_Agent|AI Agent]] with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
* B-06654: Dashboards, models, datatables and scripts are removed from Workspace level.
* In [[Object-centric_Process_Mining_Model|object-centric models]], object-to-object relations are now followed by traversing once all object types. (B-08606)
* B-05763: Possibility to set SAML service provider signing certificate.
* 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)
* B-06765: Remove legacy library for the SAP data connector.
* Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
* B-06812: Make it possible to overwrite existing SqlDataFrame columns.
* "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
* B-06554: Support for IN operator in SQL expressions.
* Snowflake Event Types preset has been improved by adding suggestion of desired and undesired activities based on frequency of occurrence. (B-08656)
* B-06779: SQLDataFrame IN function support for null values.
* Added checkbox for [[Measure,_Dimension_and_Column_Settings#Advanced_settings|disabling filtering]] for individual dimensions or columns. (B-08589)
* B-06553: Round and TruncateDate functions for SQL expressions.
* Case and event attributes dropdown lists show number of unique values in Snowflake models (instead of attribute datatype as previously). (B-08316)
* B-06776: Support for NumberPrecision and DatetimeTruncation parameters in dataframe processing dimensions.
* [[SAML_2.0_Federated_Authentication|SAML authentication]] can now synchronize user groups from identity provider. (B-08612)
* B-06759: Migrate root level dashboards and scripts to new project.
* Groups can be [[Manage_Users_and_Groups#Deleting_Group|deleted]] in user management. (B-08330)
* B-06569: Frontend components have been updated.
* [[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)
* B-06794: Translation updates for 2022.3 release.
* 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 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)


'''Fixed issues:'''
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==
* D-11642: Sometimes dashboard charts showed loading animation forever.
 
* D-11708: Text filters did not work correctly in dashboard tables.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]
* D-11565: Delete icon showed incorrectly in dashboard properties and session variables.
* D-11537: Script run failed to session expiration error when running in ScriptLauncher and try to perform client side operation after session expiration.
* D-11196: Table column filtering context menu didn't show when table was in full screen.
* D-11591: It was not possible to import csv file having numbers with exponential notation.
* D-11543: Sometimes it was not possible to scroll to last row for workspace tabs.
* D-11338: When filtering in the flowchart, the include/exclude selection didn't show when flowchart was in full screen.
* D-11605: Implemented datatables metadata caching, as opening models list was too slow in some environments.
* D-11564: "Given key was not present in the dictionary" when all mandatory but useless values were not defined in script launcher config file.
* D-11572: BPMN model tooltips was hidden behind the bpmn editor.
* D-11586: KPI Card crashed when showing string values.
* D-11599: KPI card could not display very large values properly.
* D-11496: UI didn't work well in situation where there were no models available for user.
* D-11575: Column/bars were not visible for exported polar charts.
* D-11593: When creating user, error message about exists username didn't remind about inactive users.
* D-11600: Settings button was not visible in Process Discovery when KPI Card was used.
* D-11570: Slice into dimension didn't work for Root causes for Attributes preset.
* D-11589: Context menu that was not related to the recycle bin was incorrectly shown in Workspace.
* D-11622: Expression filter rules with different periods (DateGranularity) were handled incorrectly.
* D-11465: Add tooltip to effective permission table in Manage users dialog.
* D-11623: Tabs in model properties dialog didn't show correctly in narrow screens.
* D-11638: Changing include/exclude state of existing filter rule showed incorrect filter rule parameter selections.
* D-11654: Two popup menus sometimes incorrectly shown for Design Model Selector.
* D-11517: In Workspace first column "Name" was not visible if window was not wide enough to show all columns.
* D-11619: Query Designer and chart multiline text boxes didn't accept non-breaking spaces.
* D-11645: Column data type was missing in the setting of Datatable view.
* D-11554: Dataframe expressions were incorrectly executed by default in-memory.
* D-11585: Error text was misleading when SAP dll missing during import in server.
* D-11583: Error about Maximum Rows message was not displayed in analysis result but instead {} was displayed.
* D-11610: Event count showed incorrectly when including cases based on event types (in dataframe processing).
* D-11549: Column mappings script did not work with specific model.
* D-11634: Dashboard Properties/Variables had the wrong checkbox icon.


== QPR ProcessAnalyzer 2022.2 (build 854) (released 2022-03-09) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
SAML 2.0 authentication has been renewed, changing related urls as follows: SAML authentication is initiated from path '''/saml2''' (previously it was /api/saml). In addition, the redirect back url is now '''/saml2/acs''' (previously it was /api/samlsignin). These changes need to be made to the identity provider and taken into use during the QPR ProcessAnalyzer 2022.2 update. In addition, the redirection to the SAML authentication initialization path, that has possibly been set to IIS, need to be changed.
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 [[Navigation_Menu#Expression_Designer|Expression Designer]] (with System administrator user) to list models where the events datatable timestamp column type is string:
<pre>
Models.Where({
let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
}).(Name + " (id: " + Id + ")");
</pre>
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
[[SQL_Scripting_Commands#--.23ImportSapQuery|SAP connector]] has been changed to use the newer SAP NetWeaver RFC Library provided by SAP. Due to this change, additional installation steps for [[QPR_ProcessAnalyzer_ScriptLauncher#Installing%20SAP%20NetWeaver%20RFC%20Library|QPR ScriptLauncher]] and [[Install_QPR_ProcessAnalyzer_Server_Manually#Installing%20SAP%20NetWeaver%20RFC%20Library|QPR ProcessAnalyzer Server]] need to be done. The changes only affect environments where the SAP connector is enabled.
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>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===New features===
The WCF API has been removed from QPR ProcessAnalyzer 2022.2. Before updating, all customized integrations and other solutions that use WCF API need to be converted to use [[QPR_ProcessAnalyzer_API|Web API]]. Note that there may also exist scripts that contact the WCF API using the [[SQL_Scripting_Commands#--.23CallWebService|--#CallWebService]] command. The used API can be distinguished from the url: if it contains "/MainService.svc" the connection is to the WCF API and changes are required. Note also that if QPR ProcessAnalyzer Excel client has still been in use, from now on it will not work.
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
</div>
*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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Fixed issues===
Due to the WCF removal, [[Installing QPR ProcessAnalyzer Server|installing]] QPR ProcessAnalyzer Server is now easier, as there is only one web.config file (i.e., no separate web.config files for http and https). Note also that the contents of the web.config file is changed, so settings contained by the file need to be migrated manually.
*Prevented following error in Snowflake dashboards: Object "qprpa_dt_cache_..." already exists when creating a cache table. (D-14348)
</div>
*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)


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
===Other improvements===
[[SQL Scripting Commands#--.23ImportSalesforceQuery|Salesforce connector]] has been changed to use Salesforce REST API, and the API version is changed from 38 to 54. Due to the change, there might be slight differences in the Salesforce connector behavior.
*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)
</div>
*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)


'''Features:'''
==QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)==
*
* B-06441: Snowflake stored datatables and models can be managed in [[QPR ProcessAnalyzer Project Workspace#Datatables|Workspace]].
* B-06495: In the out-of-the box dashboards, chart and flowchart settings are now remembered during the user session.
* B-06314: In Workspace, Models and Scripts tabs refresh automatically to show the current models and scripts status.
* B-06551: New [[Measure, Dimension and Column Settings#Statistical calculations|statistical calculations]] for charts and other statistical calculations improvements.
* B-06362: Expression language: [[QPR ProcessAnalyzer Expressions#Conditional statement .28switch.29|switch-case-default-break statement]].
* B-05802: Support for encrypted SAML 2.0 assertions.
* B-06259: SAML 2.0 authentication library has been changed.
* B-06428: Removed limitation from SAP connector to allow multiple SAP extractions simultaneously.
* B-05837: Root causes calculation is available in the expression language.
* B-06526: When ComparisonEventLog is used in an expression, it's initialized automatically.
* B-06303: WCF client has been dropped.
* B-06563: All WCF related functionalities has been removed.
* B-06558: Salesforce connector has been changed to use Salesforce REST API.
* B-06514: In Workspace, scripting and model permission restrictions are better reflected in the UI.
* B-05960: Distributed computing: All datatable columns are made available in dataframe processing method.
* B-06500: When empty, DatabaseId is generated automatically in PA_CONFIGURATION table on startup.
* B-06567: Translation updates for 2022.2 release.


'''Fixed issues:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
* D-11484: Scripts incorrectly stayed in stopping state, when system was shut down while the script was running.
* D-11537: Script failed to session expiration error when running in ScriptLauncher and performed a client side operation after session idle timeout.
* D-11495: Model specific DropUnusedModelsAfter setting is removed in server side as it didn't work as intended.
* D-11507: Removed "Drop unused model after" setting from UI, as it didn't work as originally intended.
* D-11497: Running script in web UI having ExecuteInClientSide=1 never completed.
* D-11523: Chart tooltip showed incorrect series when some series was hidden.
* D-11489: Percentage character (%) was lost from file name when exporting a filter to a json file.
* D-11557: Highcharts based charts were not disposed correctly on redraw causing out-of-memory error.
* D-11490: Stored filter rules were lost from default public filter when setting "All cases" to default public.
* D-11498: Trying to import empty csv file caused JavaScript error.
* D-11499: Trying to import csv file with header line only, correctly suggests now strings as datatype (instead of integers).
* D-11494: Flow Duration Distribution report had JavaScript error in the Enhanced BPMN dashboard.
* D-11501: Hiding event type name from flowchart caused error.
* D-11502: Right click didn't work when user opened BPMN editor from measures settings.
* D-11506: BPMN editor could not be opened in the Notification rules editor when creating measure.
* D-11478: Model properties window stayed visible in login page after session expiration.
* D-11491: JPG format file export had incorrect black background color.
* D-11513: Multi-select list item removal using the X button didn't work.
* D-11505: Changed new wiki location to the Help buttons.
* D-11486: Untranslated strings and translation inconsistencies for Finnish language fixed.
* D-11479: Selection list for new task could not display properly in BPMN editor.
* D-11508: Console error occurred when selecting Case conformance level in Notification rules editor.
* D-11510: Adjusting Object sample size caused error for Top violations chart.
* D-11144: Workspace scripts grid permissions was not checked when showing items context menu.
* D-11234: Creating new model option was incorrectly enabled when user had only view or analyst role for project.
* D-11520: In workspace, changing project with drag-and-drop takes now user permissions better into account.
* D-11521: Title could not display properly for datatable properties when using Finnish UI.
* D-11536: Translation support was missing for "Running" in Script Editor.
* D-11450: Export filter button was enabled in not possible state.
* D-11444: All duplicated dashboards had same identifier.
* D-11483: Unnecessary scrollbar was sometimes displayed in System reports dialog.
* D-11402: Rename icon was using wrong graphic.
* D-11558: Icons in UI had small vertical alignment problem.
* D-11559: UI used incorrect icon for Export functionality.
* D-11544: Datatable column names starting with lower case showed incorrectly in upper case.
* D-11482: Importing table to itself using SqlDataFrame caused the SQL Server to get partially stuck.
* D-11458: There was null reference error when ProcessingMethod is dataframe, ContextType is generic, and root is Cases.
* D-11487: ScriptById function did not return Access denied error if script didn't exist.
* D-11461: Filtering didn't work in dataframe mode when StringifiedValues was used.
* D-11540: Column mappings didn't work with WithRowNumberColumn function in SqlDataFrames.
* D-11231: In the Enhanced BPMN editor screen, import/open icon was wrong.


== QPR ProcessAnalyzer 2022.1 (build 774) (released 2022-01-24) ==
===New features===
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
*B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
Known issue: If the "Drop Unused Model After" setting is specified for a model, the model may incorrectly be dropped from the memory when the memory consumption is high. As a workaround, set this setting to empty, so that the model is not dropped by itself. This incorrectly behaving setting will be removed from the software in the next release (D-11507).
*B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
</div>
*B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
*B-08439: Added project settings [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Database_and_Schema|DatabaseNameInDataSource and SchemaNameInDataSource]] to define Snowflake database and schema.
*B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
*B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].


'''Features:'''
===Fixed issues===
* B-06334: New dashboard component: textual labels can be added to dashboards.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* B-06324: Chart settings icon can be hidden in preview mode, and also icons visual layout has been improved.
*D-14323: Filtering with "Split data by filtering" dimension didn't work with exclude type of filter rules and when there were multiple filter rules.
* B-06494: Expression language: break and continue statements.
*D-14346: Fixed issue where manual activation using activation utility didn't work.
* B-06435: Web UI web page title in browser header simplified.
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* B-06535: Copyright year updated to 2022.
*D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* B-06466: Updated to Angular 13.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
* B-06521: Frontend components have been updated.
*D-14331: Flowchart lost selection when flowchart used linked variables with array values.
* B-06448: Optimized Snowflake data import using Put command.
*D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
* B-06481: Added support for project description field to expression language and Web API.
*D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
* B-06491: Improvements for taking into use new SAP library.
*D-14342: Flow step and Zoom settings control have same size and layout is aligned.
* B-03053: Backend support for expression scripts permissions.
*D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
* B-06501: Translation updates for release 2022.1.
*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.


'''Fixed issues:'''
===Other improvements===
* D-11462: Model notifications were not visible if there was notification containing dimensions.
* B-08391: Datatable access has been optimized improving performance for object-centric models.
* D-11435: Links in model description showed "&" characters incorrectly.
*B-08529: Added support for array type in stringified value format.
* D-11447: Linked settings and variable mappings didn't work with flowchart.
*B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
* D-11454: ScriptLauncher didn't work when only hostname was specified in ServiceURL.
*B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
* D-11419: In CSV import, row number showed incorrectly in column count mismatch error message when file size was over 10MB.
*B-08544: Frontend components have been updated.
* D-11425: In chart, Statistical calculation "Show change from previous" didn't show empty for first row.
*B-08561: Updated translations for release 2025.1.
* D-11307: Transparent color was not working for chart layout setting.
* D-11439: Date format was changed in workspace when changing only the language.
* D-11423: Dropdown lists were shown partly out of screen in smaller screens.
* D-11477: Maximum rows in Root causes didn't have maximum limitation.
* D-11167: Removed unnecessary "_." structures from chart expressions.
* D-11470: Catch function failed with a constant expression and non-constant resultIfException expression.
* D-11429: There existed Undefined % and NaN value in Root Causes Analysis result.
* D-11343: Script log was written to wrong script when expression script calls SQL script.
* D-11377: Stdevp function incorrectly returned zero for array of one element.
* D-11255: Train function didn't work with only one case in training set.
* D-11413: Color picker cancel button didn't work.
* D-11414: Clicking context menu icon in projects hierarchy tree in Workspace to open sub menu, didn't do anything.
* D-11245: Removed not needed fonts.
* D-11453: Wrong font used for System reports.
* D-11455: Red color error message didn't use Open Sans font.
* D-11180: Workspace contextual menu icons vertical alignment was incorrect.
* D-11475: BPMN context menu hidden behind other frame when webpage zoom setting was bigger than 110%.
* D-11416: Context menu in projects hierarchy didn't open in Cypress tests.
* D-11115: Title of event type filter didn't display "&" character properly.
* D-11097: When clicking data grid input validation message, JS error appeared: TypeError: Cannot read property 'data' of null  at Gs.getRowInfo  at Gs.mouseClickHandler.
* D-11267: Unable to use datatables with columns names having square brackets.
* D-11243: Project LastModifiedDate and LastModifiedBy are now updated when project properties are changed.
* D-11457: There was useless error message when HTML error is get via Web API.


== Old Releases ==
== Old Releases==
See older releases in [[QPR ProcessAnalyzer Release Archive]]
See older releases in [[QPR ProcessAnalyzer Release Archive]]
__NOTOC__
__NOTOC__


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

Latest revision as of 09:49, 5 November 2025

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

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

See roadmap for next release features and fixes

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

New features presentation: QPR_ProcessAnalyzer_2025_6.pdf

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

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

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

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

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

New features

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

Fixed issues

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

Other improvements

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

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

New features presentation: QPR_ProcessAnalyzer_2025_5.pdf

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

New features

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

Fixed issues

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

Other improvements

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

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

New features presentation: QPR_ProcessAnalyzer_2025_4.pdf

New features

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

Fixed issues

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

Other improvements

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

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

New features

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

Fixed issues

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

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

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

Fixed Issues

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

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

New features presentation: QPR_ProcessAnalyzer_2025_3.pdf

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

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

New features

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

Fixed issues

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

Other improvements

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

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

Fixed issues

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

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

New features presentation: QPR_ProcessAnalyzer_2025_2.pdf

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

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

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

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

New features

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

Fixed issues

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

Other improvements

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

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

New features presentation: QPR_ProcessAnalyzer_2025_1.pdf

New features

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

Fixed issues

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

Other improvements

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

Old Releases

See older releases in QPR ProcessAnalyzer Release Archive

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