QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
 
Line 1: Line 1:
This page contains new features and fixed issues for each QPR ProcessAnalyzer release. For information on the compatibility of different versions, see [[QPR ProcessAnalyzer Version Compatibility|Version Compatibility Information]].
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.


== Next Release: QPR ProcessAnalyzer 2021.6 (planned release date 2021-08-10) ==
== Next Release: QPR ProcessAnalyzer 2025.2 (planned release 2025-03-04) ==
'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer Excel Client is deprecated and will not be available starting from release 2021.7 (planned release date 2021-09-21), which will contain all functionalities in the web UI. If you are having any issues when switching over to the web UI, please give us feedback through customercare@qpr.com and describe your process mining use case.
</div>


'''Features:'''
[[Next_Release_Content|See plan for next release features and fixes]]
* B-05859: CSV file import is renewed and available in the Workspace (old import is still available).
* B-05988: Charts can be duplicated when designing dashboards.
* B-05969: Not contains -type of column filter is available in tables.
* B-03225: If user is authenticated with SAML, password changing is not available.
* B-03232: In dashboard export files, chart settings are stored as presentation object property instead of context variable.
* B-05860: Frontend component update (part 2).
* B-05982: Workspace context menu improvements.
* B-05950: Allow empty value in first column in CSV file import.


'''Fixed issues:'''
== Latest Release: QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23) ==
* D-11107: In Workspace, when new project, datatable or script is clicked, the name text was highlighted by default.
* D-11106: Query cancellation suppression didn't work when cancellation was in the inner exception.
* D-11118: Issues with Dropdown list selector: (1) dates as variable values are handled incorrectly, (2) list refreshes unnecessary when activated.
* D-11117: Case attribute and event type filters lists incorrectly made queries already when dashboard is opened.
* D-11053: All texts didn't fit to screen in Syncfusion grid Excel filter when using e.g. Russian.
* D-11075: Datatable didn't open after creation from UI.
* D-11105: Wrong color in Clear Filter icon in data grid Excel filter.
* D-11092: Code editor should not show errors for correct code.
* D-11104: When context menu is opened for project that is not previously selected, hierarchy was scrolled.
* D-11095: For json type of error responses Content-Type is now application/json.
* D-11071: Web API could still return datatables with null configuration.
* D-11098: Small layout issue fixes.
* D-11133: Submenu of "Move to" is opened at the top-left corner.


== Latest Release: QPR ProcessAnalyzer 2021.5 (build 389) (released 2021-06-23) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]


'''Features:'''
===New features===
* B-05846: Datatable contents can be previewed, and also new system reports dialog.
* B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
* B-03233: Improved UI for chart background color, border color, border width and border corner radius.
* 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-05852: New presets for intelligent process automation and boxplot visualizations.
* B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
* B-05828: Actions for tables to change dashboard variables.
* 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-05853: Scripting supports also scripts written in the expression language.
* B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
* B-05093: Workspace visual layout has been improved and context menu is available also for projects, dashboards and datatables.
* B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].
* B-05922: Component filter for case attribute and event type selectors.
* B-05847: Presets performance improvements: Digital fit rate by attribute, Path until selected event, Path starting from selected event.
* B-05836: Changed "Automation opportunity scout" to use even types as basis and implement optimizations.
* B-05825: Better performing method to get event type names in model.
* B-05821: Improved backend performance by removing unnecessary ToArray calls.
* B-05817: Backend support for running expression scrips in web UI.
* B-05855: Running expression scripts in ScriptLauncher.
* B-05946: Data type conversions for CSV import.
* B-05944: CSV file writing for expression script through ScriptLauncher and client side execution using expression scripts.
* B-05827: Distributed computing, part 8: SqlDataFrame support for locally stored datatables.
* B-05850: Distributed computing, part 9: External table naming, data table import refactorizations, generic context.
* B-05849: Distributed computing, part 10: Improvements and preparations for performance tests.
* B-05840: Frontend components have been updated.
* B-05935: Translations for 2021.5 release.


'''Fixed issues:'''
===Fixed issues===
* D-11084: Syncfusion pivot table headers were not visible.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* D-11085: Tooltip in chart settings were stuck open in some occasions.
* 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-09524: Polar chart showed wrong tooltips value and graph was shown incorrectly if polar chart disabled and enabled again.
* D-14346: Fixed issue where manual activation using activation utility didn't work.
* D-11007: Workspace grid showed shortly incorrect content.
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* D-11030: Javascript error: "TypeError: Cannot read property 'length' of null" when returning to workspace.
* D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* D-11042: Release package was much larger for 2021.4 than for earlier releases due to unnecessary Monaco editor files.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
* D-11051: Negative timespans returned by server don't work in UI.
* D-14331: Flowchart lost selection when flowchart used linked variables with array values.
* D-11052: Number of cases not updated when removing ModelId from dashboard properties.
* D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
* D-11054: Background color conditional formatting didn't work for non-numerical columns.
* D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
* D-11055: Extra space appeared in header when changing model and opening filters list.
* D-14342: Flow step and Zoom settings control have same size and layout is aligned.
* D-11058: Expression filters didn't work due to single quotes don't work anymore.
* D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
* D-11059: On-the-fly migration for existing stored expression filter rules using single quotes.
* D-14327: AI Assistant had console error when pressing send button without text.
* D-11068: When zooming and moving flowchart, following console error appeared: TypeError: Cannot read property 'behavior' of undefined.
* D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
* D-11073: Chart image export should have same scale as in the dashboard.
* D-14321: Added error message for AI Assistant when trying to use it without model selected.
* D-11072: Index out of bounds error in Flow Duration analysis view.
* D-11074: Dragging root causes rule from header to chart sets invalid Comparison variable breaking dashboard.
* D-11045: Web UI incorrectly fetched resources from fonts.googleapis.com.
* D-10988: Pivot table javascript error: Uncaught TypeError: Cannot read property 'refreshFrozenScrollbar' of null.
* D-09594: Pivot table: Adjust browser size for event count analysis: Type Error: Cannot read property 'getPanel' of null occurred.
* D-11043: Deleted scripts caused error if they are in the script editor tab.
* D-11063: Datatable.Columns gave error for new datatable.
* D-11064: XES import does not always import event attributes.
* D-11067: Copying datatable that has configuration=null leads to inconsistent copied datatable.
* D-11076: Moving script to project didn't work.
* D-11044: Negative timespans were serialized incorrectly as positive.
* D-11027: SQL query failed because connection was closed by deadlock.
* D-11057: Optimization Where(Attribute(<constant 1>) == <constant 2>) works incorrectly.
* D-11040: All expression lexing errors were not handled.
* D-11019: Improve following unclear error message: "Selection failed: Unknown case attribute for object of type AttributeType: name".
* D-11082: Filtering didn't work when clicking cell text for cells using conditional formatting.
* D-11080: Clustering Analysis view had TypeError: Cannot read property 'field' of undefined.
* D-11087: Improved unclear error message:  Nullable object must have a value.


== QPR ProcessAnalyzer 2021.4 (build 328) (released 2021-05-18) ==
===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.


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


