QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
 
(607 intermediate revisions by 5 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 2023.4 (planned release date 2023-06-14) ==
== Next Release: QPR ProcessAnalyzer 2025.2 (planned release 2025-03-04) ==


'''Features:'''
[[Next_Release_Content|See plan for next release features and fixes]]
* B-06383: Added [[Sankey_Chart|Sankey chart]] to visualize flow from one set of values to another.
* B-07823: Flowchart Bottlenecks preset has been changed to show bottlenecks for event types, and renewed System Tasks reports to use expression language based interface.
* B-07873: Improved [[QPR_ProcessAnalyzer_Pivot_Table|pivot table]] visual layout to highlight totals and aggregated data, and also mapping to rows titles are visible.
* B-07912: Added new [[SQL_Expressions#Array_functions|array functions ArrayToString and ArrayOverlap]] to Snowflake.
* B-07905: Added [[SQL_Expressions#Rank_functions|Rank related functions]] to Snowflake, such as FirstValue, LastValue, NthValue, Lead and Lag.
* B-07757: Backend support for datatables linking to user-definable Snowflake database, schema and table.
* B-07940: Removed "Count" aggregation from textual values in Big data chart (you can use the Case count, Event count, etc. selection instead).
* B-07825: Improved error message when trying to use non-existing attributes in Snowflake queries.
* B-07872: List aggregation with Distinct=true orders now items by their value.
* B-03103: [[QPR_ProcessAnalyzer_Logs#Task_Log|Task log]] (operation log) can be accessed in expression language.
* B-07902: Optimized sequences of joins in Snowflake queries.


'''Fixed issues:'''
== Latest Release: QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23) ==
* D-13660: Disabling filter rules didn't work in Snowflake.
* D-13526: Passing data frames from SQL scripts to expression scripts did not work.
* D-13528: Error message for certain erroneous SQL expressions was unclear.
* D-13677: "Flow occurrences with specific case attribute value" selection didn't work in in-memory chart.
* D-13661: PA crashed when there was no access to conformance UDF's.
* D-13653: Big data flowchart Root causes preset showed incorrect legend.
* D-13626: Flowchart freezed, when converting into big data flowchart and vice versa by modifying chart json settings.
* D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
* D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
* D-13598: Chart gave unclear error message when events datatable is not defined.
* D-13655: Improved error messages for BPMN editor and conformance statistics.
* D-13704: In CSV file import, parsing now allows spaces between column separator and text quotation mark.
* D-13663: Pivot table border line was slightly broken in the header area.
* D-13703: Snowflake stage file-based import failed to parse exception.
* D-13708: Duplicating datatable using user defined table, removed data the source table.
* D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
* D-13707: SQL Scripting: GetAnalysis 18 did not always copy the contents of the data table to the target table correctly.
* D-13693: Snowflake conformance analysis performance issues.
* D-13348: Unclear error message when dataframe processing had incorrect expression.
* D-13717: Dependency wheel crashed when there was zero weights and showing data labels.
* D-13729: There was a JavaScript error when limited user tried to access business calendar.
* D-13732: Pivot table Excel export contained some data formatted incorrectly.


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


'''Features:'''
===New features===
* B-07818: [[Conformance_Analysis|Conformance analysis]] is supported in Snowflake with following dashboard components: Big data chart, BPMN editor, Conformance statistics, and Design model selector.
* B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
* B-07833: [[Root_Causes#Root_causes_in_flowchart|Root causes analysis for flowchart]] is available for Snowflake showing how the event and flow occurrences explain selected phenomena.
* B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
* B-07786: Big data chart has more [[Big_Data_Chart#Measure_aggregations|measure aggregations]], such as median, percentile, standard deviation and variance. Also for textual items, unique values can be listed.
* B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
* B-07795: [[QPR_ProcessAnalyzer_Table#Conditional_formatting|Conditional formatting]] supports also columns with non-numerical contents.
* 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-07830: [[Big_Data_Chart#Measure_aggregations|None and Any aggregations]] for Snowflake and user-friendly formatting for conformance violations.
* B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
* B-06527: Error messages in [[Importing_Data_to_Datatable_from_CSV_File|CSV file import]] show also the column number to help working with CSV files with lot of columns.
* B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].
* B-07747: In-memory conformance checking accepts design models with multiple tasks having same name (same is followed by the Snowflake implementation).
* B-07659: In-memory flowchart preset Case Conformance to visualize conformance checking violations.
* B-07571: Added function IsConformant to backend to check whether cases are conformant.
* B-07863: Added function ConformanceViolationsFlows to backend to return nonconformance reasons for violating cases.
* B-07844: Support for "array" aggregation to return aggregated items as array.
* B-07856: Support for creating and accessing arrays and objects in SQL expressions.
* B-07860: Array handling functions and Tasks property for DesignModel entity.
* B-07847: Added throttling for QPR ScriptLauncher client-side imports to limit memory usage.
* B-07811: Snowflake query optimization to omit columns that are not used by the query.


'''Fixed issues:'''
===Fixed issues===
* D-13632: Going from variations to event types led to very poor performance with certain models.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* D-13628: Statistical calculations were incorrectly not applied in chart CSV export.
* 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-13575: SQL script may have given error "Operand type clash: nvarchar(max) was incompatible with sql_variant".
* D-14346: Fixed issue where manual activation using activation utility didn't work.
* D-13597: UI supports now datatable column type "ShortString" (previously datatable contents preview and CSV import didn't work).
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* D-13536: Using business calendar sometimes gave error "System.InvalidOperationException: Collection was modified".
* D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* D-13477: Chart types without y-axis mapping caused an error when series mapping was used.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
* D-13453: _model variable was not available for Snowflake expression filter rules.
* D-14331: Flowchart lost selection when flowchart used linked variables with array values.
* D-13527: Checkbox height didn't increase when long label needed to span to multiple lines.
* D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
* D-13363: Snowflake query with EvaluateAfterAggregations and IsHidden failed when dimensioning by case id column.
* D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
* D-13383: Snowflake query gave error "Invalid column name 'FromCase Name'".
* D-14342: Flow step and Zoom settings control have same size and layout is aligned.
* D-13523: Request id was incorrectly shown as zeros in error messages.
* D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
* D-13541: In CSV import, error message for maximum number of columns exceeded is improved (maximum is 300 column for SQL Server).
* D-14327: AI Assistant had console error when pressing send button without text.
* D-13583: Objects count in header didn't work for empty Snowflake model.
* D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
* D-13553: Larger pacm files can now be imported, as there isn't error "Request body too large. The max request body size is 30000000 bytes".
* D-14321: Added error message for AI Assistant when trying to use it without model selected.
* D-13306: Stack overflow error was given when using SqlDataFrames.
* D-13487: When Flows root and there was filter in Values expression, some flows were lost.
* D-13540: SqlDataFrame query with 300 columns failed to error "WithExpressionColumn: No name given for the new column".
* D-13429: Ordering in List aggregation couldn't find columns in dataframe query.
* D-13406: Dataframe query with root FlowOccurrences and get value from cases caused error.
* D-13538: There was incorrect handling of escaping characters in column names used in dimensions.
* D-13633: Fixed ordering in List aggregation with null and empty values.
* D-13636: Query that dimensions by numeric case attribute with AggregateOthers true, caused error.
* D-13589: Creating Snowflake datatable did not connect to Snowflake.
* D-13623: Value expressions without aggregation didn't work with AggregateOthers setting.
* D-13554: In in-memory chart, percentile function might have return both Int64 and Double type of objects which cannot be sorted.
* D-13481: Improved error message when trying to use deleted model.
* D-13621: Dynamic value search dialog had incorrect font in lists.
* D-13610: Some invalid BPMN files crashed BPMN editor.
* D-13614: Checkbox label texts overflowed to right.
* D-13520: Removed excessive parameters from the Query Designer for generic context queries.
* D-12998: QPR icon was incorrectly positioned in header in Safari.
* D-13480: Import to duration data type is removed from Snowflake datatables, and for local datatables duration type maximum size is checked.
* D-13517: In Highcharts-based visualizationsm conditional formatting didn't work for other than the first y-axis mapping.
* D-13529: In some presets containing several on-screen settings, when chart showed in error message, on-screen settings showed invalid selection.
* D-13530: Opening dropdown list caused JavaScript error when the list contents should be empty after it previously contained items.
* D-13486: Removed unreachable error message in CSV import.
* D-13524: Fixed in-memory chart flow occurrences root measures "Event attribute (text)" and "Event attribute (number)" that caused error.


== QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22) ==
===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.


'''Features:'''
== Release: QPR ProcessAnalyzer 2024.8 (build 8937) (released 2024-12-11) ==
* B-07755: [[Business_Calendar|Business calendar]] for duration calculation is available for Snowflake models.
* B-07719: In Snowflake dashboards, [[Big_Data_Chart#Using_measure_variables|measures can be assigned to variables]] and use the variables in other measures to create combined measures.
* B-07746: Changed in-memory conformance checking to not show invalid flow violations where starting or ending event type is invalid.
* B-07743: [[PA_Configuration_database_table#General_Settings|Default datasource]] can be configured for datatables created by scripts, allowing to set Snowflake as default.
* B-07740: System memory indicator moved from the header to User settings Version information dialog.
* B-07776: New SQL expressions functions Unicode, Char and Regexp, as a basis for future rule-based process mining.
* B-07741: Backend support for aggregation operations Median, Percentile, Stdev, Stdevp, Var and Varp to Snowflake.
* B-07742: Backend support for aggregation operation to list unique items in Snowflake.
* B-07770: Optimized Snowflake SQL generation by combining consecutive WithColumn function calls into one select.


'''Fixed issues:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
Known issue: There may be old invalid models which don't work with QPR ProcessAnalyzer 2024.8. The following query can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] (with System administrator user) to list such models:
* D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
<pre>
* D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
Models.Where(!IsOcelModel && Configuration.TryGetValue("DataSource").TryGetValue("Events").TryGetValue("DataSourceType") == _EMPTY).(Project.Name + ": " + Name + " (" + Id + ")")
* D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
</pre>
* D-13405: Images take now always all available space in image component area.
Those models don't have a valid datasource defined and thus they are likely not is use. Easiest solution is to delete those models with following command:
* D-13417: KPI card without title was slightly misaligned vertically.
<pre>
* D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
ModelById(<id>).DeletePermanently()
* D-13350: Task log and Script log default filter end date is now empty by default.
</pre>
* D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
</div>
* D-13347: Improved performance for in-memory business calendar calculation.
* D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
* D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
* D-13451: Exported filter file is now named based on selected filter name.
* D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
* D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
* D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
* D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
* D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
* D-13456: Improved error messages for incorrectly configured on-screen settings.
* D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
* D-13421: Improved error messages when trying to use model having some column mappings missing.
* D-13485: Snowflake business calendar gave error when calendar contained Sunday.
* D-13218: Windows event viewer incorrectly contained log entries that are not errors.
* D-12634: Multiline text boxes width is set to non-changeable.
* D-13034: Confirmation dialog to delete items permanently has been updated.
* D-13288: In dialogs, the Create button didn't show the disabled state correctly.
* D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
* D-13483: In Workspace, the new items menu was too narrow for Spanish texts.


== Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
SQL Server database compatibility level needs to be at least 130 (corresponding to SQL Server 2016) for databases used by QPR ProcessAnalyzer. When using a supported version of SQL Server, the database compatibility level might still be unsupported, so please check to used compatibility level. It's recommended to set the highest available compatibility level. More information: https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.
</div>


'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* B-07690: System setting [[PA_Configuration_database_table#General_Settings|DatabaseId]] can be defined by administrator to get more simple table names in Snowflake.
[[External_Content|External content]] component doesn't allow to embed websites from other origins than the QPR ProcessAnalyzer server. This is due to a change in the Content security policy (CSP) HTTP header (more information: [[QPR_ProcessAnalyzer_Security_Hardening#Added_HTTP_Headers|Security hardening]]). The content security policy HTTP header can be modified in the [[Installing_QPR_ProcessAnalyzer_Server#Server_settings_file_(appsettings.json)|appsettings.json file]]. More information about the ''same-origin policy'': https://developer.mozilla.org/en-US/docs/Web/Security/Same-origin_policy.
* B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
</div>
* B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
* B-07663: In [[Chart_On-screen_Settings|on-screen settings]], when case/event attribute is selected, related attribute values list are reset.
* B-07570: Backend support for [[Business_Calendar|business calendars]] in Snowflake.
* B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
* B-07610: Memory counter related technical properties have been removed from expression language.


'''Fixed issues:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
QPR ProcessAnalyzer now uses the Microsoft.Data.SqlClient library for SQL server connection instead of the System.Data.SqlClient library, and there are slight differences with the connection string parameter default values. If using a self-signed certificate in the SQL Server with the encrypted connection, it might require to add '''TrustServerCertificate=True''' to the connection string, so that QPR ProcessAnalyzer will trust the self-signed certificate and allow the database connection.
* D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
</div>
* D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
* D-13358: Calculation results caching works also across different user sessions.
* D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
* D-13230: SAP import did not automatically create columns to use the correct column types.
* D-12857: Deeply recursive functions caused a crash without any trace.
* D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
* D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
* D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
* D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
* D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
* D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
* D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
* D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
* D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
* D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
* D-12991: Dropdown list texts had some translations missing.


== QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing <pre>"preset": "RootCauses"</pre> and the comma from the preceding line.
Project ''Designer'' and ''Administrator'' roles can now create models and datatables in the project. Earlier these operations required the global ''Create models'' role. This global role is now renamed to ''Create projects'', describing its new purpose.
</div>
</div>
===Features===
* B-08395: Added native [[Object-Centric_Flowchart|object-centric flowchart]] showing predefined measures.
* B-08396: Object attributes are now available as [[Object-centric_Process_Mining_Model#Object-centric_perspectives|case attributes in object-centric perspective]].
* B-08449: Snowflake Native App supports [[QPR_ProcessAnalyzer_Project_Workspace#Snowflake_Native_App|project-specific database, schema, and warehouse]].
* B-08432: Decision intelligence event log [[Create_Predicted_Eventlog|prediction]] and [[Create_Simulated_Eventlog|simulation]] has been integrated into QPR ProcessAnalyzer.
* B-03062: Project Designer and Administrator roles can now create models and datatables, and global "Create models" role changed to "Create projects".
* B-08471: Model properties dialog has been simplified for Native App to exclude in-memory model datasources.
* B-08504: Charts don't automatically change case/event attributes and event types when encountering non-existing selections.
* B-08522: Optimized Snowflake queries that do not need event data.
* B-08454: Optimized SQL executed in Snowflake by removing unnecessary column type casts.
* B-08507: Migrated tables for scripts and script logs to Entity Framework.
* B-08519: Migrated user management tables to Entity Framework.
* B-08539: Migrated model, project and filter tables to Entity Framework.
* B-08514: Updated translations for release 2024.8.
* B-08515: Frontend components have been updated.
* B-08513: Backend components have been updated.
===Fixed issues===
* D-14320: On-screen setting didn't work when "dynamicType" is "DataTablesOfProject".
* D-14221: Content-Security-Policy HTTP headers allows only same origin for iframes, and X-Frame-Options HTTP header removed.
* D-14317: Model statistics system report gave error about invalid expression.
* D-14286: Fixed issue in model import which sometimes created partially configured model.
* D-14315: Filtering for custom dimensions didn't work, if expression refers to measures with variables.
* D-14302: "let" statement did not work in #expr-block embedded into SQL expression.
* D-14303: Flowchart lost selection when flowchart used linked variables.
* D-14311: Fixed issue were dashboards were not visible in iPhone.
* D-14301: Filtering from "First event attribute value" and "Last event attribute value" columns did not work.
* D-14314: Fixed error in BPMN editor when object-centric model didn't have perspective defined.
* D-14297: Native App incorrectly cached OAuth token causing "OAuth access token expired" errors.
* D-14248: Improved error message "Unable to read event log data from external source without specified sample size".
* D-12402: Fixed issue where flowchart start/end flows didn't start from middle of start/end symbols.
* D-14293: AI Assistant didn't work with object-centric models.
* D-14295: Fixed issue where authentication was not possible if PA_ROLE table contained roles with ROL_FLAGS field having NULL values.
* D-14245: When dialog was opened in Workspace, console showed following error: "Blocked aria-hidden on a <button> element because the element that just received focus ...".
== QPR ProcessAnalyzer 2024.7 (build 8234) (released 2024-10-29) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.
If using local datatables (stored in SQL Server), the [[PA_Configuration_database_table#SqlServerConnectionString|SqlServerConnectionString]] setting is now mandatory. Starting from QPR ProcessAnalyzer 2024.7, local datatables cannot be created if the setting is not configured. It's recommended to have a separate database for the datatables data, but it's also possible to configure the same connection to the SqlServerConnectionString setting as for the configuration database (in [[Installing_QPR_ProcessAnalyzer_Server#Server_settings_file_(appsettings.json)|appsettings.json]]). See [[QPR_ProcessAnalyzer_System_Architecture|System Architecture]] for more information about the data storage.
</div>


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Check whether there are custom roles in the database (table PA_ROLE) which have the ROL_FLAGS field set to NULL. The NULL values don't work with this release, so set a correct value (either 1, 2, or 3). Following query can be run in the database showing roles which have an incorrect ROL_FLAGS field:
<pre>
<pre>
let removedAnalyses = [5, 6, 7];
SELECT *
OrderByDescending(Flatten(Projects.Scripts).Where({
FROM [PA_ROLE]
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;scr.code?.Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
WHERE [ROL_FLAGS] = NULL;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</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;">
Starting from QPR ProcessAnalyzer 2023.1, the '''.NET Desktop Runtime''' is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, ''.NET Desktop Runtime'' is not needed, but instead install the '''.NET Runtime''' (which is more lightweight). ''.NET Desktop Runtime'' contains the ''.NET Runtime'', so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.
Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.11. Old versions of the functions use Python 3.8 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications emails about existing deprecated functions. It's recommended to remove the old functions which are following:
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
* QPRPA_UDTF_CLUSTER
* QPRPA_UDTF_CLUSTER_V2
* QPRPA_UDTF_CLUSTER_V3
* QPRPA_UDF_BPMN_IS_CONFORMANT
* QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS
</div>
</div>
'''Features'''
* B-08458: Object-centric perspectives can be stored as filters and object-centric model can be selected for dashboard.
* B-08472: Snowflake filter cache tables are now created in background to improve performance.
* B-08452: Limited sampled cases to 10000 in Snowflake and in-memory clustering presets.
* B-08430: Improved [[Process_Flowchart|Snowflake flowchart]] performance by calculating variations using sampling.
* B-08446: QPR ProcessAnalyzer can be deployed as Snowflake application package to publish it as a [[QPR_ProcessAnalyzer_Native_App_in_Snowflake|native app]].
* B-08418: QPR ProcessAnalyzer has been integrated into Snowflake authentication for Snowpark Container Services.
* B-08420: Legacy "Local" datatables cannot be created anymore - only separate SQL Server database is supported (see release note above).
* B-08437: Snowflake cache is now bypassed for queries that have caching disabled.
* B-08443: Improved object-centric models performance by optimizing perspective generation.
* B-08450: Updated Snowflake UDF's python version from 3.8 to 3.11 (see release note above).
* B-08425: Migrated nine configuration data tables to use Entity Framework.
* B-08334: Removed legacy functionality related to models.
* B-08337: Removed legacy functionality related to roles.
* B-08456: Frontend components have been updated.
* B-08477: Backend components have been updated.
* B-08478: Updated translations for release 2024.7.
'''Fixed issues'''
* D-14263: Filtering with case id caused error when Snowflake model didn't have case attributes datatable.
* D-14256: Workspace showed progress spinner forever if trying to remove rows from table where there is no access.
* D-14250: "Show in Query Designer" button didn't show full query sent to server.
* D-14285: Non-breaking spaces didn't work in json fields.
* D-14278: Workspace models list showed linked cases/events datatable even though datatable didn't exist.
* D-14251: Aggregations list in Combined measure/dimension/column incorrectly showed aggregations for all data types.
* D-14257: Exporting datatable with no columns froze loading spinner.
* D-14188: Script incorrectly aborted after error occurring in the import phase of client-side import.
* D-14275: Several "Loop percentage" event measures caused flowchart error.
* D-14259: Removed malfunctioning undo/redo operations from Design diagram.
* D-14260: Design diagram toolbar incorrectly scrolled to left when diagram was zoomed.
* D-14262: Opening version information caused javascript error if backend communication failed.
* D-14271: None aggregation didn't work with some Statistical calculations.
* D-14283: BPMN editor toolbox has now correct font.
* D-14280: Dashboard component stacking order buttons didn't work if dashboard had z-indeces with gaps.
<span id="84516a70"></span>
== QPR ProcessAnalyzer 2024.6 (build 7414) (released 2024-09-18) ==


'''Features:'''
'''Features:'''
* B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
* B-08366: Frontend for [[Object-centric_Process_Mining_Model|OCPM model]] configuration and Snowflake charts using perspectives.
* B-07383: Improvements to linked settings to allow binding to variables, tags and filter rules [[Chart_Linked_Settings|(more information)]].
* B-08365: Added following visual settings for [[QPR_ProcessAnalyzer_KPI_Card|KPI Card]]: font size, text color, text styles, vertical and horizontal alignment.
* B-07508: Flowchart preset colors have been renewed to be more intuitive.
* B-08382: Measures, dimensions and columns can be duplicated in [[QPR_ProcessAnalyzer_Chart#Measure,_Dimension_and_Column_Settings|chart settings]].
* B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
* B-08381: [[QPR_ProcessAnalyzer_Table|Table]] vertical scrollbar is now hidden when table is not scrollable.
* B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|(more information)]].
* B-08355: Expression language identifiers are primarily assumed as variables and secondarily as property names.
* B-07440: Date when the release was made is now shown in User settings.
* B-08402: QPR ProcessAnalyzer can now connect to Snowflake when running in Snowpark Container Services.
* B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
* B-08389: Added support for making multiple Snowflake queries in same request for OCPM queries.
* B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
* B-08416: Improved backend functionality for partially configured OCEL models.
* B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
* B-08428: Improved Snowflake calculation performance by including to filter cache tables only the event table key (this behavior can be opt-in with a [[PA_Configuration_database_table#CacheOnlyPrimaryKeysForFilters|CacheOnlyPrimaryKeysForFilters setting]]).
* B-07637: Language selector now shows the language options in local languages.
* B-08448: Add configuration to disable event cache tables storing primary key only.
* B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
* B-08340: New users don't have a default model selected when login for the first time.
* B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
* B-08413: Frontend components have been updated.
* B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
* B-08397: Backend components have been updated.
* B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
* B-08398: Updated translations for release 2024.6.
* B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
* B-07716: ShortString columns are now properly detected in SQL Server queries.
* B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
* B-07688: AddColumns function for Datatables to create multiple columns in one call.


'''Fixed issues:'''
'''Fixed issues:'''
* D-13092: Table conditional formatting didn't work when color code was fetched from other column.
* D-14209: Fixed issue where moving projects in Workspace was not possible.
* D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
* D-14186: Highcharts visualizations datalabel texts were incorrectly shown over tooltips.
* D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
* D-14210: Fixes for issue with incorrectly shown pending tasks in System Reports.
* D-13104: In BPMN model editor, context menus to edit elements didn't appear.
* D-14242: SqlDataFrame Persist function now keeps the original column types even if they are changed.
* D-12939: Script editor tabs Close buttons didn't work.
* D-14147: Snowflake queries gave "Object reference not set to an instance of an object" error with MaximumRowCount higher than 2 billion.
* D-13154: "Search by case ID" didn't work in in-memory chart.
* D-14189: Dropdown list component gave following error when clicking Add button for "List items": Cannot read properties of undefined (reading 'axisLabel').
* D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
* D-14192: Datagrid paging settings are now preserved when resizing or zooming window.
* D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
* D-14214: In System reports, dropdown list showing dashboards didn't open if there were more than 1000 dashboards.
* D-12928: Pivot table headers were empty when there were two column levels and two values.
* D-14218: CSV file import didn't detect existing column correctly when there was difference only in letter case.
* D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
* D-14184: Giving ScriptText or ScriptFileName as parameter for QPR ScriptLauncher created a broken script.
* D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
* D-14220: AI assistant gave strange error message when trying to explain chart showing error.
* D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
* D-14135: Expression based Snowflake filter rule caused error "Object reference not set to an instance of an object".
* D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
* D-14229: In Snowflake, disabled filter rules didn't affect header object counts when there were several filter rules.
* D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
* D-14228: In Models and Model statistics reports, columns showing case and event attributes didn't work.
* D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
* D-14213: In User Settings dialog, Effective Permissions settings are now preserved while dialog is open.
* D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
* D-14227: Fixed issue where applying chart settings in System reports made settings pane empty.
* D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
* D-14185: Stack traces were incorrectly returned even if IncludeExceptionDetailsInErrors was false.
* D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
* D-14226: Fixed several OCPM calculation related issues in backend.
* D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
* D-13943: Added error message to Case attribute selector when model doesn't have selected case attribute.
* D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
* D-14162: Expression "0.()" gave null reference error.
* D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
* D-14246: Chart setting dialog may have been partly out of screen when activating other chart while in dashboard is scrolled.
* D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
* D-14238: Snowflake chart measure aggregation is incorrectly affected by statistical calculations.
* D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
* D-14133: In Snowflake chart, events Aggregate settings caused JaveScript error and UI messed up.
* D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
* D-14172: Fixed issue where validation error appeared when copying and moving elements in Design Diagram.
* D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
* D-14253: Table didn't show column filter icon when column name was empty.
* D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
* D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
* D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
* D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
* D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
* D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
* D-12937: Added maximum value limitation to several number input fields in charts.
* D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
* D-12948: Defining column setting caused error when Measure Expression was not defined.
* D-12946: Filter rule text couldn't be seen entirely from tooltip.
* D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
* D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
* D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
* D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
* D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
* D-13116: BPMN editor had some translations missing.
* D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
* D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
* D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
* D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
* D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
* D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
* D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
* D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
* D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
* D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.


== Additional release for QPR ProcessAnalyzer 2022.8 (build 1397) (released 2023-01-11) ==
== Additional release for QPR ProcessAnalyzer 2024.5 (build 6814) (released 2024-07-01) ==
<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 fixes an issue where extracting large datasets from SAP increases memory consumption considerably and may lead to out-of-memory error. This release contains packages for both QPR ScriptLauncher and QPR ProcessAnalyzer Server. If SAP extractions are done using QPR ScriptLauncher in client side mode (ExecuteInClientSide=1), it's enough to update QPR ScriptLauncher to fix this issue.
Known issue: It's not possible to move projects that existed before updating to this release. The issue will be fixed in the next release. There is a following workaround available: Administrator user can go to the [[Navigation_Menu#Expression_Designer|Expression Designer]] and run the following expression: '''Projects.Modify(#{})'''.
</div>
</div>


'''Fixed issues:'''
'''Fixed issues:'''
* D-12941: Extracting data from SAP consumed unnecessary lot of memory and may have led to out-of-memory error (both when running using QPR ScriptLauncher and in server side).
* D-14191: Running script by id failed on data import when parameters contained ScriptId.
* D-14183: Fixed issue where flowchart SVG export only exported the visible part of flowchart.


== QPR ProcessAnalyzer 2022.8 (build 1396) (released 2022-12-30) ==
== Additional release for QPR ProcessAnalyzer 2024.5 (build 6769) (released 2024-06-27)==
<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, and possible existing duplicate names are automatically changed to unique names with a random suffix. If there are duplicate names, they can be renamed either before updating QPR ProcessAnalyzer (to avoid automatic renaming) or after the update (by changing suffixed names). If the renamed datatables are used by models, the linkage will break because it's based on the datatable name. Creating duplicate datatables has already been prevented in the UI, but the improved method works also in the API level.


Following SQL query can be used to list datatables (and project id) having duplicate names:
'''Features:'''
SELECT ITA_NAME, ITA_PROJECT_ID
FROM PA_INTEGRATION_TABLE
GROUP BY ITA_NAME, ITA_PROJECT_ID
HAVING Count(*) > 1
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
*B-08388: Added backend support for OCPM model perspectives to convert object-centric eventlogs into case-centric.
If trying to use business calendar for a model that doesn't have the business calendar defined, there will now be an error message instead of showing the chart. Either unselect the business calendar checkbox for the measure or dimension, or define a business calendar to the model. In this situation in earlier releases the business calendar was ignored and full time calculation used.
</div>
 
'''Features:'''
* B-07498: Automation and Operational Excellence presets and Root causes analysis (for Snowflake), Weighted root causes analysis and Event scattering preset (for Snowflake and in-memory), Root causes for case duration (in-memory).
* B-07177: Flexible mappings, user selectable aggregations and conditional formatting for Pivot table, and flexible mappings for KPI Card.
* B-07518: New function named Query to run call /api/expression/query.
* B-07294: In Workspace, the left side projects hierarchy can be collapsed and expanded to make more space to project contents.
* B-06814: In SQL expressions, new function DurationBetweenDates to calculate duration between timestamps precisely.
* B-07519: Replaced DateDiff function with the new DurationBetweenDates function in big data chart.
* B-07531: In SQL expressions, new mathematical functions Abs, Log, Mod, Power, Rand, Sign and Sqrt.
* B-07297: To optimize performance, Snowflake queries are automatically cancelled if they are not needed by UI.
* B-07569: To optimize performance, TakeSample function implementation is improved for Snowflake.
* B-07198: Several performance improvements to DataFrame queries (used in Snowflake).
* B-07464: Added Lead and Lag functions to SqlDataFrames to support getting previous and next event.
* B-07470: New ExtractSap function to fetch data from SAP using expression language.
* B-07536: New Pivot function to SqlDataFrames to enable root causes analysis.
* B-07488: Primary keys can be set to datatables to improve calculation performance (UI will follow later).
* B-07515: Added RootCauseAnalysis function to SqlDataFrames.
* B-07546: RootCauseAnalysis function support for complex weighting expressions.
* 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.
* B-07480: Expression language support for DataFlows for data extraction.
* B-07613: Removed support for SQL Server based R scripting.
* B-07567: Take datatable primary keys into use in expression builder to improve performance (part 2).
* B-07588: Remove total memory information from log writing and DateDiff function for in-memory.


'''Fixed issues:'''
'''Fixed issues:'''
* D-12715: Snowflake calculated imprecisely some operations containing division and aggregation.
* D-12761: Progress bar of the CSV import dialog didn't show any progress.
* D-12799: Opening datatable contents dialog settings was slow when there were lot of rows in the datatable.
* D-12089: Include conforming/nonconforming cases made BPMN editor no responding.
* D-12496: Datagrid filter search keyword didn't work for rounded values, so the search was hidden for other than textual data.
* D-12704: Durations as quarters was calculated incorrectly in charts.
* D-12662: Fixed issue where some special literals in custom expressions didn't work.
* D-12403: Setting Notifications on a model had some visual issues.
* D-12859: Dependency wheel visualization crashed with nulls values in From and To mappings.
* D-12660: Removed unnecessary float conversions in SQL expressions.
* D-12653: In-memory datafram OrderByColumns function with mixed values failed.
* D-12657: When trying to use milliseconds period in some presets, frontend frozed.
* D-12706: Line breaks in data were shown in many places where it's undesired.
* D-12719: Syncfusion dialog headers 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-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-12722: There was incorrect syntax near '<' when running SqlDataFrame expressions.
* D-12736: Swedish and Finnish translation improvements for object counter tooltips.
* D-12702: For BPMN Editor component "Something went wrong" error was given when switching from in-memory to Snowflake model.
* D-12712: UI gave error: TypeError: Cannot read properties of undefined (reading 'id').
* D-12738: Business calendar showed total business time when calendar configuration was invalid.
* D-12776: Special character filter caused JavaScript SyntaxError.
* D-12785: Unnecessary vertical scrollbar displayed for main header toolbar.
* D-12164: There was unnecessary UnauthorizedAccess errors in logs.
* D-12580: Case duration was not same when comparing Big data chart with in-memory chart for same data.
* D-12768: Data grid links and variable change actions didn't work when grouping was used.
* D-12735: FindRootCauses (in-memory) function filtered out cases with zero contribution.
* D-12763: --#CallWebService didn't work from ScriptLauncher.
* D-12789: There was timeout in SQL queries to scripting sandbox.
== 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;">
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.


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.
*D-14187: Creating local datatables was not possible in Workspace if datatables were stored to the configuration database (i.e., SqlServerConnectionString setting is not used).


Following SQL query can be executed in the QPR ProcessAnalyzer metadata database to reveal dashboards that potentially have prevented expressions:
==QPR ProcessAnalyzer 2024.5 (build 6746) (released 2024-06-25)==
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>


'''Features:'''
'''Features:'''
* B-07287: Process Discovery and most important presets for Snowflake.
*B-08338: Added reports to monitor dashboards usage: Popular dashboards, Dashboards by users and by time, and specific dashboard usage.
* B-07271: "Last Row Aggregates Over-limit Rows" setting for big data chart.
*B-08314: Snowflake connection string can be [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Connection|specified for each project]] to allow projects connecting to different Snowflake accounts, databases or schemas.
* B-06431: Snowflake datatables support for database views in the datasource.
*B-08341: Added [[SQL_Expressions#GetRelatedValueFrom_function|GetRelatedValueFrom]] and [[SQL_Expressions#AggregateRelatedValueFrom_function|AggregateRelatedValueFrom]] SQL expression functions to extend models with data from additional tables.
* B-07266: Security: "limited mode" to prevent data modifications and external calls from dashboard expressions.
*B-08301: In chart settings, selecting another measure/dimension/column now doesn't reset settings.
* B-07097: Improved flowchart root causes color scales.
*B-08317: Added Snowflake presets for Root Causes for Attributes in table and detailed table format.
* B-07363: SQL LIKE function support for escape character.
*B-08318: Improved Snowflake Events preset performance by adding a filter that picks a subset of cases.
* B-06877: Improved variation queries performance in Snowflake, part 1.
*B-08385: Open AI default large language model has been changed to "gpt-4o".
* B-07444: Improved variation queries performance in Snowflake, part 2.
*B-08342: Added DashboardName and DashboardProjectName properties to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* B-07382: Support for empty strings and nulls in event type names in dataframe processing.
*B-08320: Added RenameAllColumns function to dataframes to easily rename all columns.
* B-07273: WithRowNumberColumn, WithRankColumn, WithDenseRankColumn support for descending sorting.
* B-08321: Added DataSourceConnection property to dataframes in expression language.
* B-07303: FindRootCauses function support for weighting expression.
*B-08307: Finetuned Workspace functionality for models that don't have datasource defined.
* B-07327: Unpivot function for SqlDataFrames (for root cause analysis).
*B-08329: Optimized metadata queries to Snowflake to improve performance.
* B-07385: Align token lifetime with SESSION_MAXIMUM_DURATION setting.
*B-08311: Changed QPR ScriptLauncher interaction with the server by changing long polling to short calls to improve robustness.
* B-07500: ColumnMappings property for IDataFrame and DataTables.
*B-08368: Implemented backend support for configuring and importing OCPM models.
* B-07499: IDataFrame.ApplyFilter function to filter events data using a JSON-based filter.
*B-08352: Frontend components have been updated.
* B-07469: Translation updates for release 2022.7.
* B-08348: Backend components have been updated.
*B-08349: Updated translations for release 2024.5.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11630: Drag and drop from chart settings to main header was working incorrectly for filter and root cause rules.
*D-14150: Charts temporarily showed as too large when resized with non-zero chart margin values.
* D-12455: Moving a chart filter from one chart to another created a root cause analysis filter.
*D-14058: Login page is not anymore shown when SAML authentication is configured and user is directed to the identity provider.
* D-12266: Root causes analysis showed incorrect results when certain combination of filters.
*D-11579: Column filter menu in tables can now appear outside the table area which is useful in small tables.
* D-12525: Numerical values in Excel export in data grid was formatted incorrectly.
*D-14144: Fixed issue where Snowflake clustering failed if there were date type of case attribute with null values.
* D-12534: Restoring item from recycle bin changed project from Bin to previous project.
*D-14163: Non-breaking spaces appeared strangely as "&amp;nbsp;" in Highcharts charts.
* D-12529: Measure specific datalabel mapping did not work correctly when also mapped to Y-axis.
*D-14132: Snowflake model object counts were not shown when opening dashboard while model metadata was still loading.
* D-12532: Multi-selection options caused layout issue for Chart setting.
*D-14142: CreateDataTable function incorrectly deleted all source datatable content if connection included source datatable name.
* D-12541: Layout issue for Polish in multiselect list search dialog.
*D-14161: Fixed issue where Append function in SqlDataFrame broke source data.
* D-11277: Increase/decrease Icons were missing in the dimension sorting for Mac.
*D-14157: AI Assistant didn't show detailed error message when OpenAI query failed.
* D-12552: Uncaught Error: Diagram.selectCollection given something that is not a Part: null.
*D-14137: AI Assistant incorrectly appeared on top of chart in the fullscreen mode.
* D-12567: Tooltip incorrectly showed for label component containing only spaces.
*D-14170: Toolbar dropdown lists didn't work when dashboard contained more than one Design Diagram.
* D-12438: Operation was cancelled because it was replaced by a new operation.
*D-14146: Fixed error "Unable to get on-premise gateway named..." when running script from SQL script using QPR ScriptLauncher.
* D-12551: Some expressions didn't work as calculated case/event attributes.
*D-14106: Having only a template string in the #expr{...} block didn't work.
* D-11720: Chart buttons were not visible in Apple Safari and iPad.
*D-14008: "Root Causes contribution" and "Comparison eventlog cases percentage" columns didn't work (in-memory).
* D-12544: On-screen settings "options" parameter did not work.
*D-14010: Occurrences of specific flow measure didn't work with the Root causes analysis weighting expression (in-memory).
* D-12528: Multi-unit time unit selection appeared where it's not applicable.
*D-14148: Root causes for case duration preset didn't support Multi-unit time settings.
* D-12583: Error message should be provided for invalid settings input  than just  display JS errors.
*D-14139: Added info message when successfully exporting model to pacm file.
* D-12599: Tooltips didn't show correct measures/dimensions when "Show in tooltip" mappings are used.
*D-14153: Fixed in-memory measures for "Flow duration" and "Occurrences of specific flow" which failed when selected flow didn't exist.
* D-12561: Chart settings content was incorrectly drawn outside of the chart dialog.
*D-14167: Fixed issue where ScriptLauncher sometimes terminated prematurely on exceptions occurring in on-premise import.
* D-12568: Reload UI sometimes crashed chart having multiselect on-screen settings.
*D-14165: Flowchart export file name was incorrect and exported flowchart background was always transparent.
* D-12572: Main header toolbar lost when refresh maximized PA chart.
*D-14160: Fixed issue where DashboardId wasn't recorded to operation log when opening dashboard by identifier (DashboardsController.GetByIdentifierPath).
* D-12612: Drop Unused Filters After setting incorrectly allowed zero seconds.
*D-14159: IsHidden property didn't work in in-memory Value expressions.
* D-12533: Error message keeped blinking in Analysis view.
* D-14131: Some popup messages had incorrect html escaping.
* D-12608: User could not select or add new case attribute when current select attribute doesn't exist.
*D-14151: Fixed issue where flowchart might have given browser console error when clicking event types or flows while still loading data.
* D-12451: Prevented deleting running script.
* D-14022: In System reports, numeric aggregations which don't work in SQL Server are now hidden.
* D-12516: Windows event viewer warning: Failed to gracefully shutdown application.
*D-14129: Imported model name was incorrectly cut if it contained dots.
* 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) ==
==QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14)==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Features:'''
This release contains fixes to following major issues:
*B-08227: Dashboards have [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] (powered by ChatGPT) helping users in process analysis. AI Assistant can answer general questions about the process, create filters based on user prompt, and explain charts and analyses.
* 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.
*B-08277: QPR ProcessAnalyzer now detects automatically when cases or events data in Snowflake updates. Check is done every 5 minutes which is the maximum delay of detecting new data. ([[Snowflake_Connection_Configuration#Automatic_data_update_detection|more information]])
* 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.
*B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
* 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).
*B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
</div>
*B-08276: Adjusted permissions for [[Roles_and_Permissions#Project_Permissions|moving projects]].
*B-08310: Added Details property to [[Generic_Objects_in_Expression_Language#Exception|Exception object]] in expression language.
*B-08328: Language translations have been updated to 2024.4.
*B-08312: Frontend components have been updated.
*B-08308: Backend components have been updated.


'''Fixed issues:'''
'''Fixed issues:'''
* D-12586: Scripts using client-side import with older version of QPR ScriptLauncher didn't work.
*D-14084: Filter rule for first and last event in case couldn't be edited if there were more than one event selected.
* D-12597: QPR ScriptLauncher was not sending heartbeats during import, which might have stopped the script prematurely.
*D-14091: Duration multi-unit didn't work in big data chart.
* D-12589: Pressing Add measure/Add dimension button crashed chart.
*D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
* D-12558: In chart settings, setting expression to "(none)" gave error.
*D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
*D-14107: Snowflake model that has earlier been an in-memory model showed case count and estimated memory incorrectly.
*D-14074: Fixed issue in QPR ScriptLauncher when calling the script from other script.
*D-14104: Fixed expression language parsing issue with in-memory DataFrame and filter using "In" function.
* D-14121: Datatable UpdateRows function now supports column names given as expressions.
* D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
* D-14123: There was an error of unable to get on-premise gateway when using ExtractSap function in expression language script from SQL script called from expression language script.
*D-14128: Table without title was incorrectly exported as .txt file.
*D-14112: Convert to custom expression button didn't work in design diagram.
*D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
*D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed in chart settings.
*D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
*D-14096: Highcharts tooltip square icons were slightly misaligned.
* D-14099: There was a console warning when opening the business calendar dialog.
*D-14118: Design diagram sometimes gave following JavaScript error: Cannot read properties of undefined (reading 'parentNode').
*D-14024: If quickly logging out after changing model, the model change might not be been saved.
*D-14120: User.getAttribute function returned values from incorrect context.
*D-14102: Pivot table cannot read properties of undefined.
*D-14161: SqlDataFrame.Append breaks the used source SqlDataFrames
 
==QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)==


== QPR ProcessAnalyzer 2022.6 (build 1259) (released 2022-10-05) ==
'''Features:'''
* B-08024: [[Design_Diagram|Design diagram]] has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
*B-08242: Script based [[Actions_to_Run_Script_in_Table|actions]] can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
*B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
*B-08288: Added expression language functions to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Start|start and stop]] scripts.
*B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
*B-07906: Implemented cross joins to SQL dataframes.
*B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
*B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
*B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
*B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
*B-03047: Removed support for dashboard panels.
* B-08214: Removed unused columns from the PA_VIEW table.
*B-08254: Frontend components have been updated.
*B-08255: Backend components have been updated.
* B-08233: Language translations have been updated to 2024.3.


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Fixed issues:'''
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.
*D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
</div>
*D-14035: In design diagram, BPMN event and gateway symbols are now circular.
*D-14049: Added some missing translations for table column filter and BPMN editor.
*D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
*D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
*D-13976: Fixed issue where gateway-based imports were not synchronous.
*D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
*D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
*D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
*D-14071: Business calendar button press caused error when user didn't have access to any model.
*D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
*D-11268: There were inconsistent button colors in Workspace.
*D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
*D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
*D-14081: Fixed null references error when logging null in expression script.


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
==Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)==
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.


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:
'''Features:'''
<pre>
let removedAnalyses = Flatten([0,8,9,10,13].(["'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>
*B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.


'''Features:'''
'''Fixed issues:'''  
* 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:'''
*D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.
* D-12098: Attribute function worked incorrectly inside Switch statement.
* D-12491: Case filter was not shown in header if case id column is integer.
* D-12535: Variables disappeared when going to other dashboard.
* D-12480: ScriptLauncher client side import stucked without error.
* D-12501: Snowflake model gave error: ERROR [42P13] Invalid argument types for function 'SUM': (BOOLEAN).
* D-12112: Added validation for allowed values of standard context variables.
* D-12470: Truncating datatable made it unreadable.
* D-12383: Chart settings export options didn't change when visualization is changed.
* 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) ==
==QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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.
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following legacy analyses have been removed: 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.
The legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Models.Filters]] and [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property.
 
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:
<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>


<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;">
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).
New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).
</div>
</div>


'''Features:'''
'''Features:'''  
* B-06898: In Snowflake models, events can be filtered based on event attribute values.
*B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
* B-06996: In Snowflake models, event type mapping can be defined for each chart.
*B-08232: Entire future eventlogs can be [[Create_Predicted_Eventlog|predicted]] based on generative AI models running in Snowflake.
* B-07069: Datatables can be stored to separate SQL Server database to reduce load from metadata database.
*B-08166: Added expression language function [[Generic_Functions_in_QPR_ProcessAnalyzer#OpenAIChatCompletion|OpenAIChatCompletion]] to answer natural language prompts based on OpenAI ChatGPT API.
* B-06525: In dashboard editor, the background alignment grid is now better visible with any background color.
*B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
* B-06844: In script editor, the script status is automatic refreshed.
*B-08196: Conditional formatting rules can be defined for [[QPR_ProcessAnalyzer_Table#Textual_equal_rules_for_background_color|textual and boolean values]].
* B-06643: Links in header changed, e.g., the eLearning library link.
*B-08213: Big data chart expressions event type selections to be multi-select where applicable.
* B-06981: Chart settings remember the last opened tab, and the settings are always for the active chart.
*B-08205: Expression language API is available for storing [[Storing_Secrets_for_Scripts|secrets]] for scripts.
* B-06467: Added SelectDistinct function for dataframes for selecting distinct rows.
*B-07780: Chart [[QPR_ProcessAnalyzer_Chart#Variable_mappings|variable mappings]] has been removed - use the [[Chart_Linked_Settings|linked settings]] instead. Dashboards using variable mappings are automatically converted to use linked settings.
* B-06933: Added "Like" function to SQL expressions for string pattern matching.
*B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
* B-06543: Generic Eval function for evaluating an expression given in a string.
*B-08174: Only non-default parameters values are written to the operation log.
* B-06944: Truncate function to efficiently delete all rows from datatable.
*B-08200: Timestamps in System reports are shown in user workstation local time.
* B-07207: Access to properties CreatedBy, LastModifiedBy and LastImportBy for datatables using expression language.
*B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
* B-06906: Added Configuration property to Model and Datatable objects to get configuration json as dictionary.
*B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
* B-07170: Added ScriptByName and ModelByName functions for project objects and changed behavior for DatatableByName function.
*B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
* B-06919: Expression language: Increment (++) and decrement (--) operators.
*B-08202: Updated copyright for year 2024.
* B-06829: UI remembers the user's last selected model in next login.
*B-08199: Frontend components have been updated.
* B-07000: Workspace Models and Scripts tab auto-refresh has been optimized for performance.
* B-08203: Backend components have been updated.
* B-06456: Changed icons in chart Visualization selection.
*B-08209: Translations updated for release 2024.2.
* 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:'''
'''Fixed issues:'''
* D-12075: DashboardFilter variable rules were applied in incorrect order.
*D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
* D-12351: Pivot table columns headers had unnecessary prefix when there are multiple measures and no dimensions in columns.
*D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
* D-11946: Content security policy violation occurred when exporting Highcharts charts as images.
*D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
* D-12064: Chart pending query was incorrectly cancelled when going to and from Add component mode.
*D-13962: System variable values were interpreted incorrectly when used in linked settings.
* D-11606: Scripts and Projects tab slightly covered the top borderline of workspace datagrid and entire grid was not visible.
*D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
* 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-13959: Removed possibility to add datatable columns with the legacy "any" data type.
* D-12324: The visibility stepper counter didn't follow changed variations.
*D-13991: Improved drop-down selector component to handle empty strings as variable values.
* D-12373: CSV import may have failed when there are line breaks in strings.
*D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
* D-12045: Column filter was not cleared when user switched to other view in Recycle bin.
*D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
* D-11590: Two context menus were visible at the same time.
*D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
* D-11131: It was not possible to move data grid column Custom filter dialog.
*D-13960: Added missing translations for list of permission list and 12-hour clock format.
* D-11401: For datatables filter popup menu was opened outside visible dialog and required more scrolling to be seen.
* D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
* D-11650: In Workspace, sub context menu for target projects to move items didn't open with latest Syncfusion.
*D-13969: Datatable column schema export sometimes showed empty for the key column.
* D-11651: Multiselect list lost some items when using search.
*D-13862: Session token was not accepted when url path capitalization is different.
* D-11657: Combobox autofill was broken.
*D-13942: Datatable could not be dimensioned if it has column named "CaseId".
* D-11639: User's default model did not behave as it should.
*D-13980: Business calendar dialog crashed when tried to open it for a model without access.
* D-12085: Filter rules in header were lost when pressing F5.
*D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
* D-12142: KPI card value is now visible for non-numeric values.
*D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
* D-12105: Nullable object must have value error displayed  when trying to open Enhanced BPMN dashboard.
* D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
* D-12157: Root causes analysis in the Conformance Root Causes Analysis didn't work.
* D-13977: Multi-select dropdown lists showed some special characters incorrectly.
* D-12067: Some tooltips, e.g., in BPMN button, didn't disappear at all.
*D-13945: Syncfusion toast message didn't work when text contains ${[]}.
* D-12069: User got querying variation error when first time created big data flowchart.
* D-13930: Pivot table throws javascript error when certain clicks.
* D-12177: In models list, search and cancel icons were vertically misaligned.
* D-13273: Duplicate datatable row count didn't shown correctly.
* D-12116: Add and delete filter rule from Create Filter dialogue did not work.
*D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
* D-11445: When using very large value for border corner roundness, chart settings were not visible.
*D-13985: Models list dots menu had texts misaligned in narrow screens.
* D-12166: External content presentation object was broken due to too strict content security policy.
*D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
* D-12151: KPI card incorrectly showed error "Measure data type needs to be numeric" when numerical measure has null value.
*D-13997: Workspace tables column filtering search caused JavaScript errors.
* 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-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
* D-12325: Workspace root level had too many New items in context menu.
*D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
* D-12326: Wrong menu displayed for sub projects if first click create new option for root level from project tree view.
*D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
* D-12000: Script log system report default time interval was too long making report very slow.
*D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
* D-12119: Uncaught (in promise) TypeError occured: Cannot set properties of undefined (setting 'isAnimate').
*D-14004: Removed empty filters from queries to optimize them.
* D-12293: "Cannot read properties of undefined (reading 'id') at o.checkTabNames" error occured.
*D-13988: Fixed issue where data grid context menu rendered initially as too high.
* D-12294: Term ID was incorrectly translated.
*D-13979: BPMN model editor element settings use now Open Sans font.
* D-12353: Dialogs broke when there are quotation marks in header.
*D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
* D-11978: Soft deleted project could incorrectly be queried by admins.
*D-13984: Fixed the error of refusing to run the JavaScript URL.
* D-11982: Null reference error when filter contained attribute value with null.
*D-14031: ThrownObject property was not included to http error response when error came from the script.
* D-11706: Deadlocks during tests in Concurrency test category.
 
* D-11893: User.Globalpermissions returned incorrectly Hashset for inactive users (should return array).
==QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10)==
* 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.
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* D-12138: Timespan function incorrectly assumed 32-bit integers.
QPR ProcessAnalyzer Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime ([[Updating_QPR_ProcessAnalyzer_Server|see more]]). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.
* D-11548: Removed setting of default model and view.
</div>
* 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.  
In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.
</div>
</div>


'''Features:'''
'''Features:'''
* B-06864: New dashboard component: Big data flowchart that calculates in Snowflake.
*B-08019: New component [[Design Diagram]] for showing user-created diagrams in dashboards where to visualize process mining metrics.
* B-06434: Flowchart has been improved by adding e.g., presets, tabs and title (both in in-memory and big data flowchart).
*B-08087: Generic [[Dropdown_List_Selector|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* B-06515: New setting for chart to prevent applying chart filter to other charts ([[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters to dashboard]]).
* B-08163: Linked settings support for binding to [[Chart_Linked_Settings#Binding_to_case_attribute_filters_with_attribute_name_and_attribute_values|case attribute filter values without defining case attribute name]].
* B-06450: Log in screen visual layout has been renewed.
*B-08170: Snowflake model filters can be [[Filtering_in_QPR_ProcessAnalyzer#Filter_actions|saved as new models]] which can be used to create snapshots of part of models.
* B-06876: User management system reports including used license for each user.
*B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
* B-05981: Expression language function CallWebService for web api and http calls.
*B-08161: Added [[Datatable_in_Expression_Language#Modify|Modify]] function to change datatable properties and improved [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CreateDatatable|CreateDatatable]] function for creating datatables.
* B-06789: Datetime truncation function support for half-year and millisecond time units.
*B-08122: Added new system report to list dashboards.
* B-06497: SqlExpression function for getting string length.
*B-08173: Removed legacy filters that didn't have any filter rules.
* B-06581: SqlExpression function for trimming white spaces from strings (Trim).
*B-07961: In OperationLog, changed parameters to json format and added request id.
* B-06630: SqlExpression function to add duration to date (DateAdd).
*B-08069: Added DashboardId property to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* B-06631: SqlExpression function for getting a substring of a string (Substring).
*B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* B-06860: SqlDataFrame function to remove columns (RemoveColumns).
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|DeleteRows]] function to delete rows in datatables with similar logic than SQL delete.
* B-06832: When error occurs in script run in client side, error message is shown in script log.
*B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
* B-06818: Russian language has been removed from UI.
*B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
* B-06445: Datatable row counts are cached to avoid querying the information from Snowflake.
*B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
* B-06843: Backend support for filter rule to filter events by event attribute values.
* B-07689: For datatables, [[Datatable_in_Expression_Language#ForeignKeys|foreign keys]] to other datatables can be defined using expression language.
* B-06871: Translation updates for 2022.4 release.
*B-08176: Translation updates for release 2024.1.
*B-08175: Workspace should show timestamps in user's local time.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11802: When closing fullscreen, sometimes main header stayed invisible.
* D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* D-11947: Dynamic dropdown lists didn't open in first click in certain situations in Firefox.
*D-13916: Chart filter could not be defined for some expressions in Big data chart.
* D-11783: Flowchart start/end flow measure label showed in incorrect place when there are only one starting/ending flow.
*D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
* D-11796: Data export in pivot table didn't work.
*D-13906: In Conformance Analysis, deviating flows were not translated.
* D-11530: When model is moved to other project, linked datatables are now not moved.
*D-13907: Improved translation related to datatable properties dialog "Used by models" field.
* D-11714: Scripts list hover buttons didn't work in Firefox.
*D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
* D-11500: Duplicated name check for workspace items was missing.
* D-13911: Fixed small glitches in the opening and closing of drop-down lists.
* D-11782: Some in-memory chart expressions gave parse exception: token recognition error at: '\n'.
*D-13918: Datatable could be configured incorrectly to use table for other datatable.
* D-11871: Importing large number of rows to Snowflake could be very slow, as it incorrectly used SQL insert.
*D-13932: Duplicating datatable with custom table in datasource losed all data.
* D-11781: Persisting more complicated SqlDataFrames did not work.
* D-11002: Removed legacy in-memory prediction preset.
* D-11849: Script log was not generated when running tasks in parallel using AsParallel function.
*D-13912: Added check that array cannot be stored to dashboard Content property.
* D-11789: Changing expression to "none" crashed UI, and line breaks were incorrectly removed in multiline text fields.
*D-13936: Query designer default query didn't work with Snowflake models.
* D-11817: Error missing when trying to run --#CallWebService with ExecuteInClientSide=1 in web UI.
*D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
* D-11716: Deleted models were incorrectly listed in main header.
*D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
* D-11912: User management dialog showed global roles incorrectly after they have been changed.
*D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
* D-11940: Datatable rows column didn't show all when there is over 1 billion rows.
*D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.
* 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.


== 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 15:56, 6 February 2025

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

Next Release: QPR ProcessAnalyzer 2025.2 (planned release 2025-03-04)

See plan for next release features and fixes

Latest Release: 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.

Release: QPR ProcessAnalyzer 2024.8 (build 8937) (released 2024-12-11)

Known issue: There may be old invalid models which don't work with QPR ProcessAnalyzer 2024.8. The following query can be run in the Expression Designer (with System administrator user) to list such models: 

Models.Where(!IsOcelModel && Configuration.TryGetValue("DataSource").TryGetValue("Events").TryGetValue("DataSourceType") == _EMPTY).(Project.Name + ": " + Name + " (" + Id + ")")

Those models don't have a valid datasource defined and thus they are likely not is use. Easiest solution is to delete those models with following command: 

ModelById(<id>).DeletePermanently()

SQL Server database compatibility level needs to be at least 130 (corresponding to SQL Server 2016) for databases used by QPR ProcessAnalyzer. When using a supported version of SQL Server, the database compatibility level might still be unsupported, so please check to used compatibility level. It's recommended to set the highest available compatibility level. More information: https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.

External content component doesn't allow to embed websites from other origins than the QPR ProcessAnalyzer server. This is due to a change in the Content security policy (CSP) HTTP header (more information: Security hardening). The content security policy HTTP header can be modified in the appsettings.json file. More information about the same-origin policy: https://developer.mozilla.org/en-US/docs/Web/Security/Same-origin_policy.

QPR ProcessAnalyzer now uses the Microsoft.Data.SqlClient library for SQL server connection instead of the System.Data.SqlClient library, and there are slight differences with the connection string parameter default values. If using a self-signed certificate in the SQL Server with the encrypted connection, it might require to add TrustServerCertificate=True to the connection string, so that QPR ProcessAnalyzer will trust the self-signed certificate and allow the database connection.

Project Designer and Administrator roles can now create models and datatables in the project. Earlier these operations required the global Create models role. This global role is now renamed to Create projects, describing its new purpose.

Features

  • B-08395: Added native object-centric flowchart showing predefined measures.
  • B-08396: Object attributes are now available as case attributes in object-centric perspective.
  • B-08449: Snowflake Native App supports project-specific database, schema, and warehouse.
  • B-08432: Decision intelligence event log prediction and simulation has been integrated into QPR ProcessAnalyzer.
  • B-03062: Project Designer and Administrator roles can now create models and datatables, and global "Create models" role changed to "Create projects".
  • B-08471: Model properties dialog has been simplified for Native App to exclude in-memory model datasources.
  • B-08504: Charts don't automatically change case/event attributes and event types when encountering non-existing selections.
  • B-08522: Optimized Snowflake queries that do not need event data.
  • B-08454: Optimized SQL executed in Snowflake by removing unnecessary column type casts.
  • B-08507: Migrated tables for scripts and script logs to Entity Framework.
  • B-08519: Migrated user management tables to Entity Framework.
  • B-08539: Migrated model, project and filter tables to Entity Framework.
  • B-08514: Updated translations for release 2024.8.
  • B-08515: Frontend components have been updated.
  • B-08513: Backend components have been updated.

Fixed issues

  • D-14320: On-screen setting didn't work when "dynamicType" is "DataTablesOfProject".
  • D-14221: Content-Security-Policy HTTP headers allows only same origin for iframes, and X-Frame-Options HTTP header removed.
  • D-14317: Model statistics system report gave error about invalid expression.
  • D-14286: Fixed issue in model import which sometimes created partially configured model.
  • D-14315: Filtering for custom dimensions didn't work, if expression refers to measures with variables.
  • D-14302: "let" statement did not work in #expr-block embedded into SQL expression.
  • D-14303: Flowchart lost selection when flowchart used linked variables.
  • D-14311: Fixed issue were dashboards were not visible in iPhone.
  • D-14301: Filtering from "First event attribute value" and "Last event attribute value" columns did not work.
  • D-14314: Fixed error in BPMN editor when object-centric model didn't have perspective defined.
  • D-14297: Native App incorrectly cached OAuth token causing "OAuth access token expired" errors.
  • D-14248: Improved error message "Unable to read event log data from external source without specified sample size".
  • D-12402: Fixed issue where flowchart start/end flows didn't start from middle of start/end symbols.
  • D-14293: AI Assistant didn't work with object-centric models.
  • D-14295: Fixed issue where authentication was not possible if PA_ROLE table contained roles with ROL_FLAGS field having NULL values.
  • D-14245: When dialog was opened in Workspace, console showed following error: "Blocked aria-hidden on a <button> element because the element that just received focus ...".

QPR ProcessAnalyzer 2024.7 (build 8234) (released 2024-10-29)

If using local datatables (stored in SQL Server), the SqlServerConnectionString setting is now mandatory. Starting from QPR ProcessAnalyzer 2024.7, local datatables cannot be created if the setting is not configured. It's recommended to have a separate database for the datatables data, but it's also possible to configure the same connection to the SqlServerConnectionString setting as for the configuration database (in appsettings.json). See System Architecture for more information about the data storage.

Check whether there are custom roles in the database (table PA_ROLE) which have the ROL_FLAGS field set to NULL. The NULL values don't work with this release, so set a correct value (either 1, 2, or 3). Following query can be run in the database showing roles which have an incorrect ROL_FLAGS field: 

SELECT *
FROM [PA_ROLE]
WHERE [ROL_FLAGS] = NULL;

Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.11. Old versions of the functions use Python 3.8 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications emails about existing deprecated functions. It's recommended to remove the old functions which are following:

  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
  • QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
  • QPRPA_UDTF_CLUSTER
  • QPRPA_UDTF_CLUSTER_V2
  • QPRPA_UDTF_CLUSTER_V3
  • QPRPA_UDF_BPMN_IS_CONFORMANT
  • QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS

Features

  • B-08458: Object-centric perspectives can be stored as filters and object-centric model can be selected for dashboard.
  • B-08472: Snowflake filter cache tables are now created in background to improve performance.
  • B-08452: Limited sampled cases to 10000 in Snowflake and in-memory clustering presets.
  • B-08430: Improved Snowflake flowchart performance by calculating variations using sampling.
  • B-08446: QPR ProcessAnalyzer can be deployed as Snowflake application package to publish it as a native app.
  • B-08418: QPR ProcessAnalyzer has been integrated into Snowflake authentication for Snowpark Container Services.
  • B-08420: Legacy "Local" datatables cannot be created anymore - only separate SQL Server database is supported (see release note above).
  • B-08437: Snowflake cache is now bypassed for queries that have caching disabled.
  • B-08443: Improved object-centric models performance by optimizing perspective generation.
  • B-08450: Updated Snowflake UDF's python version from 3.8 to 3.11 (see release note above).
  • B-08425: Migrated nine configuration data tables to use Entity Framework.
  • B-08334: Removed legacy functionality related to models.
  • B-08337: Removed legacy functionality related to roles.
  • B-08456: Frontend components have been updated.
  • B-08477: Backend components have been updated.
  • B-08478: Updated translations for release 2024.7.

Fixed issues

  • D-14263: Filtering with case id caused error when Snowflake model didn't have case attributes datatable.
  • D-14256: Workspace showed progress spinner forever if trying to remove rows from table where there is no access.
  • D-14250: "Show in Query Designer" button didn't show full query sent to server.
  • D-14285: Non-breaking spaces didn't work in json fields.
  • D-14278: Workspace models list showed linked cases/events datatable even though datatable didn't exist.
  • D-14251: Aggregations list in Combined measure/dimension/column incorrectly showed aggregations for all data types.
  • D-14257: Exporting datatable with no columns froze loading spinner.
  • D-14188: Script incorrectly aborted after error occurring in the import phase of client-side import.
  • D-14275: Several "Loop percentage" event measures caused flowchart error.
  • D-14259: Removed malfunctioning undo/redo operations from Design diagram.
  • D-14260: Design diagram toolbar incorrectly scrolled to left when diagram was zoomed.
  • D-14262: Opening version information caused javascript error if backend communication failed.
  • D-14271: None aggregation didn't work with some Statistical calculations.
  • D-14283: BPMN editor toolbox has now correct font.
  • D-14280: Dashboard component stacking order buttons didn't work if dashboard had z-indeces with gaps.

QPR ProcessAnalyzer 2024.6 (build 7414) (released 2024-09-18)

Features:

  • B-08366: Frontend for OCPM model configuration and Snowflake charts using perspectives.
  • B-08365: Added following visual settings for KPI Card: font size, text color, text styles, vertical and horizontal alignment.
  • B-08382: Measures, dimensions and columns can be duplicated in chart settings.
  • B-08381: Table vertical scrollbar is now hidden when table is not scrollable.
  • B-08355: Expression language identifiers are primarily assumed as variables and secondarily as property names.
  • B-08402: QPR ProcessAnalyzer can now connect to Snowflake when running in Snowpark Container Services.
  • B-08389: Added support for making multiple Snowflake queries in same request for OCPM queries.
  • B-08416: Improved backend functionality for partially configured OCEL models.
  • B-08428: Improved Snowflake calculation performance by including to filter cache tables only the event table key (this behavior can be opt-in with a CacheOnlyPrimaryKeysForFilters setting).
  • B-08448: Add configuration to disable event cache tables storing primary key only.
  • B-08340: New users don't have a default model selected when login for the first time.
  • B-08413: Frontend components have been updated.
  • B-08397: Backend components have been updated.
  • B-08398: Updated translations for release 2024.6.

Fixed issues:

  • D-14209: Fixed issue where moving projects in Workspace was not possible.
  • D-14186: Highcharts visualizations datalabel texts were incorrectly shown over tooltips.
  • D-14210: Fixes for issue with incorrectly shown pending tasks in System Reports.
  • D-14242: SqlDataFrame Persist function now keeps the original column types even if they are changed.
  • D-14147: Snowflake queries gave "Object reference not set to an instance of an object" error with MaximumRowCount higher than 2 billion.
  • D-14189: Dropdown list component gave following error when clicking Add button for "List items": Cannot read properties of undefined (reading 'axisLabel').
  • D-14192: Datagrid paging settings are now preserved when resizing or zooming window.
  • D-14214: In System reports, dropdown list showing dashboards didn't open if there were more than 1000 dashboards.
  • D-14218: CSV file import didn't detect existing column correctly when there was difference only in letter case.
  • D-14184: Giving ScriptText or ScriptFileName as parameter for QPR ScriptLauncher created a broken script.
  • D-14220: AI assistant gave strange error message when trying to explain chart showing error.
  • D-14135: Expression based Snowflake filter rule caused error "Object reference not set to an instance of an object".
  • D-14229: In Snowflake, disabled filter rules didn't affect header object counts when there were several filter rules.
  • D-14228: In Models and Model statistics reports, columns showing case and event attributes didn't work.
  • D-14213: In User Settings dialog, Effective Permissions settings are now preserved while dialog is open.
  • D-14227: Fixed issue where applying chart settings in System reports made settings pane empty.
  • D-14185: Stack traces were incorrectly returned even if IncludeExceptionDetailsInErrors was false.
  • D-14226: Fixed several OCPM calculation related issues in backend.
  • D-13943: Added error message to Case attribute selector when model doesn't have selected case attribute.
  • D-14162: Expression "0.()" gave null reference error.
  • D-14246: Chart setting dialog may have been partly out of screen when activating other chart while in dashboard is scrolled.
  • D-14238: Snowflake chart measure aggregation is incorrectly affected by statistical calculations.
  • D-14133: In Snowflake chart, events Aggregate settings caused JaveScript error and UI messed up.
  • D-14172: Fixed issue where validation error appeared when copying and moving elements in Design Diagram.
  • D-14253: Table didn't show column filter icon when column name was empty.

Additional release for QPR ProcessAnalyzer 2024.5 (build 6814) (released 2024-07-01)

Known issue: It's not possible to move projects that existed before updating to this release. The issue will be fixed in the next release. There is a following workaround available: Administrator user can go to the Expression Designer and run the following expression: Projects.Modify(#{}).

Fixed issues:

  • D-14191: Running script by id failed on data import when parameters contained ScriptId.
  • D-14183: Fixed issue where flowchart SVG export only exported the visible part of flowchart.

Additional release for QPR ProcessAnalyzer 2024.5 (build 6769) (released 2024-06-27)

Features:

  • B-08388: Added backend support for OCPM model perspectives to convert object-centric eventlogs into case-centric.

Fixed issues:

  • D-14187: Creating local datatables was not possible in Workspace if datatables were stored to the configuration database (i.e., SqlServerConnectionString setting is not used).

QPR ProcessAnalyzer 2024.5 (build 6746) (released 2024-06-25)

Features:

  • B-08338: Added reports to monitor dashboards usage: Popular dashboards, Dashboards by users and by time, and specific dashboard usage.
  • B-08314: Snowflake connection string can be specified for each project to allow projects connecting to different Snowflake accounts, databases or schemas.
  • B-08341: Added GetRelatedValueFrom and AggregateRelatedValueFrom SQL expression functions to extend models with data from additional tables.
  • B-08301: In chart settings, selecting another measure/dimension/column now doesn't reset settings.
  • B-08317: Added Snowflake presets for Root Causes for Attributes in table and detailed table format.
  • B-08318: Improved Snowflake Events preset performance by adding a filter that picks a subset of cases.
  • B-08385: Open AI default large language model has been changed to "gpt-4o".
  • B-08342: Added DashboardName and DashboardProjectName properties to OperationLog in expression language.
  • B-08320: Added RenameAllColumns function to dataframes to easily rename all columns.
  • B-08321: Added DataSourceConnection property to dataframes in expression language.
  • B-08307: Finetuned Workspace functionality for models that don't have datasource defined.
  • B-08329: Optimized metadata queries to Snowflake to improve performance.
  • B-08311: Changed QPR ScriptLauncher interaction with the server by changing long polling to short calls to improve robustness.
  • B-08368: Implemented backend support for configuring and importing OCPM models.
  • B-08352: Frontend components have been updated.
  • B-08348: Backend components have been updated.
  • B-08349: Updated translations for release 2024.5.

Fixed issues:

  • D-14150: Charts temporarily showed as too large when resized with non-zero chart margin values.
  • D-14058: Login page is not anymore shown when SAML authentication is configured and user is directed to the identity provider.
  • D-11579: Column filter menu in tables can now appear outside the table area which is useful in small tables.
  • D-14144: Fixed issue where Snowflake clustering failed if there were date type of case attribute with null values.
  • D-14163: Non-breaking spaces appeared strangely as "&nbsp;" in Highcharts charts.
  • D-14132: Snowflake model object counts were not shown when opening dashboard while model metadata was still loading.
  • D-14142: CreateDataTable function incorrectly deleted all source datatable content if connection included source datatable name.
  • D-14161: Fixed issue where Append function in SqlDataFrame broke source data.
  • D-14157: AI Assistant didn't show detailed error message when OpenAI query failed.
  • D-14137: AI Assistant incorrectly appeared on top of chart in the fullscreen mode.
  • D-14170: Toolbar dropdown lists didn't work when dashboard contained more than one Design Diagram.
  • D-14146: Fixed error "Unable to get on-premise gateway named..." when running script from SQL script using QPR ScriptLauncher.
  • D-14106: Having only a template string in the #expr{...} block didn't work.
  • D-14008: "Root Causes contribution" and "Comparison eventlog cases percentage" columns didn't work (in-memory).
  • D-14010: Occurrences of specific flow measure didn't work with the Root causes analysis weighting expression (in-memory).
  • D-14148: Root causes for case duration preset didn't support Multi-unit time settings.
  • D-14139: Added info message when successfully exporting model to pacm file.
  • D-14153: Fixed in-memory measures for "Flow duration" and "Occurrences of specific flow" which failed when selected flow didn't exist.
  • D-14167: Fixed issue where ScriptLauncher sometimes terminated prematurely on exceptions occurring in on-premise import.
  • D-14165: Flowchart export file name was incorrect and exported flowchart background was always transparent.
  • D-14160: Fixed issue where DashboardId wasn't recorded to operation log when opening dashboard by identifier (DashboardsController.GetByIdentifierPath).
  • D-14159: IsHidden property didn't work in in-memory Value expressions.
  • D-14131: Some popup messages had incorrect html escaping.
  • D-14151: Fixed issue where flowchart might have given browser console error when clicking event types or flows while still loading data.
  • D-14022: In System reports, numeric aggregations which don't work in SQL Server are now hidden.
  • D-14129: Imported model name was incorrectly cut if it contained dots.

QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14)

Features:

  • B-08227: Dashboards have AI Assistant (powered by ChatGPT) helping users in process analysis. AI Assistant can answer general questions about the process, create filters based on user prompt, and explain charts and analyses.
  • B-08277: QPR ProcessAnalyzer now detects automatically when cases or events data in Snowflake updates. Check is done every 5 minutes which is the maximum delay of detecting new data. (more information)
  • B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
  • B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
  • B-08276: Adjusted permissions for moving projects.
  • B-08310: Added Details property to Exception object in expression language.
  • B-08328: Language translations have been updated to 2024.4.
  • B-08312: Frontend components have been updated.
  • B-08308: Backend components have been updated.

Fixed issues:

  • D-14084: Filter rule for first and last event in case couldn't be edited if there were more than one event selected.
  • D-14091: Duration multi-unit didn't work in big data chart.
  • D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
  • D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
  • D-14107: Snowflake model that has earlier been an in-memory model showed case count and estimated memory incorrectly.
  • D-14074: Fixed issue in QPR ScriptLauncher when calling the script from other script.
  • D-14104: Fixed expression language parsing issue with in-memory DataFrame and filter using "In" function.
  • D-14121: Datatable UpdateRows function now supports column names given as expressions.
  • D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
  • D-14123: There was an error of unable to get on-premise gateway when using ExtractSap function in expression language script from SQL script called from expression language script.
  • D-14128: Table without title was incorrectly exported as .txt file.
  • D-14112: Convert to custom expression button didn't work in design diagram.
  • D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
  • D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed in chart settings.
  • D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
  • D-14096: Highcharts tooltip square icons were slightly misaligned.
  • D-14099: There was a console warning when opening the business calendar dialog.
  • D-14118: Design diagram sometimes gave following JavaScript error: Cannot read properties of undefined (reading 'parentNode').
  • D-14024: If quickly logging out after changing model, the model change might not be been saved.
  • D-14120: User.getAttribute function returned values from incorrect context.
  • D-14102: Pivot table cannot read properties of undefined.
  • D-14161: SqlDataFrame.Append breaks the used source SqlDataFrames

QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)

Features:

  • B-08024: Design diagram has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
  • B-08242: Script based actions can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
  • B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
  • B-08288: Added expression language functions to start and stop scripts.
  • B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
  • B-07906: Implemented cross joins to SQL dataframes.
  • B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
  • B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
  • B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
  • B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
  • B-03047: Removed support for dashboard panels.
  • B-08214: Removed unused columns from the PA_VIEW table.
  • B-08254: Frontend components have been updated.
  • B-08255: Backend components have been updated.
  • B-08233: Language translations have been updated to 2024.3.

Fixed issues:

  • D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
  • D-14035: In design diagram, BPMN event and gateway symbols are now circular.
  • D-14049: Added some missing translations for table column filter and BPMN editor.
  • D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
  • D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
  • D-13976: Fixed issue where gateway-based imports were not synchronous.
  • D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
  • D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
  • D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
  • D-14071: Business calendar button press caused error when user didn't have access to any model.
  • D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
  • D-11268: There were inconsistent button colors in Workspace.
  • D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
  • D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
  • D-14081: Fixed null references error when logging null in expression script.

Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)

Features:

  • B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.

Fixed issues:

  • D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.

QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)

The legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., Models.Filters and RoleAssignments property.

New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).

Features:

  • B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
  • B-08232: Entire future eventlogs can be predicted based on generative AI models running in Snowflake.
  • B-08166: Added expression language function OpenAIChatCompletion to answer natural language prompts based on OpenAI ChatGPT API.
  • B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
  • B-08196: Conditional formatting rules can be defined for textual and boolean values.
  • B-08213: Big data chart expressions event type selections to be multi-select where applicable.
  • B-08205: Expression language API is available for storing secrets for scripts.
  • B-07780: Chart variable mappings has been removed - use the linked settings instead. Dashboards using variable mappings are automatically converted to use linked settings.
  • B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
  • B-08174: Only non-default parameters values are written to the operation log.
  • B-08200: Timestamps in System reports are shown in user workstation local time.
  • B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
  • B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
  • B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
  • B-08202: Updated copyright for year 2024.
  • B-08199: Frontend components have been updated.
  • B-08203: Backend components have been updated.
  • B-08209: Translations updated for release 2024.2.

Fixed issues:

  • D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
  • D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
  • D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
  • D-13962: System variable values were interpreted incorrectly when used in linked settings.
  • D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
  • D-13959: Removed possibility to add datatable columns with the legacy "any" data type.
  • D-13991: Improved drop-down selector component to handle empty strings as variable values.
  • D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
  • D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
  • D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
  • D-13960: Added missing translations for list of permission list and 12-hour clock format.
  • D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
  • D-13969: Datatable column schema export sometimes showed empty for the key column.
  • D-13862: Session token was not accepted when url path capitalization is different.
  • D-13942: Datatable could not be dimensioned if it has column named "CaseId".
  • D-13980: Business calendar dialog crashed when tried to open it for a model without access.
  • D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
  • D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
  • D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
  • D-13977: Multi-select dropdown lists showed some special characters incorrectly.
  • D-13945: Syncfusion toast message didn't work when text contains ${[]}.
  • D-13930: Pivot table throws javascript error when certain clicks.
  • D-13273: Duplicate datatable row count didn't shown correctly.
  • D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
  • D-13985: Models list dots menu had texts misaligned in narrow screens.
  • D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
  • D-13997: Workspace tables column filtering search caused JavaScript errors.
  • D-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
  • D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
  • D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
  • D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
  • D-14004: Removed empty filters from queries to optimize them.
  • D-13988: Fixed issue where data grid context menu rendered initially as too high.
  • D-13979: BPMN model editor element settings use now Open Sans font.
  • D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
  • D-13984: Fixed the error of refusing to run the JavaScript URL.
  • D-14031: ThrownObject property was not included to http error response when error came from the script.

QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10)

QPR ProcessAnalyzer Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime (see more). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.

In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.

Features:

  • B-08019: New component Design Diagram for showing user-created diagrams in dashboards where to visualize process mining metrics.
  • B-08087: Generic dropdown list selector works with Snowflake models allowing to add selection lists for any values.
  • B-08163: Linked settings support for binding to case attribute filter values without defining case attribute name.
  • B-08170: Snowflake model filters can be saved as new models which can be used to create snapshots of part of models.
  • B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
  • B-08161: Added Modify function to change datatable properties and improved CreateDatatable function for creating datatables.
  • B-08122: Added new system report to list dashboards.
  • B-08173: Removed legacy filters that didn't have any filter rules.
  • B-07961: In OperationLog, changed parameters to json format and added request id.
  • B-08069: Added DashboardId property to OperationLog in expression language.
  • B-08139: Added UpdateRows function to update existing rows in datatables with similar logic than SQL update.
  • B-08115: Added DeleteRows function to delete rows in datatables with similar logic than SQL delete.
  • B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
  • B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
  • B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
  • B-07689: For datatables, foreign keys to other datatables can be defined using expression language.
  • B-08176: Translation updates for release 2024.1.
  • B-08175: Workspace should show timestamps in user's local time.

Fixed issues:

  • D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
  • D-13916: Chart filter could not be defined for some expressions in Big data chart.
  • D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
  • D-13906: In Conformance Analysis, deviating flows were not translated.
  • D-13907: Improved translation related to datatable properties dialog "Used by models" field.
  • D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
  • D-13911: Fixed small glitches in the opening and closing of drop-down lists.
  • D-13918: Datatable could be configured incorrectly to use table for other datatable.
  • D-13932: Duplicating datatable with custom table in datasource losed all data.
  • D-11002: Removed legacy in-memory prediction preset.
  • D-13912: Added check that array cannot be stored to dashboard Content property.
  • D-13936: Query designer default query didn't work with Snowflake models.
  • D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
  • D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
  • D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
  • D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.

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