<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;">
There is a breaking change in 2021.4 related to using tags in custom expressions: If a tag provides a string value, before it was written e.g. ''Attribute("<#AutomationAttribute>")'', but now it needs to be written ''Attribute(<#AutomationAttribute>)'', because the quotation marks of the string literal now come with the value replacement. The former will cause error in 2021.4, as there will be two sets of quotation marks. This problem does not concern other type of values (e.g. numeric), as they don't have quotation marks.
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:
<pre>
Models.Where(!IsOcelModel && Configuration.TryGetValue("DataSource").TryGetValue("Events").TryGetValue("DataSourceType") == _EMPTY).(Project.Name + ": " + Name + " (" + Id + ")")
</pre>
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:
<pre>
ModelById(<id>).DeletePermanently()
</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;">
Scripts that are stored to the ''model'' or ''user'' context are not available in the scripting web UI (scripts in ''project'' and ''system'' context are available). If you have scripts in the model or user context, they need to be recreated in the project or system context using the Excel Client latest in 2021.4. Starting from 2021.5, scripts in the model or user context are preserved in the system, but cannot be used anymore (and they will be removed in a future release).
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>
</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;">
Tables used in dashboards are updated to the next generation of Syncfusion JS2 components. The [[QPR_ProcessAnalyzer_Chart#Visualization_Settings|Custom layout]] settings (defined as JSON) of the table might not be compatible between the generations, and thus they need to be changed manually after updating to 2021.4. See instructions how to migrate settings between the generations of the component: https://ej2.syncfusion.com/documentation/grid/ej1-api-migration/.
[[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.
</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 2021.4, the [[Data_Grid_Export_Service|Data Grid Export Service]] (used for exporting tables as Excel files) is not needed anymore. The renewed table is able to create export files in the browser side without using any server/cloud side service. If the Data Grid Export Service has previously been installed, it's recommended to uninstall it for security reasons (to reduce attack surface).
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.
</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;">
There is a new step in the QPR ProcessAnalyzer server installation instructions for allowing large process mining models: [[Installing_QPR_ProcessAnalyzer_Server#.Net_Configuration:_gcAllowVeryLargeObjects|.Net configuration: gcAllowVeryLargeObjects]]. The change should also be done for earlier QPR ProcessAnalyzer server versions if using models that have more than 50 million events.
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:'''
===Features===
* B-03297: Scripting is available in the web UI.
* B-08395: Added native [[Object-Centric_Flowchart|object-centric flowchart]] showing predefined measures.
* B-03231: Recycle bin for models and projects is available in the web UI.
* B-08396: Object attributes are now available as [[Object-centric_Process_Mining_Model#Object-centric_perspectives|case attributes in object-centric perspective]].
* B-05764: Table component in dashboards has been upgraded to newer generation of Syncfusion JS2.
* B-08449: Snowflake Native App supports [[QPR_ProcessAnalyzer_Project_Workspace#Snowflake_Native_App|project-specific database, schema, and warehouse]].
* B-05814: There are now default parameter values for most preset.
* B-08432: Decision intelligence event log [[Create_Predicted_Eventlog|prediction]] and [[Create_Simulated_Eventlog|simulation]] has been integrated into QPR ProcessAnalyzer.
* B-05812: Optimize "Automation opportunity scout" preset and remove root items duplicate removal from dimensioning
* B-03062: Project Designer and Administrator roles can now create models and datatables, and global "Create models" role changed to "Create projects".
* B-05769&B-03081: "Cost Savings by Automation" preset performance has been improved.
* B-08471: Model properties dialog has been simplified for Native App to exclude in-memory model datasources.
* B-05745: Functions CaseByName and Reverse, and improved support for TimespanPrecision/DatetimeTruncation.
* B-08504: Charts don't automatically change case/event attributes and event types when encountering non-existing selections.
* B-05750: Expression language functions for managing datatables.
* B-08522: Optimized Snowflake queries that do not need event data.
* B-05800: Improvements to SQL script log writing.
* B-08454: Optimized SQL executed in Snowflake by removing unnecessary column type casts.
* B-05083: Expression language scripting.
* B-08507: Migrated tables for scripts and script logs to Entity Framework.
* B-05789: Expression language scripting: Run expression language scripts using Run function.
* B-08519: Migrated user management tables to Entity Framework.
* B-05799: Expression language scripting: Run SQL scripts using Run function.
* B-08539: Migrated model, project and filter tables to Entity Framework.
* B-05752: Delete multiple items at the same time: Recyclebin.DeletePermanently().
* B-08514: Updated translations for release 2024.8.
* B-05082: Distributed computing, part 5: Improving KPI analysis expressions and data import.
* B-08515: Frontend components have been updated.
* B-05762: Distributed computing, part 6: Improvements related to imports to external distributed computing systems
* B-08513: Backend components have been updated.
* B-05790: Distributed computing, part 7: Filtering etc.
* B-05775: Translations for PA 2021.4 release.
 
'''Fixed issues:'''
* D-11008: "The given key was not present in the dictionary" still appears in dashboards.
* D-11034: Business calendar calculates incorrectly.
* D-10987: Filtering doesn't work from dimensions that need to use root expression.
* D-10959: Unsaved change confirmation Russian translation  has "% 0" in message.
* D-10993: Column chart not working in Measure settings.
* D-10978: PA WebUI:  incorrect Case Level Permission expressions prevent using Model manager.
* D-10984: Model cannot be used when in model json settings Permission.Case="".
* D-11010: Chart comparison cannot be created from header root cause analysis.
* D-09533: Table column width changes back to default.
* D-09509: Datatable multi-selection:  Uncaught TypeError: this.selectedRowCellIndexes[_].cellIndex.push is not a function.
* D-09521: Columns in wrong order for some of the periods in Event Count Trend by Types preset.
* D-09507: Tooltips for chart table columns shown far away from the column.
* D-11004: Error: Uncaught (in promise): Error: Dataset doesn't contain column "measure0".
* D-10970: Parameter define controls should display for full size Duration analysis view.
* D-11013: TypeError: Cannot read property 'querySelectorAll' of null.
* D-11018: Case duration exclude cases filter has wrong text in header.
* D-11021: BPMN editor console warnings: "Passing callbacks to is deprecated and will be removed in a future major release".
* D-11001: Filter option and checkbox display in two rows.
* D-09593: TypeError: Cannot read property '0' of undefined.
* D-10999: Error: <rect> attribute width or X: Expected length, "NaN".
* D-11012: Tooltip still shown after moving criteria for finding root causes  from header.
* D-10972: Include and exclude dropdown list cannot display properly when analysis view display in fullscreen.
* D-11020: Boxplot filtering by clicking does not work.
* D-10992: PDF generated in Chart settings shows some info twice.
* D-09513: When changing model and chart settings contain case/event attribute that doesn't exist in the model, error is given.
* D-11023: All mappings in Measures tab not shown when changing to Box Plot Chart.
* D-11024: Error messages not in logical order for missing values when drawing charts.
* D-10994: Empty popup for dashboard link going to a non-existing dashboard.
* D-10961: TypeError: Cannot read property 'refreshUI' of null.
* D-11026: Unsupported BPMN node types should not be selectable.
* D-11035: Table column resize causes never ending loading animation.
* D-11036: Chart settings doesn't open, if configuration has non-existing preset definition.
* D-11000: Model is incorrectly dropped first time some Permissions Expression data is added.
* D-10990: System.ArgumentException thrown on model loading from HashSet.SetCapacity.
* D-10977: Dimension rounding works incorrectly in expression filters.
* D-11003: Model JSON configuration related error to cases datasource.
* D-11005: Error shown in some situations after empty string Permissions expression has been removed.
 
== QPR ProcessAnalyzer 2021.3 (build 263) (released 2021-03-30) ==


'''Features:'''
===Fixed issues===
* B-03242: Sampling for the analyzed objects of the chart.
* D-14320: On-screen setting didn't work when "dynamicType" is "DataTablesOfProject".
* B-03239: Chart settings visual improvement and reorganization (migration to Syncfusion JS2).
* D-14221: Content-Security-Policy HTTP headers allows only same origin for iframes, and X-Frame-Options HTTP header removed.
* B-03307: Miscellaneous improvements to Workspace.
* D-14317: Model statistics system report gave error about invalid expression.
* B-03075: Models are kept in memory when settings are changed (excluding datasources and calculated attributes).
* D-14286: Fixed issue in model import which sometimes created partially configured model.
* B-03079: Improvements to model JSON configuration for Case/EventAttributes.
* D-14315: Filtering for custom dimensions didn't work, if expression refers to measures with variables.
* B-03308: In Query Designer, ContextType should be "Model", when ProcessingMethod is "DataFrame".
* D-14302: "let" statement did not work in #expr-block embedded into SQL expression.
* B-05075: Script entities are accessible in the expression language.
* D-14303: Flowchart lost selection when flowchart used linked variables.
* B-03302: Scripting backend changes: Single state for scripts.
* D-14311: Fixed issue were dashboards were not visible in iPhone.
* B-05079: API for creating and editing scripts.
* D-14301: Filtering from "First event attribute value" and "Last event attribute value" columns did not work.
* B-05074: Frontend components update.
* D-14314: Fixed error in BPMN editor when object-centric model didn't have perspective defined.
* B-05077: Support for scripts in POST /api/uielements/setproject/{projectid} and DELETE /qprpa/api/uielements.
* D-14297: Native App incorrectly cached OAuth token causing "OAuth access token expired" errors.
* B-03296: API for recycle bin.
* D-14248: Improved error message "Unable to read event log data from external source without specified sample size".
* B-03315: Distributed computing: Streamlining dataframe based KPI analysis configurations.
* 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 ...".


'''Fixed issues:'''
== QPR ProcessAnalyzer 2024.7 (build 8234) (released 2024-10-29) ==
* D-10965: "The given key was not present in the dictionary" error when calculating expression referring to attribute values.
* D-10985: SAML service provider self-signed certificate is renewed.
* D-10976: Donut showed slices in incorrect order.
* D-09534: Filters were not working correctly in some cases.
* D-10974: Median aggregation didn't work in table conditional formatting.
* D-10962: Tables conditional formatting referring to other columns, didn't work.
* D-10963: Chart table web links should not encode tag if it contains entire url.
* D-09581: Fix for error: Cannot read property 'length' of undefined.
* D-09589: The error message is now more specific in the "no access" case.
* D-09592: Fix for error: TypeError: Cannot read property 'querySelector' of null.
* D-09518: Stacking for Column Pyramid Chart alignment issue.
* D-09597: Case attribute and event type filter components are not showing counts and visualize items without cases.
* D-09591: Server required To field information to send a notification.
* D-09494: Username and setting was missing in ScriptLauncher logs.
* D-09535: TakeSample function should not decrease performance when sampling is not needed.
* D-09580: TakeSample function should support DataFrames.
* D-09610: Expression based greater/lower than filters don't show texts in header.
* D-09601: Filter rule editor bugs: wrong counts and existing filters not taken into account.
* D-09606: Flowchart doesn't show loading spinner.
* D-09609: JavaScript error when opening flowchart for the first time.
* D-10960: Client side query cache should be cleared when model is dropped, reloaded or model settings changed.
* D-10967: Missing translation for "Select All" filter option.
* D-10969: Fix for error: SyntaxError: Unexpected token u in JSON at position 0.
* D-10979: Browser log should not contain informational messages.
* D-10982: Model properties has problem to get new added datatables for CASE and EVENT Datasources.
* D-09522: Uncaught TypeError: Cannot read property 'call' of undefined.
* D-09911: Turn off filter rule will cause i[e][a] is not iterable at Function.compactFilterRules error.
* D-09510: Clicking workspace button or switching between editor modes don't close chart settings.
* D-09519: Chart configuration validation doesn't show error message.
* D-09603: ERROR TypeError: Cannot read property 'getConfiguration' of null.
* D-09525: Search line is not under the search string for filters in Query Designer.
* D-09441: "In" function doesn't work with different integer types.
* D-09612: "In" function doesn't work when written in lower case.
* D-09586: CSV file import failed.
* D-09595: Query cancellation doesn't work in /api/expression/query.
* D-09440: User management web API doesn't write to operation log.


== QPR ProcessAnalyzer 2021.2 (build 215) (released 2021-03-03) ==
'''Features:'''
* B-03237: Dialog for defining email notifications.
* 308126: Dialog for defining business calendars and using business calendars in charts.
* 308087: Datatables can be renamed and duplicated.
* 308090: Model settings dialog renewed, new dialog for calculated attributes, dialog for editing filter rules renewed, model duplicating.
* B-03292: Support for Polish language.
* B-03265: Automatic license reactivation.
* B-03314: Triggering email notifications using expression language.
* 308094: BPMN models are validated in the BPMN editor.
* B-03293: TakeSample function to expression language.
* B-03298: API call for expression query.
* B-03300: Components update.
* B-03299: Translations updates.
* B-03301: Distributed computing, part 1: Merge code from distributed computing branch.
* B-03317: Distributed computing, part 2: Access external DDBMS via data tables
* B-03311: Distributed computing, part 3: Restoring support for Spark and Snowflake.
'''Fixed issues:'''
* 219613: Analyzed objects "Events of specific type" didn't work in chart when there is one event selected.
* 219611: Filtering attributes with empty string values did not work.
* 219616: Unnecessary small vertical scrollbar in models list in Chrome and Edge.
* 219624: Dashboard link set variables incorrectly to dashboard context.
* 219436: Improved error message, when user has no access to any models.
* 219505: Bottom margin was missing for dashboard if aspect ratio flex is 1.
* 219434: Error appeared when creating conformance filter for invalid BPMN model.
* 219427: Error "Conformance model created without any start events!" appeared and BPMN view was not usable.
* D-09584: Filter parameter was not passed correctly in the url when opening UI.
* D-09515: When creating/editing filter rule, selections shown should be filtered with other filter rules.
* D-09495: /api/signout to return 204 also when activation or session is expired.
* D-09568: Multi-select data from different datatable columns causes error.
* D-09569: Model loading failed after previously trying to load model with invalid calculated case attribute.
* D-09570: Performance optimization: BusinessCalendar function changed to constant foldable.
* D-09572: Clustering Cases analysis failed when data contains null values.
* D-09573: Predicted Long Cases fails on performance test machine.
* D-09574: Datatable copy fails to timeout with large data and blocks fetching datatables metadata.
* D-09577: Server crashed e.g. when editing calculated attributes (error in object finalizer).
* D-09578: Excel client: Operation log showed details of only one operation.
* D-09579: "From" in an expression was treated a keyword even if it should not be.
* D-09587: Improve logging in model loading.
* D-09516: JavaScript error when sorting by identifier in workspace: "Cannot read property 'closeDialog' of undefined".
* D-09576: api/expression/query changed to use ProcessCoreInterfaceCall.
== QPR ProcessAnalyzer 2021.1 (build 163) (released 2021-01-18) ==
'''Features:'''
* 308096: New function "EventLog" to expression language to explicitly define preprocessings.
'''Fixed issues:'''
* 219612: Opening models dropdown list jammed UI when there are lot of models.
* 219495: Improve error message when trying to change login name to already existing.
== QPR ProcessAnalyzer 2021.1 (build 156) (released 2021-01-12) ==
'''Notes:'''
<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;">
There is a potential performance issue with the list of models in the header, which may appear when there are dozens of models in the list. When there are lot of models, the models list jams the UI when opened. The next release (build 163) has solved the issue.
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>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer 2021.1 does not have the '''Data Grid''' and '''HTML''' presentation objects, and they have been replaced by easier-to-use and more powerful [[QPR_ProcessAnalyzer_Chart|Chart]] presentation object, which supports many layouts such as [[QPR_ProcessAnalyzer_Table|tables]]. After updating to QPR ProcessAnalyzer 2021.1, existing dashboards containing Data Grid and HTML presentation objects will contain a placeholder with a message that the presentation object doesn't exist. That placeholder can be removed and replaced with the Chart presentation object. If you need to preserve settings for the removed presentation objects, that needs to be done before updating to QPR ProcessAnalyzer 2021.1.
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>
SELECT *
FROM [PA_ROLE]
WHERE [ROL_FLAGS] = NULL;
</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;">
Data types of the datatables and temporary tables created by the [[QPR_ProcessAnalyzer_Scripting_Commands#--.23ImportSapQuery|--#ImportSapQuery]] command has been changed: previously data types were NVARCHAR(255) for all columns. Now the maximum length in the NVARCHAR data type depends on the SAP data field length. This optimizes the space needed for data storage. In addition, there is a new parameter '''ConvertDataTypes''' allowing to specify which data types are converted correctly instead of using textual format.
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:'''
'''Features'''
* 308075: Chart data point colors can be defined using [[QPR_ProcessAnalyzer_Graphs#Conditional_Formatting|conditional formatting]].
* B-08458: Object-centric perspectives can be stored as filters and object-centric model can be selected for dashboard.
* 307816: Datatables to workspace (part 1).
* B-08472: Snowflake filter cache tables are now created in background to improve performance.
* 308076: QPRLibraries migration to Syncfusion JS2 (part 4).
* B-08452: Limited sampled cases to 10000 in Snowflake and in-memory clustering presets.
* 308086: Syncfusion JS2 update.
* B-08430: Improved [[Process_Flowchart|Snowflake flowchart]] performance by calculating variations using sampling.
* 307975: Data grid presentation objects and datasets have been removed.
* B-08446: QPR ProcessAnalyzer can be deployed as Snowflake application package to publish it as a [[QPR_ProcessAnalyzer_Native_App_in_Snowflake|native app]].
* 307974: Remove HTML presentation objects have been removed.
* B-08418: QPR ProcessAnalyzer has been integrated into Snowflake authentication for Snowpark Container Services.
* 308073: Create presentation object types for all HTML presentation objects used in system views - part 2.
* B-08420: Legacy "Local" datatables cannot be created anymore - only separate SQL Server database is supported (see release note above).
* 308077: Translation updates for PA release 2021.1.
* B-08437: Snowflake cache is now bypassed for queries that have caching disabled.
* 307652: Remove QPR Connector.
* B-08443: Improved object-centric models performance by optimizing perspective generation.
* 307709: Remove most of Excel client functionality and support of Xpress.
* B-08450: Updated Snowflake UDF's python version from 3.8 to 3.11 (see release note above).
* 308039: Web API for terminating operations.
* B-08425: Migrated nine configuration data tables to use Entity Framework.
* 308046: Web API for copying datatable.
* B-08334: Removed legacy functionality related to models.
* 308051: [[Importing_Data_from_SAP|Data type conversions]] have been improved for SAP import.
* B-08337: Removed legacy functionality related to roles.
* 308105: Copyright information update to 2021.
* B-08456: Frontend components have been updated.
* 308063: SmtpFromAddress setting for sending email.
* B-08477: Backend components have been updated.
* 307368 & 308084: Business calendar for duration calculation.
* B-08478: Updated translations for release 2024.7.
* 307565: Expression filter rule improvements for comparing numerical values.
* 307990: Email notifications part 1.
* 308071: Conformance analysis performance improvements.
* 308080: IIS configurations for .po and .woff2 files.


'''Fixed issues:'''
'''Fixed issues'''
* 219589: Enhanced BPMN system view has unnecessary horizontal scrollbar.
* D-14263: Filtering with case id caused error when Snowflake model didn't have case attributes datatable.
* 219590: UI got frozen when opening workspace from home view if no other system view opened just before.
* D-14256: Workspace showed progress spinner forever if trying to remove rows from table where there is no access.
* 219595: Long words were not wrapped in message dialog.
* D-14250: "Show in Query Designer" button didn't show full query sent to server.
* 219519: Error message did not show clear enough information.
* D-14285: Non-breaking spaces didn't work in json fields.
* 219557: Root causes analysis is changed to take into account summary row column count.
* D-14278: Workspace models list showed linked cases/events datatable even though datatable didn't exist.
* 219592: Excel client installer did not contain all connector files.
* D-14251: Aggregations list in Combined measure/dimension/column incorrectly showed aggregations for all data types.
* 219600: Confirmation message is improved when deleting project.
* D-14257: Exporting datatable with no columns froze loading spinner.
* 219607: Dashboards don't work with bpmn models having linebreaks.
* D-14188: Script incorrectly aborted after error occurring in the import phase of client-side import.
* 219604: Special characters do not work correctly in chart settings.
* D-14275: Several "Loop percentage" event measures caused flowchart error.
* 219606: Using dashboard links sometimes causes an error message to popup.
* D-14259: Removed malfunctioning undo/redo operations from Design diagram.
* 219608: Conformance statistics po tooltip in tool palette is incorrect.
* D-14260: Design diagram toolbar incorrectly scrolled to left when diagram was zoomed.
* 219593: Getting data tables is really slow and the query times out after 30 seconds.
* D-14262: Opening version information caused javascript error if backend communication failed.
* 219582: ScriptLauncher not work in direct database mode.
* D-14271: None aggregation didn't work with some Statistical calculations.
* 219549: Number of columns in the totals row of analysis types 14 (root causes) and 29 (duration root causes) should be same as in other rows.
* D-14283: BPMN editor toolbox has now correct font.
* 219544: Inconsistent # Cases Total when running an analysis.
* D-14280: Dashboard component stacking order buttons didn't work if dashboard had z-indeces with gaps.
* 219539: Excessively large amount of data added into expression language exception messages.
* 217293: SQL script parser lost lines and error show wrong line numbers.
* 219572: In-memory dataframes (SimpleDataTable) don't work with >1 billion unique strings.


== QPR ProcessAnalyzer 2020.8 (build 113) (released 2020-12-09) ==
<span id="84516a70"></span>


'''Notes''':
== QPR ProcessAnalyzer 2024.6 (build 7414) (released 2024-09-18) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release fixes the following performance issue '''219585: Showing models list blocks until model loadings have been completed'''. It caused the Model manager and list of models not to open while a model loading was in progress. This may have caused considerable performance degradation in environments where large models are loaded manually by users.
</div>


'''Features:'''
'''Features:'''
* 308061: QPR ProcessAnalyzer version related detailed information is shown User settings.
* B-08366: Frontend for [[Object-centric_Process_Mining_Model|OCPM model]] configuration and Snowflake charts using perspectives.
* 308067: Charts have performance benchmarking to measure the time taken to calculate a chart.
* B-08365: Added following visual settings for [[QPR_ProcessAnalyzer_KPI_Card|KPI Card]]: font size, text color, text styles, vertical and horizontal alignment.
* 308042: Dashboard layout logic has been changed in a way that the possible empty space is preserved when viewing dashboards.
* B-08382: Measures, dimensions and columns can be duplicated in [[QPR_ProcessAnalyzer_Chart#Measure,_Dimension_and_Column_Settings|chart settings]].
* 308002: Web.config contains by default HTTP response header Cache-Control: no-cache, so that browsers check the latest QPR ProcessAnalyzer version is in use after update.
* B-08381: [[QPR_ProcessAnalyzer_Table|Table]] vertical scrollbar is now hidden when table is not scrollable.
* 308079: New parameter OperationId is added to operation log.
* 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 [[PA_Configuration_database_table#CacheOnlyPrimaryKeysForFilters|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:'''
'''Fixed issues:'''
* 219585: Showing models list blocks until model loadings have been completed.
* D-14209: Fixed issue where moving projects in Workspace was not possible.
* 217940: PAPO flowchart scroll position was incorrectly on the very left.
* D-14186: Highcharts visualizations datalabel texts were incorrectly shown over tooltips.
* 219564: Duplicate of dropdown list contents appears in wrong place when opening dynamic single selected list after changing model.
* D-14210: Fixes for issue with incorrectly shown pending tasks in System Reports.
* 219511: Scheduled loading of datatables caused the server to run out of memory.
* D-14242: SqlDataFrame Persist function now keeps the original column types even if they are changed.
* 219591: Using Web.HttpsOnly.config caused HTTP Error 500.19 - Duplicate connection cache-control.
* D-14147: Snowflake queries gave "Object reference not set to an instance of an object" error with MaximumRowCount higher than 2 billion.
* 219586: Previous modifications to Web.config are also done to Web.HttpOnly.config.
* D-14189: Dropdown list component gave following error when clicking Add button for "List items": Cannot read properties of undefined (reading 'axisLabel').
* 219566: Settings panel cannot be opened for flowchart.
* D-14192: Datagrid paging settings are now preserved when resizing or zooming window.
* 219569: Conformance check view has "Cannot read property min of undefined" JavaScript error.
* D-14214: In System reports, dropdown list showing dashboards didn't open if there were more than 1000 dashboards.
* 219562: It was not be possible to filter based on the rest of the items exceeding maximum in charts when there are more than one dimension.
* D-14218: CSV file import didn't detect existing column correctly when there was difference only in letter case.
* 219422: Chart Setting dialogue was not closed when user was redirected to relogin after session expiring.
* D-14184: Giving ScriptText or ScriptFileName as parameter for QPR ScriptLauncher created a broken script.
* 219584: Flowchart cache was not cleared when user logs out.
* D-14220: AI assistant gave strange error message when trying to explain chart showing error.
* 219536: SVC log file was incorrectly generated to QPRPA root folder.
* D-14135: Expression based Snowflake filter rule caused error "Object reference not set to an instance of an object".
* 219532: Creating new objects using Web API incorrectly required property id=-1.
* 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.
== QPR ProcessAnalyzer 2020.8 (build 80) (released 2020-11-10) ==
* 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.


'''Notes:'''
== 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;">
The [[QPR ProcessAnalyzer Version Compatibility|database major version]] has changed in QPR ProcessAnalyzer 2020.8, which means that earlier QPR ProcessAnalyzer releases are not compatible with the database that has been updated to QPR ProcessAnalyzer 2020.8. This needs to be taken into account in those environments where multiple versions of QPR ProcessAnalyzer server are run using the same database.
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>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Fixed issues:'''
Eventlog data for the legacy models is removed from the database automatically when updating to QPR ProcessAnalyzer 2020.8. This leads to permanent loss of data if all the needed models are not converted into the datatable-based models before updating to QPR ProcessAnalyzer 2020.8. If there are model conversions to be done, install QPR ProcessAnalyzer 2020.6 that can be used at the same time with QPR ProcessAnalyzer 2020.7 and make the conversions as described in the release notes for QPR ProcessAnalyzer 2020.7. After the conversion, update to QPR ProcessAnalyzer 2020.8 can be done (and QPR ProcessAnalyzer 2020.6 and 2020.7 be uninstalled). If you need help in converting your models, please contact customercare@qpr.com.
* D-14191: Running script by id failed on data import when parameters contained ScriptId.
</div>
* D-14183: Fixed issue where flowchart SVG export only exported the visible part of flowchart.


<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.5 (build 6769) (released 2024-06-27)==
The '''web.httpsOnly.config''' file included in the 2020.8 installation package is incorrect and it should not be used. If you need the web.httpsOnly.config file in your installation, please use the file available [[Web.HttpsOnly.config_for_2020.8|here]]. The issue has been fixed in the next release (build 113).
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer 2020.8 brings a change in the server Web.config file which need to be taken into account in the update. The change concerns section ''configuration'' > ''runtime'' > ''assemblyBinding'' > ''bindingRedirect'' for ''Newtonsoft.Json'', where the new line is '''<bindingRedirect oldVersion="0.0.0.0-11.0.0.0" newVersion="11.0.0.0" />'''.
</div>


'''Features:'''
'''Features:'''
* 307071: User management is available in the Web UI.
* 308038: Database tables related to the legacy model data structures are removed from the database.
* 308028: PAPO is changed to a component containing the Flowchart only that does not contain any other analyses.
* 308060: Web links can be defined for tables. Web links can be parametrized to contain information from the clicked row.
* 308068: Chart definition and preset improvements, e.g. Query analysis, Root causes analysis in tabular format, Case count trend by type.
* 308031: Server API: Web API for models.
* 308045: Server API: Version information to /api/serverinfo.
* 308050: Expression language: Template strings containing embedded expressions.
* 308056: Server API: Filters support for NumberPrecision/DatetimeTruncation/TimespanPrecision and StringifiedValues.
* 308062: Server API: The expression analysis, has a "criteria" property for filtering analysis results.
* 308069: Constant folding optimization for expression language.
* 307965: Expression language: New functions for handling dataframes.
* 308041: SendEmail function in expression language.
* 308049: Backend performance improvements for dashboards.
* 307910: Caching improvements: QueryIdentifier is not part of the cache key, and UserId is excluded from cache key when the expression is not user specific.
* 307806: Angular Web UI framework is updated to version 10.
* 308034: All 3rd party components in the Web UI are updated.
* 308059: Expression language: Modify scoping in user defined functions to correspond more with javascript (static/lexical) scoping.
* 307985: Create presentation object types for all HTML presentation objects used in system views - part 1.
* 308037&308055: QPRLibraries migration to Syncfusion JS2 - parts 2/3.
* 308043: Language translation has been updated.
* 308065: Restore feature: Model statistics (e.g. cases, events, event types) calculation has been improved. Now the statistics are not reset when model settings are changed, and case count shows only cases having events.


'''Fixed issues:'''
*B-08388: Added backend support for OCPM model perspectives to convert object-centric eventlogs into case-centric.
* 219241: Filter from ChartView is not confirmed when clicking Flowchart.
* 219507: X-AspNet-Version http response header has been removed from error responses.
* 219533: Dashboard gave randomly "Collection was modified, enumeration operation may not execute" error.
* 219540: Conformance analysis with incorrect BPMN model containing loops crashed server.
* 219349: When flow is selected in PAPO flowchart, event type filtering should not be possible.
* 219535: Empty strings in X-axis values show category index.
* 219554: When using lasso tool to filter in chart, y-axis position should be ignored in most chart types.
* 219558: Clustering and prediction doesn't take into account when there is one event type selected.
* 219221: Add many duplicate filters to same view should be prevented.
* 219534: It should not be possible to create filter rules without values selected.
* 219546: PA page content stays in very small area after reload page.
* 219555: Changing focus to other chart while selection is in progress creates invalid filter if clicked chart has chart filter.
* 219403: Improved error message texts for access denied errors.
* 219514: GET api/users/memberships/{id} should also return group's members.
* 219565: "No measure or dimensions have been defined" error in Conformance Root Check view.
* 219567: Typo in Chart Settings Presets.
* 219570: Color scale is inverted in Root causes for case duration preset.
* 219573: Event type filter component doesn't work.
 
== QPR ProcessAnalyzer 2020.7 (build 39) (released 2020-10-21) ==


'''Fixed issues:'''
'''Fixed issues:'''
* 308058: Roll back improvement of model statistics calculation (307988) which inadvertently changed the Excel client protocol.


== QPR ProcessAnalyzer 2020.7 (build 36) (released 2020-10-13) ==
*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).


'''Notes:'''
==QPR ProcessAnalyzer 2024.5 (build 6746) (released 2024-06-25)==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Known issue: QPR ProcessAnalyzer 2020.7.1 is not compatible with Excel Client 2020.7, even though the Excel Client protocol version hasn't changed. To resolve the issue, update Excel Client to 2020.7.1.
</div>


'''Features:'''
'''Features:'''
* 308036: Default values of chart margins have been adjusted, and there is a dashed line helping aligning charts.
*B-08338: Added reports to monitor dashboards usage: Popular dashboards, Dashboards by users and by time, and specific dashboard usage.
* 307988: Model statistics (e.g. cases, events, event types) calculation has been improved. Now the statistics are not reset when model settings are changed, and case count shows only cases having events.
*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.
* 307956: Backend support for dimension values rounding for numbers, datetimes and durations.
*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.
* 308040: Variation calculation performance has been improved.
*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 [[Generic_Properties_in_Expression_Language#OperationLog|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:'''
'''Fixed issues:'''
* 219518: Root cause analysis doesn't change after first analysis when comparison criteria is changed.
*D-14150: Charts temporarily showed as too large when resized with non-zero chart margin values.
* 219523: Analysis query fails when there are filter rules and model is not already in memory.
*D-14058: Login page is not anymore shown when SAML authentication is configured and user is directed to the identity provider.
* 219516: User description in Excel breaks web UI.
*D-11579: Column filter menu in tables can now appear outside the table area which is useful in small tables.
* 219527: Opening UI with a link containing sys:dashboard opens previously used model instead of model stored to dashboard.
*D-14144: Fixed issue where Snowflake clustering failed if there were date type of case attribute with null values.
* 219525: Filtering fails when first clicking chart and then PAPO flowchart.
*D-14163: Non-breaking spaces appeared strangely as "&amp;nbsp;" in Highcharts charts.
* 219510: Filter creation doesn't work from "Cases where specific events occur" dimension.
*D-14132: Snowflake model object counts were not shown when opening dashboard while model metadata was still loading.
* 219503: Flow duration gives "Index out of bounds" when selecting a flow that does not exist.
*D-14142: CreateDataTable function incorrectly deleted all source datatable content if connection included source datatable name.
* 219517: "Cases with specific case attribute value" measure doesn't take into account datatypes.
*D-14161: Fixed issue where Append function in SqlDataFrame broke source data.
* 219254: When other than traditional model has never been loaded, model statistics should return null in expression language.
*D-14157: AI Assistant didn't show detailed error message when OpenAI query failed.
* 219509: Event types is empty after ResetModelCache.
*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.
== QPR ProcessAnalyzer 2020.7 (build 12) (released 2020-09-29) ==
*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.
'''Notes:'''
*D-14008: "Root Causes contribution" and "Comparison eventlog cases percentage" columns didn't work (in-memory).
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 1em 1em;background-color:#ffcdd3;margin:10px 0px 0px 10px;">
*D-14010: Occurrences of specific flow measure didn't work with the Root causes analysis weighting expression (in-memory).
Support for the legacy models is dropped in QPR ProcessAnalyzer 2020.7, and the models need to be converted to the new datatable-based models before updating to QPR ProcessAnalyzer 2020.7. You can check the model type as follows: Open QPR ProcessAnalyzer Web UI, open the models dropdown list in the header, find the model, open ''Properties'' for the model, and go to the ''Datasources'' tab. If the ''Load from Database'' is ''yes'', the model is a legacy model and requires conversion.
*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.
The conversion can be done as follows:
*D-14153: Fixed in-memory measures for "Flow duration" and "Occurrences of specific flow" which failed when selected flow didn't exist.
# In QPR ProcessAnalyzer Web UI, export the model as a .pacm file by clicking ''Export Model'' in the ''Model Properties'' (in the ''Actions'' tab).
*D-14167: Fixed issue where ScriptLauncher sometimes terminated prematurely on exceptions occurring in on-premise import.
# Go to the ''Datasources'' tab, change the ''Load from Database'' from ''Yes'' to ''No'', and change the ''Cases'' ''Datasource'' to ''Datatable''. The ''Events'' ''Datasource'' is already correct.
*D-14165: Flowchart export file name was incorrect and exported flowchart background was always transparent.
# Import the .pacm file back to the same model using the ''Data Import'' in the navigation menu. In the import form, select ''Import to Existing'' model and choose the model. Checkbox ''Add to existing data'' can be in either position.
*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.
Notes regarding the conversion:
* D-14131: Some popup messages had incorrect html escaping.
* Exporting and importing operations might take long time for very large models.
*D-14151: Fixed issue where flowchart might have given browser console error when clicking event types or flows while still loading data.
* Model id's are not changed in the conversion.
* D-14022: In System reports, numeric aggregations which don't work in SQL Server are now hidden.
* Original filters and their id's are preserved but new duplicate filters are created during the import (which can be deleted).
*D-14129: Imported model name was incorrectly cut if it contained dots.
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer server installation has some files removed comparing to the previous version, because the WCF tester legacy functionality has been removed. Please note this, if updating the server by replacing the old files, because the files that need to be removed don't actually get removed with that method. The files to be removed are ''default.aspx'', ''favicon.ico'' and ''processanalyzer.png'' and folder ''scripts''.
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
[[QPR_ProcessAnalyzer_Version_Compatibility|Excel Client protocol version]] is changed which requires to update QPR ProcessAnalyzer Excel Client when updating to QPR ProcessAnalyzer 2020.7. See more how to [[Installing_QPR_ProcessAnalyzer_Excel_Client#Installing_QPR_ProcessAnalyzer_Excel_Client|update Excel Client]].
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
==QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14)==
The version numbering of QPR ProcessAnalyzer has changed, and now releases are identified using a simple version number instead of the previous version format (e.g. 2020.6.0.42152). The version number can be seen in the ''User Settings'' in the main navigation menu.
</div>


'''Features:'''
'''Features:'''
* 308003: Filter rules can be turned off.
*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.
* 308021: Dimension specific maximum number of items can be defined.
*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]])
* 308006: KPI card has customizable colors.
*B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
* 308009: Dimension values can be mapped to colors for visualization.
*B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
* 308008: Chart specific model selection.
*B-08276: Adjusted permissions for [[Roles_and_Permissions#Project_Permissions|moving projects]].
* 308017: Remove left and right axis synchronization in Chart.
*B-08310: Added Details property to [[Generic_Objects_in_Expression_Language#Exception|Exception object]] in expression language.
* 307995: Ending tasks in web UI.
*B-08328: Language translations have been updated to 2024.4.
* 307987: Navigation menu width is set based on dashboard names.
*B-08312: Frontend components have been updated.
* 307993: Model size estimate is decreased by 20 %.
*B-08308: Backend components have been updated.
* 308018: Bottleneck identification and optimizations for models having lots of cases.
* 307994: Taken into use functions stdev, stdevp, var and varp in Chart.
* 308016: Migrate Chart pivot to Syncfusion JS2 PivotTable.
* 307805: Syncfusion JS2 migration - part 1.
* 308025: Chart components migration to Syncfusion JS2 (part 1).
* 307939: Remove manually updated version numbers.
* 308005: Remove "Dimensions/columns as calculated attributes" and "Chart settings (compacted)" from chart.
* 307999: Remove legacy model settings from model properties.
* 308020: Change default bpmn model to empty.
* 307758: Standard deviation, sample standard deviation, variance and sample variance to expression language.
* 307976: Angular migration finalization.
* 307992: In Conformance root causes view, replace datagrid with a chart.
* 307759: Add requirements and tests to mathematical functions from NCalc.
* 307879: Optimize preprocessing for model event log.
* 307916&308010: Drop support for legacy models.
* 308007: "On-screen settings follow flow selection" to work for all start and event event type selections.
* 308030: Change password changing to use /api/users/password.
* 307989: Expression language: Dictionary.Clone-function and improvement to generic ToDictionary and ToDataFrame functions.
* 308029: Revision number in UI.
* 308004: Expression designer results field should be editable.
* 307996&308012: Translation fixes.
* 307954: Web API for datatables.


'''Fixed issues:'''
'''Fixed issues:'''
* 219429: Chart case attribute dropdown list item count did not match with the chart presentation.
*D-14084: Filter rule for first and last event in case couldn't be edited if there were more than one event selected.
* 219487: When moving and resizing, presentation objects should be aligned with each other and with the canvas.
*D-14091: Duration multi-unit didn't work in big data chart.
* 219472: Improvements to model and data table loading slowness and memory usage.
*D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
* 219465: "Case/event attribute not found" error messages improved.
*D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
* 219474: Filter rule text said "undefined" for some expression based filters.
*D-14107: Snowflake model that has earlier been an in-memory model showed case count and estimated memory incorrectly.
* 219462: User could not fix incorrect chart settings.
*D-14074: Fixed issue in QPR ScriptLauncher when calling the script from other script.
* 219471: "All cases" option was not visible when changing between models that don't have filters.
*D-14104: Fixed expression language parsing issue with in-memory DataFrame and filter using "In" function.
* 219488: Filter selection should be cancelled when changing dashboard.
* D-14121: Datatable UpdateRows function now supports column names given as expressions.
* 219494: Duration values in flowchart were sometimes rounded incorrectly.
* D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
* 219484: Alignment of dashboard objects was difficult.
* 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.
* 219502: When clicking same Case attribute/Event attribute preset again, loading animation staid for ever.
*D-14128: Table without title was incorrectly exported as .txt file.
* 219481: Stdev, stdevp, var and varp functions should return null when there are zero or one items in the array.
*D-14112: Convert to custom expression button didn't work in design diagram.
* 219496: Series should be stacked bottom-to-top and from-left-to-right in charts.
*D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
* 219499: Chart colors were reset to default when resizing window.
*D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed in chart settings.
* 219480: Attribute+Variation filter resulted in zero cases.
*D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
* 219479: SAML login redirection replaces contains http even if https is configured.
*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 2020.6 (released 2020-08-18) ==  
==QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)==
Build number: 2020.6.0.42152, Model compatibility version: 3, Database version: 74, PACM file version: 7, Protocol version: 33. ([[QPR_ProcessAnalyzer_Version_Compatibility|see more]])


'''Features:'''
'''Features:'''
* 307918: Localization for Russian, Spanish, German, Finnish and Swedish.
* B-08024: [[Design_Diagram|Design diagram]] has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
* 307921: New dashboard Preview mode is separated from the Edit mode, to be able to temporarily change chart settings without saving them to the dashboard.  
*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.
* 307982: Changes to showing model last imported date and additional information to Model Properties dialog.
*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.
* 307983: Editing calculated case and event attributes.
*B-08288: Added expression language functions to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Start|start and stop]] scripts.
* 307980: Chart setting "On-screen Settings Follow Flow Selection" to freeze chart from reacting to flow selection.
*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.
* 307824: Expression language function improvements (IndexOf, LastIndexOf, ToString, ParseDateTime, First, Last).
*B-07906: Implemented cross joins to SQL dataframes.
* 307952: When loading model data, the order of events inside cases is primarily based on the timestamp and secondarily by event row number.
*B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
* 307953: Querying model-datatable linking in expression language.
*B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
* 307817: User management operations to Web API.
*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.
* 307900: Memory consumption improvement for getting number of unique attribute values.
*B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
* 307978: Performance improvement: Taken into use AttributeType.UniqueCount to replace Count(_.Values) in expression used by UI.
*B-03047: Removed support for dashboard panels.
* 307781: ProjectId property is removed from dashboard export files.
* B-08214: Removed unused columns from the PA_VIEW table.
* 307955: Dataframes are loaded in parallel.
*B-08254: Frontend components have been updated.
* 307934: AsParallel function implementation has been finalized.
*B-08255: Backend components have been updated.
* B-08233: Language translations have been updated to 2024.3.


'''Fixed issues:'''
'''Fixed issues:'''
* 219388: Old data comes to dashboard when data imported to datatable.
*D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
* 219412: No scrollbar for both error message and web UI window.
*D-14035: In design diagram, BPMN event and gateway symbols are now circular.
* 219414: Error message appears in Clustering Analysis for model with zero events and cases.
*D-14049: Added some missing translations for table column filter and BPMN editor.
* 219419: QueryIdentifier should be excluded from client side query cache.
*D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
* 219426: Script editor cannot save changes in 2020.5 version.
*D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
* 219430: Filtering does not work in PAPO Cases and Event Types when using French.
*D-13976: Fixed issue where gateway-based imports were not synchronous.
* 219431: PAPO Events and Root Causes not working when using French.
*D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
* 219435: Dialogues have small layout issue.
*D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
* 219441: Deletion does not work correctly in folders screen when selecting using shift+ctrl-click.
*D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
* 219160: Hidden case attributes are visible in profiling case analysis, and in Influence Analysis for case attributes settings.
*D-14071: Business calendar button press caused error when user didn't have access to any model.
* 219418: Missing translations for the Clustering analysis.
*D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
* 219446: JavaScript error when closing dialog using the X button.
*D-11268: There were inconsistent button colors in Workspace.
* 219444: Deselecting selected item by re-clicking it will not hide the selection buttons in Chart and generates an error in browser console
*D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
* 219449: Prediction fails with certain small models.
*D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
* 219450: Evaluation stack is not generated correctly if an exception occurs while inside a function having no parameters.
*D-14081: Fixed null references error when logging null in expression script.
* 219456: Query cache is not cleared when model settings are changed.


== QPR ProcessAnalyzer 2020.5 (released 2020-06-29) ==  
==Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)==
Build number: 2020.5.0.41888, Model compatibility version: 3, Database version: 73, PACM file version: 7, Protocol version: 33. ([[QPR_ProcessAnalyzer_Version_Compatibility|see more]])
 
'''Notes:'''
* Dashboards structure is simplified, as panels are removed and presentation objects are placed directly to the dashboard canvas. In addition, panel headers are not available anymore. Presentation objects have now background color, border color, border width and border corner radius, that were previously in the panel level. All existing dashboards are automatically migrated to the newer structure. Existing dashboards that have several presentation objects within a same panel, are positioned on top of the others, so in those cases presentation objects need to be repositioned manually after updating to QPR ProcessAnalyzer 2020.5.
* IP address verification of user sessions has been removed. Previously, each user session was only allowed from the same IP address. This kind of security feature won't work with IPv6 addresses which usually change more often than IPv4 addresses.


'''Features:'''
'''Features:'''
* 307938: Support for French language.
* 307868: New dashboard designer that doesn't have panels.
* 307947: Tables conditional formatting
* 307948: Dashboard properties layout and terminology changes.
* 307911: IP address verification has been removed.
* 307931: Expression language and performance improvements (originated from Spark prototyping).
* 307774: Web API operation /api/importfile for data import.
* 307933: Default logging mode has been changed to ExclusiveLock for all components.
* 307904: Server side support for UI languages.


'''Fixed issues:'''
*B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.
* 219372: Issue with simultaneous eventlog processing that caused "Value cannot be null" errors and sometimes calculation with incorrect eventlogs.
* 219375: --#CallWebService didn't work with Content-Type parameter.
* 219357: UI was stuck to IdP login page when SAML settings (e.g SAMLUserIdAttribute) were misconfigured.
* 219391: After logout GetOperationProgress failed for validating session.
* 219408: Removed focus outline border from buttons and textboxes.
* 219398: ETL Access denied CheckIsInProjectContext.
* 219373: Case.FlowOccurrences and Case.FlowOccurrencesByType have Variations preprocessing missing.
* 219382: Query for open operations should not return "open" operations that were started before the server startup time.
* 219402: Model with LoadOnStartup=true doesn't work with case level permission with expressions referring to current user.
* 219409: Filters containing event type and variation rules always filter out all cases.
* 219416: Error in model loading in startup can effect other model loading.
* 219369: Change error message "Time out while waiting for server response.".
* 219387: Text filter options opened to left for ChartView making them partly hidden for first column.
* 219395: Save button not always enabled when editing dashboard.
* 219396: Context change notification should not be called for closing dashboard charts.
* 219411: Right click menu issue in PA Flowchart analysis view.


== QPR ProcessAnalyzer 2020.4 (released 2020-05-26) ==
'''Fixed issues:'''
Build number: 2020.4.0.41643, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33. ([[QPR_ProcessAnalyzer_Version_Compatibility|see more]])


'''Notes:'''
*D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.
* In QPR ProcessAnalyzer 2020.4, the deployment package dashboards come with the installation, so there is no deployment package anymore to be installed. The previous deployment package located in the ''QPR ProcessAnalyzer UI'' project can be deleted when 2020.4 is installed.
* To fix issue ''Datetimes are incorrect in files exported from data grids'' (219377), [[Data Grid Export Service|data grid export service]] needs to be updated from version V001 to V002.
* Issue workaround: After updating to QPR ProcessAnalyzer 2020.4, dashboards containing the root causes analysis give an error message about invalid chart configuration. The problem can be fixed as follows: from the JSON text that appears in the full screen text editor, make the following text replacements: "Case Attribute" --> "Case attribute" and "Attribute Value" --> "Attribute value". When the dashboard is saved, the error doesn't appear anymore.
* To improve performance, for custom expressions in charts it's recommended to replace ''??_remove'' with the [[Generic_Functions_in_QPR_ProcessAnalyzer#RemoveNulls|RemoveNulls]] function. Example: Expression ''Average((_.Attribute("Cost") ??_remove)._)'' can be changed to ''Average(RemoveNulls(_.Attribute("Cost")))''.
* To improve performance, for custom expressions in charts it's recommended to change expressions that make duration aggregations to work in a way that the aggregation is made before converting TimeSpans to integers (e.g. to days). Example: expression ''Average(_.Duration.TotalDays)'' can be changed to ''Average(_.Duration).TotalDays''.
* Issue: In Firefox, when opening a dashboard, an error message "Error in chart settings" might appear (the dashboard is still opened correctly). If the issue appears, it's recommended to use Chrome, where the issue does not appear that often. There are no other workarounds available for the issue.
* Issue: FlowOccurrences and FlowOccurrencesByType properties don't work for Case objects when there are also filter rules applied. Some measures and dimensions use those properties. QPR ProcessAnalyzer 2020.5 will fix the issue, and for earlier versions there is no workaround.  


'''Features:'''
==QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)==
* 307859: Deployment package dashboards are embedded to QPR ProcessAnalyzer release.
* 307899: RemoveNulls function to remove null values from arrays.
* 307915: Expression language improvements related to CSV file generation.
* 307809: When dashboard is opened, editing mode is disabled when no rights to edit the dashboard.
* 307829: Highcharts, Syncfusion, GoJS and some other components have been updated to their latest versions.
* 307848: Component updates for building QPR ProcessAnalyzer UI.
* 307882: JavaScript libraries are split into smaller files in release build.
* 307932: Some PAPO buttons are removed from the tool palette.
* 307912&307917: ChartView and main header improvements for 2020.4 (parts 1 and 2).


'''Fixed bugs:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219365: Sometimes system stuck during the time models were being loaded into memory.
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.
* 219326&219377: Datetimes are incorrect in files exported from data grids (time zone difference) (See also the notes above).
</div>
* 219378: ChartView resizing sometimes didn't work when using full screen.
* 219371: Error messages have been improved for session expired and unknown error.
* 219360: Some styles were defined twice in CSS.


== Additional release for QPR ProcessAnalyzer 2020.3 (released 2020-04-23) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2020.3.0.41450, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
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>


'''Features''':
'''Features:'''  
* 307902 ChartView improvements for 2020.3 hotfix: Custom expressions have by default datatype "auto", added support for binding to multi-select lists in Variable bindings, bugfix: Custom sorting didn't work in presets, bugfix: Aggregation method for Pivot table was not selected correctly.
*B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
*B-08232: Entire future eventlogs can be [[Create_Predicted_Eventlog|predicted]] based on generative AI models running in Snowflake.
*B-08166: Added expression language function [[Generic_Functions_in_QPR_ProcessAnalyzer#OpenAIChatCompletion|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 [[QPR_ProcessAnalyzer_Table#Textual_equal_rules_for_background_color|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 [[Storing_Secrets_for_Scripts|secrets]] for scripts.
*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-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 bugs:'''
'''Fixed issues:'''
* 219370: Dashboards could not be edited by other than administrators.
*D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
* 219361: Flowchart sometimes crashed to ThrowKeyNotFoundException when pressing Root Causes button.
*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 2020.3 (released 2020-04-16) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2020.3.0.41413, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
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.
</div>


'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* Legacy Chart and Gauge presentation objects are removed from QPR ProcessAnalyzer (they are different than ChartView). If there are dashboards containing those types of presentation objects after updating to 2020.3, there will be a placeholder frame instead with an error message of a non-existing presentation object. To change the dashboard, remove those placeholders and replace with ChartViews. It's recommended to make the replacement to ChartViews before the update, because chart and gauge settings cannot be accessed anymore in 2020.3.
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.
* ChartView will change from an HTML presentation object to a native presentation object, which ensures that dashboards will work in future releases when the ChartView is evolving. ChartViews created with 2020.2 will be automatically migrated to the native ChartViews in 2020.3. ChartViews created with 2020.1 or earlier releases need to be updated manually by removing the ChartView from the dashboard and replacing it with a new ChartView.
</div>


'''Features:'''
'''Features:'''
* 307849: Securely stored strings for passwords.
*B-08019: New component [[Design Diagram]] for showing user-created diagrams in dashboards where to visualize process mining metrics.
* 307746: ChartView is now a native presentation object instead of an HTML presentation object. ChartView's made in 2020.2 are automatically converted to the native presentation objects.
*B-08087: Generic [[Dropdown_List_Selector|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* 307880: When a datatable model is moved to another project, the linked datatables should also be moved to the project.
* 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]].
* 307556: Functions to expression language to improve usability and performance: CaseCount, EventCount, EventCountByType and Round.
*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.
* 307895: SQL scripting command for database commit.
*B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
* 307850: Expression language performance improvement by a new way to calling functions and properties.
*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.
* 307858: Expression language: Support for array operators.
*B-08122: Added new system report to list dashboards.
* 307845: Header buttons layout has been improved.
*B-08173: Removed legacy filters that didn't have any filter rules.
* 307870: Preprocessings are determined automatically.
*B-07961: In OperationLog, changed parameters to json format and added request id.
* 307761: Functionality that user doesn't have access is now disabled in the dashboard designer and workspace to avoid access denied errors.
*B-08069: Added DashboardId property to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* 307839: Generic chart and gauge presentation objects are removed.
*B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* 307863: Automatic redirection to SAML authentication.
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|DeleteRows]] function to delete rows in datatables with similar logic than SQL delete.
* 307872: API support for querying if SAML is configured.
*B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
* 307846: Error message further improvements.
*B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
* 307888: Error message text changes for Dashboard not found and Multiple dashboards found.
*B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
* 307874 & 307887: ChartView and main header has been improved.
* B-07689: For datatables, [[Datatable_in_Expression_Language#ForeignKeys|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 bugs:'''
'''Fixed issues:'''
* 219341: Analysis function unnecessarily required FilterId parameter.
* D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* 219343: Root causes analysis gave access denied when using Analysis function.
*D-13916: Chart filter could not be defined for some expressions in Big data chart.
* 219348: Query cancellation caused database connection leakage.
*D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
* 219332: "Thread was being aborted" returned to client while loading model from datatable.
*D-13906: In Conformance Analysis, deviating flows were not translated.
* 219321: Removed unnecessary error log lines "Missing expected HttpRequest X-Forwarded-For" that appeared even if UseXForwardedForAsClientIp=false.
*D-13907: Improved translation related to datatable properties dialog "Used by models" field.
* 219335: [_remove ]._ or empty array is not handled correctly in a KPI dimension.
*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.
* 219340: default.aspx does not work.
* D-13911: Fixed small glitches in the opening and closing of drop-down lists.
* 219330: EditDashboards permission should be needed for target project when moving dashboards between projects.
*D-13918: Datatable could be configured incorrectly to use table for other datatable.
* 219347: Queries done by the main header were cancelled when view is changed.
*D-13932: Duplicating datatable with custom table in datasource losed all data.
* 219355: Expression language: Was unable to use properties of the parent context in dictionary initialization.
* D-11002: Removed legacy in-memory prediction preset.
* 219346: PAPO flowchart should have by default median duration shown on flows and flow counts hidden.
*D-13912: Added check that array cannot be stored to dashboard Content property.
* 219333: PAPO generated incorrect filter JSON and unnecessary query.
*D-13936: Query designer default query didn't work with Snowflake models.
* 219311: When opened a view by identifier, the view was fetched twice from the server.
*D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
* 219329: Unnecessary information was stored in database for dashboard definitions.
*D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
* 219362: Issues with session expiration checks.
*D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
* 219364: Session expiration with SAML authentication configured gives incorrect error message.
*D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.
* 219344: Case count view in model manager header and Home view can cause unwanted model loading.
* 219242: Flowchart is not updated correctly after event type filtering.


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


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

Latest revision as of 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"