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 about 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.7 (planned release date 2021-09-21) ==
== Next Release: QPR ProcessAnalyzer 2024.4 (planned release date 2024-05-14) ==
'''Notes:'''
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer is now a fully web browser based software, and thus QPR ProcessAnalyzer Excel Client is not released anymore. If you have any issues in switching over to the web UI, please give us feedback through customercare@qpr.com and describe your process mining use case.
</div>


'''Features:'''
'''Features:'''
* B-05991: Models can be managed in the [[QPR_ProcessAnalyzer_Project_Workspace#Models|Workspace]] in a new tab.
* B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
* B-06212: [[Image|Images]] can be added to dashboards.
* B-05926: Presets performance can be [[Navigation_Menu#Benchmark_Performance|benchmarked]] with one click and results report can be export.
* B-06230: When duplicating elements in dashboards, now the width and height of duplicate stays same.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11188: CSV file import didn't work with negative numbers.
* D-14084: Filter rule for first/last event in case couldn't be edited if there were more than one event selected.
* D-11210: In boxplot presets, "no outliers" minimum/maximum might incorrectly have been lower/greater than the real minimum/maximum.
* D-14091: Duration multi-unit didn't work in big data chart.
* D-11183: Chart datalabels showed wrong numbers for some presets.
* D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
* D-11175: Single select list was not updated when value was set from multi select list through variable.
* D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
* D-11161: Font was broken in the contextual popup menu.
* D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed.
* D-11165: Dropdown list values were not updated when changing preset.
* D-14096: Highcharts tooltip square icons were slightly misaliged.
* D-11177: Data grid excel filter item selection unselected checkbox layout was incorrect.
* D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
* D-11184: Unclear error information when tried to feed string value to Highcharts when value should be numerical.
* D-14099: There was a console warnings when opening the business calendar dialog.
* D-11189: Nothing happened when clicking Delete dimension when there were no dimensions.
* D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
* D-11166: All text type filter should have "Not Contains" option.
* D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
* D-11185: Filtering didn't work for charts using variables in columns and row initialization expressions.
* D-14107: Snowflake model that has earlier been in-memory model showed case count and estimated memory incorrectly.
* D-11190: When deleting or modifying expressions, non-matching on-screen settings are now removed to avoid errors.
* D-11207: Javascript error "RangeError: Maximum call stack size exceeded" when clicked empty data grid rows area in Notifications and Business calendar.
* D-11208: When very small percentage of cases are shown, the header showed ".00" (now it shows ≈0%).
* D-11203: Removing parameters from url went to login page without clearing session and showed unnecessary error message.
* D-11138: Javascript error in console: "Cannot read property 'column' of undefined at Gs.cellSelecting".
* D-11200: Unselecting selected cell in table didn't hide the suggested filter.
* D-11215: There was a javascript error when selecting a range of two or more cells in the same line and then click any cell.
* D-11155: Caching is now disabled when switching between tabs in Workspace.


== Latest Release: Additional release for QPR ProcessAnalyzer 2021.6 (build 474) (released 2021-08-25) ==
== Latest Release: QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04) ==
'''Notes:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
There is a change in the expression language behavior, as now existing variables cannot be reinitialized using the '''let''' operator. Thus, an error is given, if there is already a variable with the same name in the same scope. The new behavior reflects better how programming languages usually work, and also it's able to spot likely bugs in expression scripts.
</div>


'''Features:'''
'''Features:'''
* B-06245: Performance issue: Separate eventlogs were sometimes still created when drilling down in dashboards.
* B-08024: [[Design_Diagram|Design diagram]] has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
* B-05937: Trying to initialize existing variable in the same scope gives now error.
* B-08242: Script based [[Actions_to_Run_Script_in_Table|actions]] can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
* B-03091: Columns of the datatables stored to SQL Server use now specific data types instead of SQLVARIANT.
* 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-06205: Frontend 3rd party components have been updated.
* B-08288: Added expression language functions to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Start|start and stop]] scripts.
* B-06021: Server logging has been improvement.
* 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:'''
'''Fixed issues:'''
* D-11094: In datatable import dialog, emptying datatable column name field didn't take effect.
* D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
* D-11159: In chart, opening datatables list in "Datatable contents" gave error.
* D-14035: In design diagram, BPMN event and gateway symbols are now circular.
* D-11056: Table sorting using context menu didn't work.
* D-14049: Added some missing translations for table column filter and BPMN editor.
* D-11157: "Not contains" filter didn't work and rule didn't show any text in header.
* D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
* D-11158: There was an incorrect html encoding in multiselect list label.
* D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
* D-09506: In pivot table, export created incorrect Excel file from zero values.
* D-13976: Fixed issue where gateway-based imports were not synchronous.
* D-11078: In pivot table, selection caused javascript error when mouse was released over cell value.
* D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
* D-11147: For json type of error responses Content-Type should be "application/json; charset=utf-8".
* 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 2021.6 (build 460) (released 2021-08-19) ==
== Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27) ==
'''Features:'''
* B-06211: Performance improvement: Reuse event objects in all eventlogs of the model (event level calculation performance is doubled).
 
'''Fixed issues:'''
* D-11146: Filter calculation on dashboards using large model with several charts slowed down due to unnecessary duplicate eventlog generation.
* D-11145: "Not contains" option was missing from Excel filter sub menu, and filter type was not filled automatically in Custom filter dialog.
* D-11121: There was an unclear error message "Conformance statistics cannot be calculated" in Conformance statistics component.
* D-11152: There was an unnecessary separator in projects menu in models list.
* D-11150: There was a date conversion issue in CSV import related to number parts with leading zeros.
* D-11119: DataGrid Excel export didn't work with the "substitute character".
* D-11129: Case nonconformancies root tried to declare variables twice.
* D-11151: Some number conversions were incorrect in CSV import.
* D-11153: Decimal separator could not be specified for duration type of columns in the CSV import.
* D-11154: Client side validation didn't work for duplicate user and group names.
 
== QPR ProcessAnalyzer 2021.6 (build 444) (released 2021-08-10) ==


'''Features:'''
'''Features:'''
* B-05859: CSV file import is renewed and available in the Workspace (old import is still available).
* B-05988: Charts can be duplicated when editing 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-05982: Workspace context menu improvements.
* B-05950: Allow empty value in first column in CSV file import.
* B-05860: Frontend component update (part 2).


'''Fixed issues:'''
* B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.
* 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.
 
== QPR ProcessAnalyzer 2021.5 (build 389) (released 2021-06-23) ==
 
'''Features:'''
* B-05846: Datatable contents can be previewed, and also new system reports dialog.
* B-03233: Improved UI for chart background color, border color, border width and border corner radius.
* B-05852: New presets for intelligent process automation and boxplot visualizations.
* B-05828: Actions for tables to change dashboard variables.
* B-05853: Scripting supports also scripts written in the expression language.
* B-05093: Workspace visual layout has been improved and context menu is available also for projects, dashboards and datatables.
* 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-11085: Tooltip in chart settings were stuck open in some occasions.
* D-09524: Polar chart showed wrong tooltips value and graph was shown incorrectly if polar chart disabled and enabled again.
* D-11007: Workspace grid showed shortly incorrect content.
* D-11030: Javascript error: "TypeError: Cannot read property 'length' of null" when returning to workspace.
* D-11042: Release package was much larger for 2021.4 than for earlier releases due to unnecessary Monaco editor files.
* D-11051: Negative timespans returned by server don't work in UI.
* D-11052: Number of cases not updated when removing ModelId from dashboard properties.
* D-11054: Background color conditional formatting didn't work for non-numerical columns.
* D-11055: Extra space appeared in header when changing model and opening filters list.
* D-11058: Expression filters didn't work due to single quotes don't work anymore.
* D-11059: On-the-fly migration for existing stored expression filter rules using single quotes.
* D-11068: When zooming and moving flowchart, following console error appeared: TypeError: Cannot read property 'behavior' of undefined.
* D-11073: Chart image export should have same scale as in the dashboard.
* 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) ==


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


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
== QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21) ==
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.
</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).
Known issue: Snowflake models and dashboards don't work with Viewer and Analyzer role permisions. The reason is that cache tables created to Snowflake incorrectly require the write permissions. Workaround is to give users the Designer role which will give the needed permissions. Note that the Designer role gives many permissions to the user for the project [[Roles_and_Permissions#Roles_and_Permissions|(more information)]]. This issue has been fixed in the next release (D-14045).
</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/.
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.
</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).
New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).
</div>
</div>
<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.
</div>
'''Features:'''
* B-03297: Scripting is available in the web UI.
* B-03231: Recycle bin for models and projects is available in the web UI.
* B-05764: Table component in dashboards has been upgraded to newer generation of Syncfusion JS2.
* B-05814: There are now default parameter values for most preset.
* B-05812: Optimize "Automation opportunity scout" preset and remove root items duplicate removal from dimensioning
* B-05769&B-03081: "Cost Savings by Automation" preset performance has been improved.
* B-05745: Functions CaseByName and Reverse, and improved support for TimespanPrecision/DatetimeTruncation.
* B-05750: Expression language functions for managing datatables.
* B-05800: Improvements to SQL script log writing.
* B-05083: Expression language scripting.
* B-05789: Expression language scripting: Run expression language scripts using Run function.
* B-05799: Expression language scripting: Run SQL scripts using Run function.
* B-05752: Delete multiple items at the same time: Recyclebin.DeletePermanently().
* B-05082: Distributed computing, part 5: Improving KPI analysis expressions and data import.
* B-05762: Distributed computing, part 6: Improvements related to imports to external distributed computing systems
* 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:'''
* B-03242: Sampling for the analyzed objects of the chart.
* B-03239: Chart settings visual improvement and reorganization (migration to Syncfusion JS2).
* B-03307: Miscellaneous improvements to Workspace.
* B-03075: Models are kept in memory when settings are changed (excluding datasources and calculated attributes).
* B-03079: Improvements to model JSON configuration for Case/EventAttributes.
* B-03308: In Query Designer, ContextType should be "Model", when ProcessingMethod is "DataFrame".
* B-05075: Script entities are accessible in the expression language.
* B-03302: Scripting backend changes: Single state for scripts.
* B-05079: API for creating and editing scripts.
* B-05074: Frontend components update.
* B-05077: Support for scripts in POST /api/uielements/setproject/{projectid} and DELETE /qprpa/api/uielements.
* B-03296: API for recycle bin.
* B-03315: Distributed computing: Streamlining dataframe based KPI analysis configurations.
'''Fixed issues:'''
* 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:'''
'''Features:'''
* 308096: New function "EventLog" to expression language to explicitly define preprocessings.
* 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 issues:'''
'''Fixed issues:'''
* 219612: Opening models dropdown list jammed UI when there are lot of models.
* D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
* 219495: Improve error message when trying to change login name to already existing.
* 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 2021.1 (build 156) (released 2021-01-12) ==
== QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10) ==


'''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.
Known issue fixed in QPR ProcessAnalyzer 2024.2: In Big data chart, some measures, dimensions and columns have the filtering option missing. The issue concerns for example Duration between events, Path starting/until between specific events, and Cases where event occurs before other selections. Workaround is to set the filter in the chart json settings: the filter can be configured to another expression and copied to the correct expression.
</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.
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>
</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.
In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.
</div>
</div>


'''Features:'''
'''Features:'''
* 308075: Chart data point colors can be defined using [[QPR_ProcessAnalyzer_Graphs#Conditional_Formatting|conditional formatting]].
* B-08019: New component [[Design_Diagram|Design Diagram]] for showing user-created diagrams in dashboards where to visualize process mining metrics.
* 307816: Datatables to workspace (part 1).
* B-08087: Generic [[Dropdown_List_Selector|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* 308076: QPRLibraries migration to Syncfusion JS2 (part 4).
* 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]].
* 308086: Syncfusion JS2 update.
* 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.
* 307975: Data grid presentation objects and datasets have been removed.
* B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
* 307974: Remove HTML presentation objects have been removed.
* 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.
* 308073: Create presentation object types for all HTML presentation objects used in system views - part 2.
* B-08122: Added new system report to list dashboards.
* 308077: Translation updates for PA release 2021.1.
* B-08173: Removed legacy filters that didn't have any filter rules.
* 307652: Remove QPR Connector.
* B-07961: In OperationLog, changed parameters to json format and added request id.
* 307709: Remove most of Excel client functionality and support of Xpress.
* B-08069: Added DashboardId property to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* 308039: Web API for terminating operations.
* B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* 308046: Web API for copying datatable.
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|DeleteRows]] function to delete rows in datatables with similar logic than SQL delete.
* 308051: [[Importing_Data_from_SAP|Data type conversions]] have been improved for SAP import.
* B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
* 308105: Copyright information update to 2021.
* B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
* 308063: SmtpFromAddress setting for sending email.
* B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
* 307368 & 308084: Business calendar for duration calculation.
* B-07689: For datatables, [[Datatable_in_Expression_Language#ForeignKeys|foreign keys]] to other datatables can be defined using expression language.
* 307565: Expression filter rule improvements for comparing numerical values.
* B-08176: Translation updates for release 2024.1.
* 307990: Email notifications part 1.
* B-08175: Workspace should show timestamps in user's local time.
* 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-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* 219590: UI got frozen when opening workspace from home view if no other system view opened just before.
* D-13916: Chart filter could not be defined for some expressions in Big data chart.
* 219595: Long words were not wrapped in message dialog.
* D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
* 219519: Error message did not show clear enough information.
* D-13906: In Conformance Analysis, deviating flows were not translated.
* 219557: Root causes analysis is changed to take into account summary row column count.
* D-13907: Improved translation related to datatable properties dialog "Used by models" field.
* 219592: Excel client installer did not contain all connector files.
* 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.
* 219600: Confirmation message is improved when deleting project.
* D-13911: Fixed small glitches in the opening and closing of drop-down lists.
* 219607: Dashboards don't work with bpmn models having linebreaks.
* D-13918: Datatable could be configured incorrectly to use table for other datatable.
* 219604: Special characters do not work correctly in chart settings.
* D-13932: Duplicating datatable with custom table in datasource losed all data.
* 219606: Using dashboard links sometimes causes an error message to popup.
* D-11002: Removed legacy in-memory prediction preset.
* 219608: Conformance statistics po tooltip in tool palette is incorrect.
* D-13912: Added check that array cannot be stored to dashboard Content property.
* 219593: Getting data tables is really slow and the query times out after 30 seconds.
* D-13936: Query designer default query didn't work with Snowflake models.
* 219582: ScriptLauncher not work in direct database mode.
* D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
* 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-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
* 219544: Inconsistent # Cases Total when running an analysis.
* D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
* 219539: Excessively large amount of data added into expression language exception messages.
* D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.
* 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) ==
== QPR ProcessAnalyzer 2023.7 (build 4326) (released 2023-11-28) ==


'''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;">
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.
Limitation for the maximum amount of data (B-07636) causes a behavior change in in-memory charts that have the Maximum rows settings empty and have the sorting defined. In certain cases, the order in which measures are evaluated changes (due to an internal performance optimization). If there are custom expressions that define variables, the variables may not be available in other measures anymore. As a resolution, either redefine the variables in those measure expressions or add those measures secondarily to the sorting.
</div>
</div>


'''Features:'''
* 308061: QPR ProcessAnalyzer version related detailed information is shown User settings.
* 308067: Charts have performance benchmarking to measure the time taken to calculate a chart.
* 308042: Dashboard layout logic has been changed in a way that the possible empty space is preserved when viewing dashboards.
* 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.
* 308079: New parameter OperationId is added to operation log.
'''Fixed issues:'''
* 219585: Showing models list blocks until model loadings have been completed.
* 217940: PAPO flowchart scroll position was incorrectly on the very left.
* 219564: Duplicate of dropdown list contents appears in wrong place when opening dynamic single selected list after changing model.
* 219511: Scheduled loading of datatables caused the server to run out of memory.
* 219591: Using Web.HttpsOnly.config caused HTTP Error 500.19 - Duplicate connection cache-control.
* 219586: Previous modifications to Web.config are also done to Web.HttpOnly.config.
* 219566: Settings panel cannot be opened for flowchart.
* 219569: Conformance check view has "Cannot read property min of undefined" JavaScript error.
* 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.
* 219422: Chart Setting dialogue was not closed when user was redirected to relogin after session expiring.
* 219584: Flowchart cache was not cleared when user logs out.
* 219536: SVC log file was incorrectly generated to QPRPA root folder.
* 219532: Creating new objects using Web API incorrectly required property id=-1.
== QPR ProcessAnalyzer 2020.8 (build 80) (released 2020-11-10) ==
'''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;">
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.
Default query timeout of 30 minutes has been added for --#ImportOdbcQuery, --#ImportSqlQuery and --#ImportOleDbQuery commands. If a query run is taking longer than the timeout, the query is stopped. The timeout can be adjusted using the '''QueryExecutionTimeout''' parameter. Previously, there has been no timeout, so queries that take more than 30 minutes require configuring a longer timeout.
</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;">
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.
Incorrectly configured [[Chart_Linked_Settings|linked settings]] in charts (available in the ''Advanced'' tab) give now an error message, if they are referring to non-existing measures, dimensions or columns. Previously, incorrect linked settings were ignored. To fix the error message, remove the incorrect linked settings.
</div>
 
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
The '''web.httpsOnly.config''' file included in the 2020.8 installation package is incorrect and it should not be used. 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>
</div>


'''Features:'''
'''Features:'''
* 307071: User management is available in the Web UI.
* B-07511: Datatables have a [[Datatable_Properties_Dialog|dialog]] to view datatable properties, write description, set the Snowflake source table, add/modify/delete columns, and set the datatable key.
* 308038: Database tables related to the legacy model data structures are removed from the database.
* B-08150: Added setting [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters first]] to determine whether chart filter rules or dashboard filter rules are applied first when chart queries are filtered.
* 308028: PAPO is changed to a component containing the Flowchart only that does not contain any other analyses.
* B-08091: When filtering charts in Snowflake, case attribute filter is created instead of case id filter.
* 308060: Web links can be defined for tables. Web links can be parametrized to contain information from the clicked row.
* B-08091: [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|New setting]] to define whether cases or events are filtered by default.
* 308068: Chart definition and preset improvements, e.g. Query analysis, Root causes analysis in tabular format, Case count trend by type.
* B-08091: New preset "Looping paths" to detect whether there are repeating patterns of events.
* 308031: Server API: Web API for models.
* B-08091: Duration between events calculation ignores negative durations in Snowflake.
* 308045: Server API: Version information to /api/serverinfo.
* B-08091: Chart loading animation has been renewed.
* 308050: Expression language: Template strings containing embedded expressions.
* B-07636: To prevent dashboards from jamming when querying too much data, added [[QPR_ProcessAnalyzer_Chart#Available_Visualizations|limitations]] to the amount of data that charts can visualize. Note that the limitation concerns the aggregated data that is visualized, not the source event log data.
* 308056: Server API: Filters support for NumberPrecision/DatetimeTruncation/TimespanPrecision and StringifiedValues.
* B-08017: [[Dashboard_in_Expression_Language|Dashboards API]] has been added to expression language, allowing to create, modify and delete dashboards in scripts.
* 308062: Server API: The expression analysis, has a "criteria" property for filtering analysis results.
* B-08056: Following properties have been added to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|user objects]] in expression language: IsLocked, LastLockedDate, LastLoginDate.
* 308069: Constant folding optimization for expression language.
* B-08053: [[Navigation_Menu#System_Reports|User rights report]] has been refactored to use [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property in the expression language. The change also simplifies the report as now it only shows the direct role assignments that are visible in the [[Manage_Users_and_Groups|User Management]].
* 307965: Expression language: New functions for handling dataframes.
* B-08151: For Snowflake expressions support for following [[SQL_Expressions#Window_functions|windowing functions]]: sum, average, median, min, and max.
* 308041: SendEmail function in expression language.
* B-08050: When a model is created, the default filter is not created anymore (this is a refactoring that doesn't have any impact on user interface).
* 308049: Backend performance improvements for dashboards.
* B-08123: Translation updates for 2023.7.
* 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.
* B-08092: Updated backend components.
* 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:'''
'''Fixed issues:'''
* 219241: Filter from ChartView is not confirmed when clicking Flowchart.
* D-13876: In CreateSnowflakeConnection function, ProjectId parameter is optional when OdbcConnectionStringKey is not specified.
* 219507: X-AspNet-Version http response header has been removed from error responses.
* D-13898: Snowflake: Exclude case attribute filter didn't work when there was null values and was selecting at least two values.
* 219533: Dashboard gave randomly "Collection was modified, enumeration operation may not execute" error.
* D-13890: Fixed XES file import to work.
* 219540: Conformance analysis with incorrect BPMN model containing loops crashed server.
* D-13894: Business calendar based duration calculation was incorrect in some durations that spanned to several weeks (for Snowflake and in-memory models).
* 219349: When flow is selected in PAPO flowchart, event type filtering should not be possible.
* D-13899: Using broken OdbcConnectionString in a datatable prevented the datatable from being deleted.
* 219535: Empty strings in X-axis values show category index.
* D-13883: Script run stucked after running a script with error that uses client-side ODBC import.
* 219554: When using lasso tool to filter in chart, y-axis position should be ignored in most chart types.
* D-13879: SqlExpressionValue filter when excluding events didn't work with filter rule root expression only.
* 219558: Clustering and prediction doesn't take into account when there is one event type selected.
* D-13896: Adding or removing columns to datatable didn't change the LastModifiedDate.
* 219221: Add many duplicate filters to same view should be prevented.
* D-13882: User details weren't written to operation log when creating or modifying users.
* 219534: It should not be possible to create filter rules without values selected.
* D-13771: User rights system report didn't give error when changing columns.
* 219546: PA page content stays in very small area after reload page.
* D-13893: Some event filtering caused null pointer error when primary key had been defined.
* 219555: Changing focus to other chart while selection is in progress creates invalid filter if clicked chart has chart filter.
* D-13873: Fixed pivot table visual issues after component update.
* 219403: Improved error message texts for access denied errors.
* D-13900: When adding, renaming or removing columns for Snowflake table fails, operation is now rolled back without any changes.
* 219514: GET api/users/memberships/{id} should also return group's members.
* D-13866: Querying GET api/uielements was quite slow right after server start.
* 219565: "No measure or dimensions have been defined" error in Conformance Root Check view.
* D-13864: Combinations of translatable and hardcoded strings didn't get translated in UI.
* 219567: Typo in Chart Settings Presets.
 
* 219570: Color scale is inverted in Root causes for case duration preset.
== Additional release for QPR ProcessAnalyzer 2023.6 (build 3933) (released 2023-10-24) ==
* 219573: Event type filter component doesn't work.


== QPR ProcessAnalyzer 2020.7 (build 39) (released 2020-10-21) ==
'''Features:'''
* B-08055: Error message for locked account has been replaced with generic error message, so that username enumeration is not possible.


'''Fixed issues:'''
'''Fixed issues:'''
* 308058: Roll back improvement of model statistics calculation (307988) which inadvertently changed the Excel client protocol.
* D-13884: Attributes dialog crashed with some older model configurations.
* D-13843: In charts, selected case and event attributes switched away when attribute data type was ShortString.
* D-13877: Some Snowflake expressions gave error "exceeds maximum length limit of 255 characters" when selecting lot of items.
* D-13878: Snowflake expression filters for case attribute values didn't accept other than string type of case attributes.
* D-13871: Some statistical calculations with percentages didn't work with Last Row Aggregates Over-limit Rows setting.
* D-13875: Using some case level filters in a model without cases datatable didn't work.
* D-13861: Dashboard opens are now logged to the Task log (i.e., calling GET /api/dashboards/{dashboardid}).
* D-13870: Workspace projects hierarchy focused project showed light grey background making the project name not readable.
* D-13867: When starting datatable refresh and going to other tab, went back to Datatables tab when query completed.
* D-13853: If chart Custom Layout settings had extra series defined, chart may have crashed.
* D-13869: Export as CSV button didn't work in the datatable contents dialog when dialog was still loading.
* D-13872: Main progress spinner had unnecessary small scrollbar on top right.
* D-13863: In the REST API method GET /api/users, password field (that has always been null) has been removed.


== QPR ProcessAnalyzer 2020.7 (build 36) (released 2020-10-13) ==
== QPR ProcessAnalyzer 2023.6 (build 3847) (released 2023-10-17) ==


'''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;">
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.
Big data chart support of models with local datatables (i.e., SQL Server stored) is removed in this release. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).
</div>
</div>


'''Features:'''
'''Features:'''
* 308036: Default values of chart margins have been adjusted, and there is a dashed line helping aligning charts.
* B-07992: Added 10 new presets including Queue analysis, Four eyes principle, Self-looping events, and Path until selected event. There are also presets for Individual Cases Flow and Range of event type occurrences which use Gantt chart.
* 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-08011: Added following date related operations for Snowflake: Day of year, Day of month, Day of week, Week of year, Half-year only, Quarter only, Month only, Hours only, Minutes only, Seconds only, and Milliseconds only. These are available when calculating with date type of data.
* 307956: Backend support for dimension values rounding for numbers, datetimes and durations.
* B-08016: [[QPR_ProcessAnalyzer_Table#Table_actions|Table actions to set variables]] can also be opened to a new browser tab. Also improved user interface for table actions.
* 308040: Variation calculation performance has been improved.
* B-08018: For Snowflake expressions, added Flows aggregations FromEventType and ToEventType to get starting/ending event type, and FlowOccurrences aggregations FromEvent and ToEvent to get starting/ending event.
* B-08001: Added [[Generic_Functions_in_QPR_ProcessAnalyzer#CallStoredProcedure|CallStoredProcedure]] function to call Snowflake stored procedures. This allows to start ETL transformation in Snowflake orchestrated by QPR ProcessAnalyzer script.
* B-08013: Added [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property to expression language to replace the legacy UserPermissions analysis (11).
* B-07976: Snowflake [[Filtering_in_QPR_ProcessAnalyzer_Queries#Expression|expression based filter rules]] support additional expression columns allowing more Big data chart expressions to be filterable.
* B-08015: Big data chart doesn't anymore support calculation in SQL Server (using local datatables).
* B-06270: Improved error messages and made them translatable by taking into use exception codes provided by server.
* B-08021: Added possibility to store [[Diagram_in_Expression_Language|designed diagrams]] for models and expression language API for reading and modifying diagrams.
* B-08037: Dropped following unused tables database: PA_IDEA, PA_IDEA_VOTE, PA_REPORT, PA_REPORT_SETTING, PA_SESSION_SERVICE, PA_VIEW_FILTER_RULE, PA_VIEW_FILTER_RULE_PARAMETER.
* B-08052: Language translations have been updated to 2023.6.
* B-08051: Frontend side components have been updated.
* B-08034: Backend side components have been updated.


'''Fixed issues:'''
'''Fixed issues:'''
* 219518: Root cause analysis doesn't change after first analysis when comparison criteria is changed.
* D-13830: Object counts indicator in header showed incorrect counts when there was disabled filter rules in Snowflake models.
* 219523: Analysis query fails when there are filter rules and model is not already in memory.
* D-13833: In-memory charts didn't work with boolean type of dimensions when filtering with the false value.
* 219516: User description in Excel breaks web UI.
* D-13858: Target value measures didn't update chart when controlled using an on-screen setting.
* 219527: Opening UI with a link containing sys:dashboard opens previously used model instead of model stored to dashboard.
* D-13827: Calculated attributes data type was incorrectly set as Any by the Attributes dialog.
* 219525: Filtering fails when first clicking chart and then PAPO flowchart.
* D-13849: Multiselect list search didn't allow spaces.
* 219510: Filter creation doesn't work from "Cases where specific events occur" dimension.
* D-13829: Multiselect dropdown lists height jumped couple of pixels when selecting values.
* 219503: Flow duration gives "Index out of bounds" when selecting a flow that does not exist.
* D-13835: Deselecting a selected data point didn't remove chart filter rule.
* 219517: "Cases with specific case attribute value" measure doesn't take into account datatypes.
* D-13702: Improved Snowflake query performance in situations when there are lot of filter rules (by decreasing number of CTE's).
* 219254: When other than traditional model has never been loaded, model statistics should return null in expression language.
* D-13819: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
* 219509: Event types is empty after ResetModelCache.
* D-13820: Fixed incorrect manifest.json file to avoid "not found" errors when fetching web site icon.
* D-13865: Break, continue, and return statements didn't work properly when called from inside a catch block.
* D-13795: There was a Python error in clustering analysis with Snowflake model.
* D-13823: Some tooltips in Workspace project hierarchy didn't work and caused a JavaScript error.
* D-13824: BPMN editor align context menu layout looked strange.
* D-13813: QPR logo button in the top left was misaligned in Firefox.
* D-13797: Snowflake query may have given following error when using sampling: ambiguous column name '_EventType_NotNull_1'.
* D-13774: TakeSample function with certain columns caused SQL compilation error: ambiguous column name 'Case Name'.
* D-13782: Snowflake: Aggregating from variations didn't work when using sampling.
* D-13836: Some tooltips had a strange two-colored background.
* D-13834: Removed Model statistics column from clustering and root causes analysis.
* D-13860: Removed filter button from the custom expressions in Task log analyzed objects.
* D-13838: Removed Split data by filtering column from clustering analysis.
* D-13832: Script and model status updates incorrectly sent next update when previous was still pending.
* D-13839: Charts reset zoom button font size was too small.
* D-13817: Importing data to Snowflake datatable with Append=0 doesn't now drop the underlying Snowflake table.
* D-13825: Some models could not have been deleted from recycle bin.
* D-13852: Recycle bin Projects and Models tab didn't show correct content when Recycle bin only contained either models or projects.
* D-13841: In-memory chart Data type selection type has been corrected to string.
* D-13842: Second time and Third time selections has been hidden in in-memory chart measures.
* D-13850: In Chrome, there were console errors related in incorrect text field autocomplete type and text field without form.
* D-13847: Improved browser side performance by removing unnecessary operations.
* D-13859: Chart without dimensions showed an unnecessary Remove dimension button.
* D-12598: When script is stopped in server, ScriptLauncher could still incorrectly continue to import data.


== QPR ProcessAnalyzer 2020.7 (build 12) (released 2020-09-29) ==
== Additional release for QPR ProcessAnalyzer 2023.5 (build 3334) (released 2023-09-07) ==


'''Notes:'''
'''Fixed issues:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 1em 1em;background-color:#ffcdd3;margin:10px 0px 0px 10px;">
* D-13826: Measures or dimensions with case or event attribute and value selections incorrectly removed calculated attributes when dashboard was opened or chart settings were changed.
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-13821: Font size of some Highcharts tooltips was too small. Issue appeared when there were tooltips mappings in measures or dimensions.
* D-13810: Simplified help links: now all Help buttons go to the QPR ProcessAnalyzer wiki main page.
* D-13822: Snowflake clustering analysis showed empty strings and nulls as case attribute values in an unclear way as just nothing.


The conversion can be done as follows:
== QPR ProcessAnalyzer 2023.5 (build 3304) (released 2023-09-05) ==
# In QPR ProcessAnalyzer Web UI, export the model as a .pacm file by clicking ''Export Model'' in the ''Model Properties'' (in the ''Actions'' tab).
# 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.
# 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.


Notes regarding the conversion:
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* Exporting and importing operations might take long time for very large models.
In Big Data Chart, the '''Case conformance''' measure and dimension has changed in a way that now it provides boolean values (true/false) instead of integer values (1/0). If [[Measure,_Dimension_and_Column_Settings#Other_settings|colorMappings]] are used for this measure or dimension to set specific colors to visualize conformant and nonconformant cases, the mapped values need to be changed as follows: '''1''' -> '''true''' and '''0''' -> '''false'''. Without the change, the mapped colors are not effective.
* Model id's are not changed in the conversion.
 
* Original filters and their id's are preserved but new duplicate filters are created during the import (which can be deleted).
Exmaple: Old configuration:
<pre>
"colorMappings": {
  "1": "#36d475ff",
  "0": "#f5403bff"
}
</pre>
New configuration:
<pre>
"colorMappings": {
  "true": "#36d475ff",
  "false": "#f5403bff"
}
</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;">
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''.
Big data chart support of models with local datatables (i.e., SQL Server stored) is deprecated. Big data chart has allowed to process data both in Snowflake and SQL Server. Now the support for SQL Server is deprecated and the Big data chart will only support calculation in Snowflake. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).
</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_Version_Compatibility|Excel Client protocol version]] is changed which requires to update QPR ProcessAnalyzer Excel Client when updating to QPR ProcessAnalyzer 2020.7.
Following legacy analyses have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). The OperationLog analysis is replaced by the [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog function]] and the Infcluencers analysis is replaced by the [[FindRootCauses_Function|FindRootCauses function]].
 
Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
<pre>
let removedAnalyses = [12, 14, 15, 16, 29];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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.
By default, Snowflake ODBC driver generates quite much logging to files which might unnecessarily fill up the disk space. It's recommended to set the LogLevel parameter to value 0. The path where the logs are created can be seen in Windows registry (key LogPath). More information about configuring Snowflake ODBC parameters: https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters.
</div>
</div>


'''Features:'''
'''Features:'''
* 308003: Filter rules can be turned off.
* B-07971: Machine learning based [[Clustering_Analysis|Clustering analysis]] can be run in Snowflake.
* 308021: Dimension specific maximum number of items can be defined.
* B-07989: In dashboard designer the stacking order of charts can be changed with buttons [[QPR_ProcessAnalyzer_Dashboard_Designer#Viewing_and_Editing_Dashboards|Bring to front, Send to back, Bring forward and Send backward]].
* 308006: KPI card has customizable colors.
* B-07977: For [[Sankey_Chart|sankey diagram]], added Start level and End level mappings to define custom start and end level for the sankey flows. Implemented also color mappings to define specific colors for specific values.
* 308009: Dimension values can be mapped to colors for visualization.
* B-08010: To improve performance, charts are loaded and updated only when they are visible in the dashboard.
* 308008: Chart specific model selection.
* B-07975: Added following [[SQL_Expressions#Date_functions|date related functions]] to Snowflake: DayOfYear, DayOfWeek, WeekOfYear, Quarter.
* 308017: Remove left and right axis synchronization in Chart.
* B-07908: When [[QPR_ProcessAnalyzer_Project_Workspace#Duplicating_Model|model is duplicated]], also filters in the model are also duplicated.
* 307995: Ending tasks in web UI.
* B-07904: Filters and models API for expression language has been completed.
* 307987: Navigation menu width is set based on dashboard names.
* B-07991: In [[Filter_Selectors|case and event type filter selectors]], threshold whether the dropdown list or search dialog is shown can be defined using the ''Maximum Rows'' setting. Also the search dialog filters search results by other filter rules in the dashboard.
* 307993: Model size estimate is decreased by 20 %.
* B-07999: Filters report has been changed to use the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|expression language API for filters]].
* 308018: Bottleneck identification and optimizations for models having lots of cases.
* B-07540: Added [[QPR_ProcessAnalyzer_Expressions#Throwing_objects|throw statement]] to expression language.
* 307994: Taken into use functions stdev, stdevp, var and varp in Chart.
* B-07813: UI components are updated. There are small visual improvements, such as in flowchart flows are routed a bit differently and in charts the hidden series is shown as strike-through in the legend.
* 308016: Migrate Chart pivot to Syncfusion JS2 PivotTable.
* B-07963: Following legacy analysis types have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29) (see more information in the note above).
* 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-13777: Filters could not be created in charts when "Update Filter During Selection" setting was disabled.
* 219487: When moving and resizing, presentation objects should be aligned with each other and with the canvas.
* D-13767: Automation per Event Types preset in in-memory incorrectly showed only one event type.
* 219472: Improvements to model and data table loading slowness and memory usage.
* D-13756: Changing background color in KPI card didn't have any effect.
* 219465: "Case/event attribute not found" error messages improved.
* D-13812: "Exclude events" was incorrectly translated to "Exclure les cas" in French.
* 219474: Filter rule text said "undefined" for some expression based filters.
* D-13815: Dashboard designer background grid was not visible in entire area in edit mode. Improved also the grid to match to snapping in move and resize.
* 219462: User could not fix incorrect chart settings.
* D-13674: Business calendar dialog layout was incorrect when a model with a long name was selected to copy holidays.
* 219471: "All cases" option was not visible when changing between models that don't have filters.
* D-13811: Table actions link to a new window didn't go to dashboard if there were other parameters in the link.
* 219488: Filter selection should be cancelled when changing dashboard.
* D-13601: Fixed issue where some presets may have given error when attribute value selection and the automatically selected attribute conflicted by the data type.
* 219494: Duration values in flowchart were sometimes rounded incorrectly.
* D-13753: While Snowflake model was selected, in Filters and User Rights reports the Columns list could not be opened.
* 219484: Alignment of dashboard objects was difficult.
* D-13720: Now table column filter and sorting are preserved when resizing or zooming page.
* 219502: When clicking same Case attribute/Event attribute preset again, loading animation staid for ever.
* D-13785: In tables increased number of rows to 20000 that are inspected to get available items shown in Excel-style column filter.
* 219481: Stdev, stdevp, var and varp functions should return null when there are zero or one items in the array.
* D-13759: Some statistical calculations had bad performance with large number of rows.
* 219496: Series should be stacked bottom-to-top and from-left-to-right in charts.
* D-13787: Conformance statistics component didn't have scrollbars when text didn't fit to the visible area.
* 219499: Chart colors were reset to default when resizing window.
* D-13788: In-memory "Nonconformance reason" selection caused error when two of them was selected in the same chart.
* 219480: Attribute+Variation filter resulted in zero cases.
* D-13783: When Analyzed objects was Generic analysis, column selection incorrectly caused "Analysis has not been selected" error.
* 219479: SAML login redirection replaces contains http even if https is configured.
* D-13776: When measure name contained quotation mark, notification preview didn't work.
* D-13747: Filtering with integer type of case id with case attribute value filter caused error in Snowflake.
* D-13791: In Firefox, model selection in chart settings didn't show models in the first open.
* D-11984: Recycle bin buttons didn't fit to the screen when screen width was small.
* D-13780: Using CaseId case attribute in clustering analysis did not work with Snowflake 106 cases standard model.
* D-13781: Clustering analysis produced Python error with a certain simple Snowflake model.
* D-13730: Snowflake: Case attribute filtering didn't work when there are cases without row in cases table.
* D-13803: There was chart configuration validation error in browser console when measures were moved into dimensions in Big data chart.
* D-13758: There was performance issue with the Recent tasks system preset.
* D-13793: Snowflake clustering failed when cluster count is larger than case count.
* D-13763: SQL expression based filter rule with Where function to filter events didn't filter anything in Snowflake.
* D-13804: Added missing Millisecond function to Snowflake.
* D-13772: Expression EventLog.Cases.Events caused error "Value cannot be null".
* D-13755: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
* D-13739: When switching between System reports there was error: "Uncaught Error: 2nd dimension not found. at y.getExpressionConfiguration".
* D-12109: Sometimes flowcharts showed message "Error in querying event type measures. Input string was not in a correct format".
* D-12473: Cost Savings by Automation preset gave sometimes error "Unable to cast object of type 'System.Double' to type 'System.String'".
* D-13750: Snowflake model didn't work with the Case Duration vs. Manual Activities preset.
* D-13657: There was error converting data type nvarchar to bigint.
* D-13796: Some Snowflake operations didn't work with zero rows and columns.
* D-12494: Now when chart size changes, the table column filters and sorting are preserved.
* D-13736: In Performance benchmarking dialog, the Export result button exported wrong benchmark performance analysis result.
* D-13609: Improved conformance analysis related filter names.
* D-13594: Recycle bin buttons were not visible when opening recycle bin in a narrow screen.
* D-13226: Tooltips in the model properties dialog are now translated.
* D-12569: Table incorrectly showed ellipsis for narrow boolean type of columns showing checkboxes.
* D-13391: Emptying date or datetime picker value was not registered and it didn't trigger functionality.
* D-12621: Value search dialog didn't work with values containing backslashes.
* D-13796: Some Snowflake operation didn't work with zero rows/columns.


== QPR ProcessAnalyzer 2020.6 (released 2020-08-18) ==  
== QPR ProcessAnalyzer 2023.4 (build 2628) (released 2023-06-14) ==
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-07767: Added [[Gantt_Chart|Gantt chart]] to visualize timeline of cases and events divided into swimlanes.
* 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-06383: Added [[Sankey_Chart|Sankey chart]] to visualize flow from one set of values to another.
* 307982: Changes to showing model last imported date and additional information to Model Properties dialog.
* B-07941: Implemented many more presets running in Snowflake models for compliance and operational excellence use cases. There are also presets for the path analysis and process bottlenecks identification.
* 307983: Editing calculated case and event attributes.
* B-07864: Snowflake conformance analysis shows now [[Conformance_Analysis#Top_Deviations_(in-memory)_/_Deviating_Flows_(Snowflake)|reasons for conformance deviations]], such as which event occurrences deviated from the design model.
* 307980: Chart setting "On-screen Settings Follow Flow Selection" to freeze chart from reacting to flow selection.
* B-07909: Snowflake conformance analysis visualizes [[Conformance_Analysis#Undesired_Events_(Snowflake)|undesired event types]] in table and flowchart.
* 307824: Expression language function improvements (IndexOf, LastIndexOf, ToString, ParseDateTime, First, Last).
* B-07823: Flowchart Bottlenecks preset has been changed to show bottlenecks for event types. Also renewed the [[QPR_ProcessAnalyzer_Logs#Task_Log|Tasks reports]] to use expression language based interface.
* 307952: When loading model data, the order of events inside cases is primarily based on the timestamp and secondarily by event row number.
* B-07891: User interface has been [[Languages_and_Localization|translated into Portuguese]].
* 307953: Querying model-datatable linking in expression language.
* B-07873: Improved [[QPR_ProcessAnalyzer_Pivot_Table|pivot table]] visual layout to highlight totals and aggregated rows. Also the row titles are now visible in the top left.
* 307817: User management operations to Web API.
* B-07905: Added [[SQL_Expressions#Rank_functions|Rank related functions]] to Snowflake for writing more versatile custom KPI's, e.g., FirstValue, LastValue, NthValue, Lead and Lag.
* 307900: Memory consumption improvement for getting number of unique attribute values.
* B-07912: Added more SQL expression [[SQL_Expressions#Array_functions|array functions ArrayToString and ArrayOverlap]] to Snowflake.
* 307978: Performance improvement: Taken into use AttributeType.UniqueCount to replace Count(_.Values) in expression used by UI.
* B-06449: Added SQL expression functions ToTimestamp and TryToTimestamp for parsing timestamps from strings using provided format.
* 307781: ProjectId property is removed from dashboard export files.
* B-07959: Added new functions Base64Encode and Base64Decode to help using basic HTTP authentication when calling web services.
* 307955: Dataframes are loaded in parallel.
* B-07206: SQL expressions support data [[SqlDataFrame_in_Expression_Language#WithClusterColumn|clustering]] which is an unsupervised machine learning algorithm to group data based on similarities.
* 307934: AsParallel function implementation has been finalized.
* B-07848: Data can be extracted from SAP using the encrypted [[Importing_Data_from_SAP#SNC_encrypted_connection|SNC connection]].
* B-07903: Added expression language API to create and modify filters and models.
* B-03103: [[QPR_ProcessAnalyzer_Logs#Task_Log|Task log]] (operation log) can be accessed in expression language.
* B-07872: List aggregation with Distinct=true orders now items by their value.
* B-07940: Removed "Count" aggregation from textual values in Big data chart (you can use the Case count, Event count, etc. selection instead).
* B-07757: Backend support for datatables linking to user-definable Snowflake database, schema and table.
* B-07825: Improved error message when trying to use non-existing attributes in Snowflake queries.
* B-03101: To expression language, added try-catch-finally statement to handle thrown exceptions.
* B-07861: Removed available and total virtual memory information from User settings dialog.
* B-07902: Optimized sequences of joins in Snowflake queries to improve performance.
* B-07837: Updated backend components.


'''Fixed issues:'''
'''Fixed issues:'''
* 219388: Old data comes to dashboard when data imported to datatable.
* D-13709: If image width-to-height ratio was lower than container's ratio, image was incorrectly stretched to fit the container.
* 219412: No scrollbar for both error message and web UI window.
* D-13660: Disabling filter rules didn't work in Snowflake models.
* 219414: Error message appears in Clustering Analysis for model with zero events and cases.
* D-13526: Passing dataframes from SQL scripts to expression scripts didn't work.
* 219419: QueryIdentifier should be excluded from client side query cache.
* D-13661: Snowflake conformance analysis crashed when there was no access to conformance related Snowflake UDF's.
* 219426: Script editor cannot save changes in 2020.5 version.
* D-13693: Resolved major Snowflake conformance analysis performance issues in the BPMN model handling.
* 219430: Filtering does not work in PAPO Cases and Event Types when using French.
* D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
* 219431: PAPO Events and Root Causes not working when using French.
* D-13707: In SQL Scripting, the datatable analysis (number 18) didn't always copy the data table contents to the target table correctly.
* 219435: Dialogues have small layout issue.
* D-13653: Big data flowchart Root causes preset showed incorrect legend.
* 219441: Deletion does not work correctly in folders screen when selecting using shift+ctrl-click.
* D-13626: Flowchart froze when converting into big data flowchart and vice versa by modifying chart json settings.
* 219160: Hidden case attributes are visible in profiling case analysis, and in Influence Analysis for case attributes settings.
* D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
* 219418: Missing translations for the Clustering analysis.
* D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
* 219446: JavaScript error when closing dialog using the X button.
* D-13704: In CSV file import, parsing now allows spaces between column separator and text quotation mark.
* 219444: Deselecting selected item by re-clicking it will not hide the selection buttons in Chart and generates an error in browser console
* D-13598: Chart gave unclear error message when events datatable was not defined.
* 219449: Prediction fails with certain small models.
* D-13655: Improved error messages for BPMN editor and conformance statistics.
* 219450: Evaluation stack is not generated correctly if an exception occurs while inside a function having no parameters.
* D-13528: Error message for certain erroneous SQL expressions was unclear.
* 219456: Query cache is not cleared when model settings are changed.
* D-13677: "Flow occurrences with specific case attribute value" selection didn't work for in-memory chart.
* D-13663: Pivot table border line was slightly broken in the header area.
* D-13608: There was incorrect alignment of items in the table paging controls.
* D-13703: Importing CSV file with some special characters to Snowflake failed (due to incorrect escaping in Snowflake staging files).
* D-13708: Duplicating datatable using user defined table, removed data the source table.
* D-13717: Dependency wheel crashed when there were zero weights and showing data labels.
* D-13348: There was an unclear error message when Snowflake query had a certain incorrect expression.
* D-13732: Pivot table Excel export contained headers formatted incorrectly.
* D-13729: There was a JavaScript error when limited user tried to access business calendar.
* D-13662: Percentile function didn't always work with timespan types.
* D-13646: Using incorrectly configured model without cases datatable caused null reference error.
* D-13629: When tried to use chart with a non-existing model, there is now a proper translated error message.
 
== QPR ProcessAnalyzer 2023.3 (build 1990) (released 2023-05-03) ==
 
'''Features:'''
* B-07818: [[Conformance_Analysis|Conformance analysis]] is supported in Snowflake with following dashboard components: Big data chart, BPMN editor, Conformance statistics, and Design model selector.
* B-07833: [[Root_Causes#Root_causes_in_flowchart|Root causes analysis for flowchart]] is available for Snowflake showing how the event and flow occurrences explain selected phenomena.
* B-07786: Big data chart has more [[Big_Data_Chart#Measure_aggregations|measure aggregations]], such as median, percentile, standard deviation and variance. Also for textual items, unique values can be listed.
* B-07795: [[QPR_ProcessAnalyzer_Table#Conditional_formatting|Conditional formatting]] supports also columns with non-numerical contents.
* B-07830: [[Big_Data_Chart#Measure_aggregations|None and Any aggregations]] for Snowflake and user-friendly formatting for conformance violations.
* B-06527: Error messages in [[Importing_Data_to_Datatable_from_CSV_File|CSV file import]] show also the column number to help working with CSV files with lot of columns.
* B-07747: In-memory conformance checking accepts design models with multiple tasks having same name (same is followed by the Snowflake implementation).
* B-07659: In-memory flowchart preset Case Conformance to visualize conformance checking violations.
* B-07571: Added function IsConformant to backend to check whether cases are conformant.
* B-07863: Added function ConformanceViolationsFlows to backend to return nonconformance reasons for violating cases.
* B-07844: Support for "array" aggregation to return aggregated items as array.
* B-07856: Support for creating and accessing arrays and objects in SQL expressions.
* B-07860: Array handling functions and Tasks property for DesignModel entity.
* B-07847: Added throttling for QPR ScriptLauncher client-side imports to limit memory usage.
* B-07811: Snowflake query optimization to omit columns that are not used by the query.


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


'''Notes:'''
== QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22) ==
* 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.
* B-07755: [[Business_Calendar|Business calendar]] for duration calculation is available for Snowflake models.
* 307868: New dashboard designer that doesn't have panels.
* B-07719: In Snowflake dashboards, [[Big_Data_Chart#Using_measure_variables|measures can be assigned to variables]] and use the variables in other measures to create combined measures.
* 307947: Tables conditional formatting
* B-07746: Changed in-memory conformance checking to not show invalid flow violations where starting or ending event type is invalid.
* 307948: Dashboard properties layout and terminology changes.
* B-07743: [[PA_Configuration_database_table#General_Settings|Default datasource]] can be configured for datatables created by scripts, allowing to set Snowflake as default.
* 307911: IP address verification has been removed.
* B-07740: System memory indicator moved from the header to User settings Version information dialog.
* 307931: Expression language and performance improvements (originated from Spark prototyping).
* B-07776: New SQL expressions functions Unicode, Char and Regexp, as a basis for future rule-based process mining.
* 307774: Web API operation /api/importfile for data import.
* B-07741: Backend support for aggregation operations Median, Percentile, Stdev, Stdevp, Var and Varp to Snowflake.
* 307933: Default logging mode has been changed to ExclusiveLock for all components.
* B-07742: Backend support for aggregation operation to list unique items in Snowflake.
* 307904: Server side support for UI languages.
* B-07770: Optimized Snowflake SQL generation by combining consecutive WithColumn function calls into one select.


'''Fixed issues:'''
'''Fixed issues:'''
* 219372: Issue with simultaneous eventlog processing that caused "Value cannot be null" errors and sometimes calculation with incorrect eventlogs.
* D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
* 219375: --#CallWebService didn't work with Content-Type parameter.
* D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
* 219357: UI was stuck to IdP login page when SAML settings (e.g SAMLUserIdAttribute) were misconfigured.
* D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
* 219391: After logout GetOperationProgress failed for validating session.
* D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
* 219408: Removed focus outline border from buttons and textboxes.
* D-13405: Images take now always all available space in image component area.
* 219398: ETL Access denied CheckIsInProjectContext.
* D-13417: KPI card without title was slightly misaligned vertically.
* 219373: Case.FlowOccurrences and Case.FlowOccurrencesByType have Variations preprocessing missing.
* D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
* 219382: Query for open operations should not return "open" operations that were started before the server startup time.
* D-13350: Task log and Script log default filter end date is now empty by default.
* 219402: Model with LoadOnStartup=true doesn't work with case level permission with expressions referring to current user.
* D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
* 219409: Filters containing event type and variation rules always filter out all cases.
* D-13347: Improved performance for in-memory business calendar calculation.
* 219416: Error in model loading in startup can effect other model loading.
* D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
* 219369: Change error message "Time out while waiting for server response.".
* D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
* 219387: Text filter options opened to left for ChartView making them partly hidden for first column.
* D-13451: Exported filter file is now named based on selected filter name.
* 219395: Save button not always enabled when editing dashboard.
* D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
* 219396: Context change notification should not be called for closing dashboard charts.
* D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
* 219411: Right click menu issue in PA Flowchart analysis view.
* D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
 
* D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
== QPR ProcessAnalyzer 2020.4 (released 2020-05-26) ==
* D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
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]])
* D-13456: Improved error messages for incorrectly configured on-screen settings.
* D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
* D-13421: Improved error messages when trying to use model having some column mappings missing.
* D-13485: Snowflake business calendar gave error when calendar contained Sunday.
* D-13218: Windows event viewer incorrectly contained log entries that are not errors.
* D-12634: Multiline text boxes width is set to non-changeable.
* D-13034: Confirmation dialog to delete items permanently has been updated.
* D-13288: In dialogs, the Create button didn't show the disabled state correctly.
* D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
* D-13483: In Workspace, the new items menu was too narrow for Spanish texts.


'''Notes:'''
== Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24) ==
* 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:'''
'''Features:'''
* 307859: Deployment package dashboards are embedded to QPR ProcessAnalyzer release.
* B-07690: System setting [[PA_Configuration_database_table#General_Settings|DatabaseId]] can be defined by administrator to get more simple table names in Snowflake.
* 307899: RemoveNulls function to remove null values from arrays.
* B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
* 307915: Expression language improvements related to CSV file generation.
* B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
* 307809: When dashboard is opened, editing mode is disabled when no rights to edit the dashboard.
* B-07663: In [[Chart_On-screen_Settings|on-screen settings]], when case/event attribute is selected, related attribute values list are reset.
* 307829: Highcharts, Syncfusion, GoJS and some other components have been updated to their latest versions.
* B-07570: Backend support for [[Business_Calendar|business calendars]] in Snowflake.
* 307848: Component updates for building QPR ProcessAnalyzer UI.
* B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
* 307882: JavaScript libraries are split into smaller files in release build.
* B-07610: Memory counter related technical properties have been removed from expression language.
* 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:'''
'''Fixed issues:'''
* 219365: Sometimes system stuck during the time models were being loaded into memory.
* D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
* 219326&219377: Datetimes are incorrect in files exported from data grids (time zone difference) (See also the notes above).
* D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
* 219378: ChartView resizing sometimes didn't work when using full screen.
* D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
* 219371: Error messages have been improved for session expired and unknown error.
* D-13358: Calculation results caching works also across different user sessions.
* 219360: Some styles were defined twice in CSS.
* D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
* D-13230: SAP import did not automatically create columns to use the correct column types.
* D-12857: Deeply recursive functions caused a crash without any trace.
* D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
* D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
* D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
* D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
* D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
* D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
* D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
* D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
* D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
* D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
* D-12991: Dropdown list texts had some translations missing.


== Additional release for QPR ProcessAnalyzer 2020.3 (released 2020-04-23) ==  
== QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07) ==
Build number: 2020.3.0.41450, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing <pre>"preset": "RootCauses"</pre> and the comma from the preceding line.
</div>


'''Features''':
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 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.
Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.


'''Fixed bugs:'''
Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
* 219370: Dashboards could not be edited by other than administrators.
<pre>
* 219361: Flowchart sometimes crashed to ThrowKeyNotFoundException when pressing Root Causes button.
let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>


== 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.
Starting from QPR ProcessAnalyzer 2023.1, the '''.NET Desktop Runtime''' is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, ''.NET Desktop Runtime'' is not needed, but instead install the '''.NET Runtime''' (which is more lightweight). ''.NET Desktop Runtime'' contains the ''.NET Runtime'', so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.
 
</div>
'''Notes:'''
* 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.
* 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.


'''Features:'''
'''Features:'''
* 307849: Securely stored strings for passwords.
* B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
* 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-07383: Improvements to linked settings to allow binding to variables, tags and filter rules [[Chart_Linked_Settings|(more information)]].
* 307880: When a datatable model is moved to another project, the linked datatables should also be moved to the project.
* B-07508: Flowchart preset colors have been renewed to be more intuitive.
* 307556: Functions to expression language to improve usability and performance: CaseCount, EventCount, EventCountByType and Round.
* B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
* 307895: SQL scripting command for database commit.
* B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|(more information)]].
* 307850: Expression language performance improvement by a new way to calling functions and properties.
* B-07440: Date when the release was made is now shown in User settings.
* 307858: Expression language: Support for array operators.
* B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
* 307845: Header buttons layout has been improved.
* B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
* 307870: Preprocessings are determined automatically.
* B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
* 307761: Functionality that user doesn't have access is now disabled in the dashboard designer and workspace to avoid access denied errors.
* B-07637: Language selector now shows the language options in local languages.
* 307839: Generic chart and gauge presentation objects are removed.
* B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
* 307863: Automatic redirection to SAML authentication.
* B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
* 307872: API support for querying if SAML is configured.
* B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
* 307846: Error message further improvements.
* B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
* 307888: Error message text changes for Dashboard not found and Multiple dashboards found.
* B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
* 307874 & 307887: ChartView and main header has been improved.
* B-07716: ShortString columns are now properly detected in SQL Server queries.
* B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
* B-07688: AddColumns function for Datatables to create multiple columns in one call.


'''Fixed bugs:'''
'''Fixed issues:'''
* 219341: Analysis function unnecessarily required FilterId parameter.
* D-13092: Table conditional formatting didn't work when color code was fetched from other column.
* 219343: Root causes analysis gave access denied when using Analysis function.
* D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
* 219348: Query cancellation caused database connection leakage.
* D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
* 219332: "Thread was being aborted" returned to client while loading model from datatable.
* D-13104: In BPMN model editor, context menus to edit elements didn't appear.
* 219321: Removed unnecessary error log lines "Missing expected HttpRequest X-Forwarded-For" that appeared even if UseXForwardedForAsClientIp=false.
* D-12939: Script editor tabs Close buttons didn't work.
* 219335: [_remove ]._ or empty array is not handled correctly in a KPI dimension.
* D-13154: "Search by case ID" didn't work in in-memory chart.
* 219340: default.aspx does not work.
* D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
* 219330: EditDashboards permission should be needed for target project when moving dashboards between projects.
* D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
* 219347: Queries done by the main header were cancelled when view is changed.
* D-12928: Pivot table headers were empty when there were two column levels and two values.
* 219355: Expression language: Was unable to use properties of the parent context in dictionary initialization.
* D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
* 219346: PAPO flowchart should have by default median duration shown on flows and flow counts hidden.
* D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
* 219333: PAPO generated incorrect filter JSON and unnecessary query.
* D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
* 219311: When opened a view by identifier, the view was fetched twice from the server.
* D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
* 219329: Unnecessary information was stored in database for dashboard definitions.
* D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
* 219362: Issues with session expiration checks.
* D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
* 219364: Session expiration with SAML authentication configured gives incorrect error message.
* D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
* 219344: Case count view in model manager header and Home view can cause unwanted model loading.
* D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
* 219242: Flowchart is not updated correctly after event type filtering.
* D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
* D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
* D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
* D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
* D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
* D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
* D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
* D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
* D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
* D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
* D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
* D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
* D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
* D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
* D-12937: Added maximum value limitation to several number input fields in charts.
* D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
* D-12948: Defining column setting caused error when Measure Expression was not defined.
* D-12946: Filter rule text couldn't be seen entirely from tooltip.
* D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
* D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
* D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
* D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
* D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
* D-13116: BPMN editor had some translations missing.
* D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
* D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
* D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
* D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
* D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
* D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
* D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
* D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
* D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
* D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.


== Old Releases ==
== Old Releases ==

Latest revision as of 08:39, 24 April 2024

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

Next Release: QPR ProcessAnalyzer 2024.4 (planned release date 2024-05-14)

Features:

  • B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.

Fixed issues:

  • D-14084: Filter rule for first/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-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
  • D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
  • D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed.
  • D-14096: Highcharts tooltip square icons were slightly misaliged.
  • D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
  • D-14099: There was a console warnings when opening the business calendar dialog.
  • D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
  • D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
  • D-14107: Snowflake model that has earlier been in-memory model showed case count and estimated memory incorrectly.

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

Known issue: Snowflake models and dashboards don't work with Viewer and Analyzer role permisions. The reason is that cache tables created to Snowflake incorrectly require the write permissions. Workaround is to give users the Designer role which will give the needed permissions. Note that the Designer role gives many permissions to the user for the project (more information). This issue has been fixed in the next release (D-14045).

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)

Known issue fixed in QPR ProcessAnalyzer 2024.2: In Big data chart, some measures, dimensions and columns have the filtering option missing. The issue concerns for example Duration between events, Path starting/until between specific events, and Cases where event occurs before other selections. Workaround is to set the filter in the chart json settings: the filter can be configured to another expression and copied to the correct expression.

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.

QPR ProcessAnalyzer 2023.7 (build 4326) (released 2023-11-28)

Limitation for the maximum amount of data (B-07636) causes a behavior change in in-memory charts that have the Maximum rows settings empty and have the sorting defined. In certain cases, the order in which measures are evaluated changes (due to an internal performance optimization). If there are custom expressions that define variables, the variables may not be available in other measures anymore. As a resolution, either redefine the variables in those measure expressions or add those measures secondarily to the sorting.

Default query timeout of 30 minutes has been added for --#ImportOdbcQuery, --#ImportSqlQuery and --#ImportOleDbQuery commands. If a query run is taking longer than the timeout, the query is stopped. The timeout can be adjusted using the QueryExecutionTimeout parameter. Previously, there has been no timeout, so queries that take more than 30 minutes require configuring a longer timeout.

Incorrectly configured linked settings in charts (available in the Advanced tab) give now an error message, if they are referring to non-existing measures, dimensions or columns. Previously, incorrect linked settings were ignored. To fix the error message, remove the incorrect linked settings.

Features:

  • B-07511: Datatables have a dialog to view datatable properties, write description, set the Snowflake source table, add/modify/delete columns, and set the datatable key.
  • B-08150: Added setting Apply chart filters first to determine whether chart filter rules or dashboard filter rules are applied first when chart queries are filtered.
  • B-08091: When filtering charts in Snowflake, case attribute filter is created instead of case id filter.
  • B-08091: New setting to define whether cases or events are filtered by default.
  • B-08091: New preset "Looping paths" to detect whether there are repeating patterns of events.
  • B-08091: Duration between events calculation ignores negative durations in Snowflake.
  • B-08091: Chart loading animation has been renewed.
  • B-07636: To prevent dashboards from jamming when querying too much data, added limitations to the amount of data that charts can visualize. Note that the limitation concerns the aggregated data that is visualized, not the source event log data.
  • B-08017: Dashboards API has been added to expression language, allowing to create, modify and delete dashboards in scripts.
  • B-08056: Following properties have been added to user objects in expression language: IsLocked, LastLockedDate, LastLoginDate.
  • B-08053: User rights report has been refactored to use RoleAssignments property in the expression language. The change also simplifies the report as now it only shows the direct role assignments that are visible in the User Management.
  • B-08151: For Snowflake expressions support for following windowing functions: sum, average, median, min, and max.
  • B-08050: When a model is created, the default filter is not created anymore (this is a refactoring that doesn't have any impact on user interface).
  • B-08123: Translation updates for 2023.7.
  • B-08092: Updated backend components.

Fixed issues:

  • D-13876: In CreateSnowflakeConnection function, ProjectId parameter is optional when OdbcConnectionStringKey is not specified.
  • D-13898: Snowflake: Exclude case attribute filter didn't work when there was null values and was selecting at least two values.
  • D-13890: Fixed XES file import to work.
  • D-13894: Business calendar based duration calculation was incorrect in some durations that spanned to several weeks (for Snowflake and in-memory models).
  • D-13899: Using broken OdbcConnectionString in a datatable prevented the datatable from being deleted.
  • D-13883: Script run stucked after running a script with error that uses client-side ODBC import.
  • D-13879: SqlExpressionValue filter when excluding events didn't work with filter rule root expression only.
  • D-13896: Adding or removing columns to datatable didn't change the LastModifiedDate.
  • D-13882: User details weren't written to operation log when creating or modifying users.
  • D-13771: User rights system report didn't give error when changing columns.
  • D-13893: Some event filtering caused null pointer error when primary key had been defined.
  • D-13873: Fixed pivot table visual issues after component update.
  • D-13900: When adding, renaming or removing columns for Snowflake table fails, operation is now rolled back without any changes.
  • D-13866: Querying GET api/uielements was quite slow right after server start.
  • D-13864: Combinations of translatable and hardcoded strings didn't get translated in UI.

Additional release for QPR ProcessAnalyzer 2023.6 (build 3933) (released 2023-10-24)

Features:

  • B-08055: Error message for locked account has been replaced with generic error message, so that username enumeration is not possible.

Fixed issues:

  • D-13884: Attributes dialog crashed with some older model configurations.
  • D-13843: In charts, selected case and event attributes switched away when attribute data type was ShortString.
  • D-13877: Some Snowflake expressions gave error "exceeds maximum length limit of 255 characters" when selecting lot of items.
  • D-13878: Snowflake expression filters for case attribute values didn't accept other than string type of case attributes.
  • D-13871: Some statistical calculations with percentages didn't work with Last Row Aggregates Over-limit Rows setting.
  • D-13875: Using some case level filters in a model without cases datatable didn't work.
  • D-13861: Dashboard opens are now logged to the Task log (i.e., calling GET /api/dashboards/{dashboardid}).
  • D-13870: Workspace projects hierarchy focused project showed light grey background making the project name not readable.
  • D-13867: When starting datatable refresh and going to other tab, went back to Datatables tab when query completed.
  • D-13853: If chart Custom Layout settings had extra series defined, chart may have crashed.
  • D-13869: Export as CSV button didn't work in the datatable contents dialog when dialog was still loading.
  • D-13872: Main progress spinner had unnecessary small scrollbar on top right.
  • D-13863: In the REST API method GET /api/users, password field (that has always been null) has been removed.

QPR ProcessAnalyzer 2023.6 (build 3847) (released 2023-10-17)

Big data chart support of models with local datatables (i.e., SQL Server stored) is removed in this release. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).

Features:

  • B-07992: Added 10 new presets including Queue analysis, Four eyes principle, Self-looping events, and Path until selected event. There are also presets for Individual Cases Flow and Range of event type occurrences which use Gantt chart.
  • B-08011: Added following date related operations for Snowflake: Day of year, Day of month, Day of week, Week of year, Half-year only, Quarter only, Month only, Hours only, Minutes only, Seconds only, and Milliseconds only. These are available when calculating with date type of data.
  • B-08016: Table actions to set variables can also be opened to a new browser tab. Also improved user interface for table actions.
  • B-08018: For Snowflake expressions, added Flows aggregations FromEventType and ToEventType to get starting/ending event type, and FlowOccurrences aggregations FromEvent and ToEvent to get starting/ending event.
  • B-08001: Added CallStoredProcedure function to call Snowflake stored procedures. This allows to start ETL transformation in Snowflake orchestrated by QPR ProcessAnalyzer script.
  • B-08013: Added RoleAssignments property to expression language to replace the legacy UserPermissions analysis (11).
  • B-07976: Snowflake expression based filter rules support additional expression columns allowing more Big data chart expressions to be filterable.
  • B-08015: Big data chart doesn't anymore support calculation in SQL Server (using local datatables).
  • B-06270: Improved error messages and made them translatable by taking into use exception codes provided by server.
  • B-08021: Added possibility to store designed diagrams for models and expression language API for reading and modifying diagrams.
  • B-08037: Dropped following unused tables database: PA_IDEA, PA_IDEA_VOTE, PA_REPORT, PA_REPORT_SETTING, PA_SESSION_SERVICE, PA_VIEW_FILTER_RULE, PA_VIEW_FILTER_RULE_PARAMETER.
  • B-08052: Language translations have been updated to 2023.6.
  • B-08051: Frontend side components have been updated.
  • B-08034: Backend side components have been updated.

Fixed issues:

  • D-13830: Object counts indicator in header showed incorrect counts when there was disabled filter rules in Snowflake models.
  • D-13833: In-memory charts didn't work with boolean type of dimensions when filtering with the false value.
  • D-13858: Target value measures didn't update chart when controlled using an on-screen setting.
  • D-13827: Calculated attributes data type was incorrectly set as Any by the Attributes dialog.
  • D-13849: Multiselect list search didn't allow spaces.
  • D-13829: Multiselect dropdown lists height jumped couple of pixels when selecting values.
  • D-13835: Deselecting a selected data point didn't remove chart filter rule.
  • D-13702: Improved Snowflake query performance in situations when there are lot of filter rules (by decreasing number of CTE's).
  • D-13819: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
  • D-13820: Fixed incorrect manifest.json file to avoid "not found" errors when fetching web site icon.
  • D-13865: Break, continue, and return statements didn't work properly when called from inside a catch block.
  • D-13795: There was a Python error in clustering analysis with Snowflake model.
  • D-13823: Some tooltips in Workspace project hierarchy didn't work and caused a JavaScript error.
  • D-13824: BPMN editor align context menu layout looked strange.
  • D-13813: QPR logo button in the top left was misaligned in Firefox.
  • D-13797: Snowflake query may have given following error when using sampling: ambiguous column name '_EventType_NotNull_1'.
  • D-13774: TakeSample function with certain columns caused SQL compilation error: ambiguous column name 'Case Name'.
  • D-13782: Snowflake: Aggregating from variations didn't work when using sampling.
  • D-13836: Some tooltips had a strange two-colored background.
  • D-13834: Removed Model statistics column from clustering and root causes analysis.
  • D-13860: Removed filter button from the custom expressions in Task log analyzed objects.
  • D-13838: Removed Split data by filtering column from clustering analysis.
  • D-13832: Script and model status updates incorrectly sent next update when previous was still pending.
  • D-13839: Charts reset zoom button font size was too small.
  • D-13817: Importing data to Snowflake datatable with Append=0 doesn't now drop the underlying Snowflake table.
  • D-13825: Some models could not have been deleted from recycle bin.
  • D-13852: Recycle bin Projects and Models tab didn't show correct content when Recycle bin only contained either models or projects.
  • D-13841: In-memory chart Data type selection type has been corrected to string.
  • D-13842: Second time and Third time selections has been hidden in in-memory chart measures.
  • D-13850: In Chrome, there were console errors related in incorrect text field autocomplete type and text field without form.
  • D-13847: Improved browser side performance by removing unnecessary operations.
  • D-13859: Chart without dimensions showed an unnecessary Remove dimension button.
  • D-12598: When script is stopped in server, ScriptLauncher could still incorrectly continue to import data.

Additional release for QPR ProcessAnalyzer 2023.5 (build 3334) (released 2023-09-07)

Fixed issues:

  • D-13826: Measures or dimensions with case or event attribute and value selections incorrectly removed calculated attributes when dashboard was opened or chart settings were changed.
  • D-13821: Font size of some Highcharts tooltips was too small. Issue appeared when there were tooltips mappings in measures or dimensions.
  • D-13810: Simplified help links: now all Help buttons go to the QPR ProcessAnalyzer wiki main page.
  • D-13822: Snowflake clustering analysis showed empty strings and nulls as case attribute values in an unclear way as just nothing.

QPR ProcessAnalyzer 2023.5 (build 3304) (released 2023-09-05)

In Big Data Chart, the Case conformance measure and dimension has changed in a way that now it provides boolean values (true/false) instead of integer values (1/0). If colorMappings are used for this measure or dimension to set specific colors to visualize conformant and nonconformant cases, the mapped values need to be changed as follows: 1 -> true and 0 -> false. Without the change, the mapped colors are not effective.

Exmaple: Old configuration: 

"colorMappings": {
  "1": "#36d475ff",
  "0": "#f5403bff"
}

New configuration: 

"colorMappings": {
  "true": "#36d475ff",
  "false": "#f5403bff"
}

Big data chart support of models with local datatables (i.e., SQL Server stored) is deprecated. Big data chart has allowed to process data both in Snowflake and SQL Server. Now the support for SQL Server is deprecated and the Big data chart will only support calculation in Snowflake. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).

Following legacy analyses have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29). This functionality may be in use in SQL scripts (in --#GetAnalysis command), and thus needs to be changed to the --#RunQuery command (see the examples page how each legacy analysis can be replaced). The OperationLog analysis is replaced by the OperationLog function and the Infcluencers analysis is replaced by the FindRootCauses function.

Following script can be run in the Expression Designer to show whether there are scripts that use the removed analyses (and thus require migration): 

let removedAnalyses = [12, 14, 15, 16, 29];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");

By default, Snowflake ODBC driver generates quite much logging to files which might unnecessarily fill up the disk space. It's recommended to set the LogLevel parameter to value 0. The path where the logs are created can be seen in Windows registry (key LogPath). More information about configuring Snowflake ODBC parameters: https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters.

Features:

  • B-07971: Machine learning based Clustering analysis can be run in Snowflake.
  • B-07989: In dashboard designer the stacking order of charts can be changed with buttons Bring to front, Send to back, Bring forward and Send backward.
  • B-07977: For sankey diagram, added Start level and End level mappings to define custom start and end level for the sankey flows. Implemented also color mappings to define specific colors for specific values.
  • B-08010: To improve performance, charts are loaded and updated only when they are visible in the dashboard.
  • B-07975: Added following date related functions to Snowflake: DayOfYear, DayOfWeek, WeekOfYear, Quarter.
  • B-07908: When model is duplicated, also filters in the model are also duplicated.
  • B-07904: Filters and models API for expression language has been completed.
  • B-07991: In case and event type filter selectors, threshold whether the dropdown list or search dialog is shown can be defined using the Maximum Rows setting. Also the search dialog filters search results by other filter rules in the dashboard.
  • B-07999: Filters report has been changed to use the expression language API for filters.
  • B-07540: Added throw statement to expression language.
  • B-07813: UI components are updated. There are small visual improvements, such as in flowchart flows are routed a bit differently and in charts the hidden series is shown as strike-through in the legend.
  • B-07963: Following legacy analysis types have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29) (see more information in the note above).

Fixed issues:

  • D-13777: Filters could not be created in charts when "Update Filter During Selection" setting was disabled.
  • D-13767: Automation per Event Types preset in in-memory incorrectly showed only one event type.
  • D-13756: Changing background color in KPI card didn't have any effect.
  • D-13812: "Exclude events" was incorrectly translated to "Exclure les cas" in French.
  • D-13815: Dashboard designer background grid was not visible in entire area in edit mode. Improved also the grid to match to snapping in move and resize.
  • D-13674: Business calendar dialog layout was incorrect when a model with a long name was selected to copy holidays.
  • D-13811: Table actions link to a new window didn't go to dashboard if there were other parameters in the link.
  • D-13601: Fixed issue where some presets may have given error when attribute value selection and the automatically selected attribute conflicted by the data type.
  • D-13753: While Snowflake model was selected, in Filters and User Rights reports the Columns list could not be opened.
  • D-13720: Now table column filter and sorting are preserved when resizing or zooming page.
  • D-13785: In tables increased number of rows to 20000 that are inspected to get available items shown in Excel-style column filter.
  • D-13759: Some statistical calculations had bad performance with large number of rows.
  • D-13787: Conformance statistics component didn't have scrollbars when text didn't fit to the visible area.
  • D-13788: In-memory "Nonconformance reason" selection caused error when two of them was selected in the same chart.
  • D-13783: When Analyzed objects was Generic analysis, column selection incorrectly caused "Analysis has not been selected" error.
  • D-13776: When measure name contained quotation mark, notification preview didn't work.
  • D-13747: Filtering with integer type of case id with case attribute value filter caused error in Snowflake.
  • D-13791: In Firefox, model selection in chart settings didn't show models in the first open.
  • D-11984: Recycle bin buttons didn't fit to the screen when screen width was small.
  • D-13780: Using CaseId case attribute in clustering analysis did not work with Snowflake 106 cases standard model.
  • D-13781: Clustering analysis produced Python error with a certain simple Snowflake model.
  • D-13730: Snowflake: Case attribute filtering didn't work when there are cases without row in cases table.
  • D-13803: There was chart configuration validation error in browser console when measures were moved into dimensions in Big data chart.
  • D-13758: There was performance issue with the Recent tasks system preset.
  • D-13793: Snowflake clustering failed when cluster count is larger than case count.
  • D-13763: SQL expression based filter rule with Where function to filter events didn't filter anything in Snowflake.
  • D-13804: Added missing Millisecond function to Snowflake.
  • D-13772: Expression EventLog.Cases.Events caused error "Value cannot be null".
  • D-13755: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
  • D-13739: When switching between System reports there was error: "Uncaught Error: 2nd dimension not found. at y.getExpressionConfiguration".
  • D-12109: Sometimes flowcharts showed message "Error in querying event type measures. Input string was not in a correct format".
  • D-12473: Cost Savings by Automation preset gave sometimes error "Unable to cast object of type 'System.Double' to type 'System.String'".
  • D-13750: Snowflake model didn't work with the Case Duration vs. Manual Activities preset.
  • D-13657: There was error converting data type nvarchar to bigint.
  • D-13796: Some Snowflake operations didn't work with zero rows and columns.
  • D-12494: Now when chart size changes, the table column filters and sorting are preserved.
  • D-13736: In Performance benchmarking dialog, the Export result button exported wrong benchmark performance analysis result.
  • D-13609: Improved conformance analysis related filter names.
  • D-13594: Recycle bin buttons were not visible when opening recycle bin in a narrow screen.
  • D-13226: Tooltips in the model properties dialog are now translated.
  • D-12569: Table incorrectly showed ellipsis for narrow boolean type of columns showing checkboxes.
  • D-13391: Emptying date or datetime picker value was not registered and it didn't trigger functionality.
  • D-12621: Value search dialog didn't work with values containing backslashes.
  • D-13796: Some Snowflake operation didn't work with zero rows/columns.

QPR ProcessAnalyzer 2023.4 (build 2628) (released 2023-06-14)

Features:

  • B-07767: Added Gantt chart to visualize timeline of cases and events divided into swimlanes.
  • B-06383: Added Sankey chart to visualize flow from one set of values to another.
  • B-07941: Implemented many more presets running in Snowflake models for compliance and operational excellence use cases. There are also presets for the path analysis and process bottlenecks identification.
  • B-07864: Snowflake conformance analysis shows now reasons for conformance deviations, such as which event occurrences deviated from the design model.
  • B-07909: Snowflake conformance analysis visualizes undesired event types in table and flowchart.
  • B-07823: Flowchart Bottlenecks preset has been changed to show bottlenecks for event types. Also renewed the Tasks reports to use expression language based interface.
  • B-07891: User interface has been translated into Portuguese.
  • B-07873: Improved pivot table visual layout to highlight totals and aggregated rows. Also the row titles are now visible in the top left.
  • B-07905: Added Rank related functions to Snowflake for writing more versatile custom KPI's, e.g., FirstValue, LastValue, NthValue, Lead and Lag.
  • B-07912: Added more SQL expression array functions ArrayToString and ArrayOverlap to Snowflake.
  • B-06449: Added SQL expression functions ToTimestamp and TryToTimestamp for parsing timestamps from strings using provided format.
  • B-07959: Added new functions Base64Encode and Base64Decode to help using basic HTTP authentication when calling web services.
  • B-07206: SQL expressions support data clustering which is an unsupervised machine learning algorithm to group data based on similarities.
  • B-07848: Data can be extracted from SAP using the encrypted SNC connection.
  • B-07903: Added expression language API to create and modify filters and models.
  • B-03103: Task log (operation log) can be accessed in expression language.
  • B-07872: List aggregation with Distinct=true orders now items by their value.
  • B-07940: Removed "Count" aggregation from textual values in Big data chart (you can use the Case count, Event count, etc. selection instead).
  • B-07757: Backend support for datatables linking to user-definable Snowflake database, schema and table.
  • B-07825: Improved error message when trying to use non-existing attributes in Snowflake queries.
  • B-03101: To expression language, added try-catch-finally statement to handle thrown exceptions.
  • B-07861: Removed available and total virtual memory information from User settings dialog.
  • B-07902: Optimized sequences of joins in Snowflake queries to improve performance.
  • B-07837: Updated backend components.

Fixed issues:

  • D-13709: If image width-to-height ratio was lower than container's ratio, image was incorrectly stretched to fit the container.
  • D-13660: Disabling filter rules didn't work in Snowflake models.
  • D-13526: Passing dataframes from SQL scripts to expression scripts didn't work.
  • D-13661: Snowflake conformance analysis crashed when there was no access to conformance related Snowflake UDF's.
  • D-13693: Resolved major Snowflake conformance analysis performance issues in the BPMN model handling.
  • D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
  • D-13707: In SQL Scripting, the datatable analysis (number 18) didn't always copy the data table contents to the target table correctly.
  • D-13653: Big data flowchart Root causes preset showed incorrect legend.
  • D-13626: Flowchart froze when converting into big data flowchart and vice versa by modifying chart json settings.
  • D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
  • D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
  • D-13704: In CSV file import, parsing now allows spaces between column separator and text quotation mark.
  • D-13598: Chart gave unclear error message when events datatable was not defined.
  • D-13655: Improved error messages for BPMN editor and conformance statistics.
  • D-13528: Error message for certain erroneous SQL expressions was unclear.
  • D-13677: "Flow occurrences with specific case attribute value" selection didn't work for in-memory chart.
  • D-13663: Pivot table border line was slightly broken in the header area.
  • D-13608: There was incorrect alignment of items in the table paging controls.
  • D-13703: Importing CSV file with some special characters to Snowflake failed (due to incorrect escaping in Snowflake staging files).
  • D-13708: Duplicating datatable using user defined table, removed data the source table.
  • D-13717: Dependency wheel crashed when there were zero weights and showing data labels.
  • D-13348: There was an unclear error message when Snowflake query had a certain incorrect expression.
  • D-13732: Pivot table Excel export contained headers formatted incorrectly.
  • D-13729: There was a JavaScript error when limited user tried to access business calendar.
  • D-13662: Percentile function didn't always work with timespan types.
  • D-13646: Using incorrectly configured model without cases datatable caused null reference error.
  • D-13629: When tried to use chart with a non-existing model, there is now a proper translated error message.

QPR ProcessAnalyzer 2023.3 (build 1990) (released 2023-05-03)

Features:

  • B-07818: Conformance analysis is supported in Snowflake with following dashboard components: Big data chart, BPMN editor, Conformance statistics, and Design model selector.
  • B-07833: Root causes analysis for flowchart is available for Snowflake showing how the event and flow occurrences explain selected phenomena.
  • B-07786: Big data chart has more measure aggregations, such as median, percentile, standard deviation and variance. Also for textual items, unique values can be listed.
  • B-07795: Conditional formatting supports also columns with non-numerical contents.
  • B-07830: None and Any aggregations for Snowflake and user-friendly formatting for conformance violations.
  • B-06527: Error messages in CSV file import show also the column number to help working with CSV files with lot of columns.
  • B-07747: In-memory conformance checking accepts design models with multiple tasks having same name (same is followed by the Snowflake implementation).
  • B-07659: In-memory flowchart preset Case Conformance to visualize conformance checking violations.
  • B-07571: Added function IsConformant to backend to check whether cases are conformant.
  • B-07863: Added function ConformanceViolationsFlows to backend to return nonconformance reasons for violating cases.
  • B-07844: Support for "array" aggregation to return aggregated items as array.
  • B-07856: Support for creating and accessing arrays and objects in SQL expressions.
  • B-07860: Array handling functions and Tasks property for DesignModel entity.
  • B-07847: Added throttling for QPR ScriptLauncher client-side imports to limit memory usage.
  • B-07811: Snowflake query optimization to omit columns that are not used by the query.

Fixed issues:

  • D-13632: Going from variations to event types led to very poor performance with certain models.
  • D-13628: Statistical calculations were incorrectly not applied in chart CSV export.
  • D-13575: SQL script may have given error "Operand type clash: nvarchar(max) was incompatible with sql_variant".
  • D-13597: UI supports now datatable column type "ShortString" (previously datatable contents preview and CSV import didn't work).
  • D-13536: Using business calendar sometimes gave error "System.InvalidOperationException: Collection was modified".
  • D-13477: Chart types without y-axis mapping caused an error when series mapping was used.
  • D-13453: _model variable was not available for Snowflake expression filter rules.
  • D-13527: Checkbox height didn't increase when long label needed to span to multiple lines.
  • D-13363: Snowflake query with EvaluateAfterAggregations and IsHidden failed when dimensioning by case id column.
  • D-13383: Snowflake query gave error "Invalid column name 'FromCase Name'".
  • D-13523: Request id was incorrectly shown as zeros in error messages.
  • D-13541: In CSV import, error message for maximum number of columns exceeded is improved (maximum is 300 column for SQL Server).
  • D-13583: Objects count in header didn't work for empty Snowflake model.
  • D-13553: Larger pacm files can now be imported, as there isn't error "Request body too large. The max request body size is 30000000 bytes".
  • D-13306: Stack overflow error was given when using SqlDataFrames.
  • D-13487: When Flows root and there was filter in Values expression, some flows were lost.
  • D-13540: SqlDataFrame query with 300 columns failed to error "WithExpressionColumn: No name given for the new column".
  • D-13429: Ordering in List aggregation couldn't find columns in dataframe query.
  • D-13406: Dataframe query with root FlowOccurrences and get value from cases caused error.
  • D-13538: There was incorrect handling of escaping characters in column names used in dimensions.
  • D-13633: Fixed ordering in List aggregation with null and empty values.
  • D-13636: Query that dimensions by numeric case attribute with AggregateOthers true, caused error.
  • D-13589: Creating Snowflake datatable did not connect to Snowflake.
  • D-13623: Value expressions without aggregation didn't work with AggregateOthers setting.
  • D-13554: In in-memory chart, percentile function might have return both Int64 and Double type of objects which cannot be sorted.
  • D-13481: Improved error message when trying to use deleted model.
  • D-13621: Dynamic value search dialog had incorrect font in lists.
  • D-13610: Some invalid BPMN files crashed BPMN editor.
  • D-13614: Checkbox label texts overflowed to right.
  • D-13520: Removed excessive parameters from the Query Designer for generic context queries.
  • D-12998: QPR icon was incorrectly positioned in header in Safari.
  • D-13480: Import to duration data type is removed from Snowflake datatables, and for local datatables duration type maximum size is checked.
  • D-13517: In Highcharts-based visualizationsm conditional formatting didn't work for other than the first y-axis mapping.
  • D-13529: In some presets containing several on-screen settings, when chart showed in error message, on-screen settings showed invalid selection.
  • D-13530: Opening dropdown list caused JavaScript error when the list contents should be empty after it previously contained items.
  • D-13486: Removed unreachable error message in CSV import.
  • D-13524: Fixed in-memory chart flow occurrences root measures "Event attribute (text)" and "Event attribute (number)" that caused error.

QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22)

Features:

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

Fixed issues:

  • D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
  • D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
  • D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
  • D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
  • D-13405: Images take now always all available space in image component area.
  • D-13417: KPI card without title was slightly misaligned vertically.
  • D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
  • D-13350: Task log and Script log default filter end date is now empty by default.
  • D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
  • D-13347: Improved performance for in-memory business calendar calculation.
  • D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
  • D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
  • D-13451: Exported filter file is now named based on selected filter name.
  • D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
  • D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
  • D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
  • D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
  • D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
  • D-13456: Improved error messages for incorrectly configured on-screen settings.
  • D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
  • D-13421: Improved error messages when trying to use model having some column mappings missing.
  • D-13485: Snowflake business calendar gave error when calendar contained Sunday.
  • D-13218: Windows event viewer incorrectly contained log entries that are not errors.
  • D-12634: Multiline text boxes width is set to non-changeable.
  • D-13034: Confirmation dialog to delete items permanently has been updated.
  • D-13288: In dialogs, the Create button didn't show the disabled state correctly.
  • D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
  • D-13483: In Workspace, the new items menu was too narrow for Spanish texts.

Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24)

Features:

  • B-07690: System setting DatabaseId can be defined by administrator to get more simple table names in Snowflake.
  • B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
  • B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
  • B-07663: In on-screen settings, when case/event attribute is selected, related attribute values list are reset.
  • B-07570: Backend support for business calendars in Snowflake.
  • B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
  • B-07610: Memory counter related technical properties have been removed from expression language.

Fixed issues:

  • D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
  • D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
  • D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
  • D-13358: Calculation results caching works also across different user sessions.
  • D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
  • D-13230: SAP import did not automatically create columns to use the correct column types.
  • D-12857: Deeply recursive functions caused a crash without any trace.
  • D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
  • D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
  • D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
  • D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
  • D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
  • D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
  • D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
  • D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
  • D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
  • D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
  • D-12991: Dropdown list texts had some translations missing.

QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07)

This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing 
"preset": "RootCauses"
and the comma from the preceding line.

Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in --#GetAnalysis command), and thus needs to be changed to the --#RunQuery command (see the examples page how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.

Following script can be run in the Expression Designer to show whether there are scripts that use the removed analyses (and thus require migration): 

let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");

Starting from QPR ProcessAnalyzer 2023.1, the .NET Desktop Runtime is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, .NET Desktop Runtime is not needed, but instead install the .NET Runtime (which is more lightweight). .NET Desktop Runtime contains the .NET Runtime, so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.

Features:

  • B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
  • B-07383: Improvements to linked settings to allow binding to variables, tags and filter rules (more information).
  • B-07508: Flowchart preset colors have been renewed to be more intuitive.
  • B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
  • B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace (more information).
  • B-07440: Date when the release was made is now shown in User settings.
  • B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
  • B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
  • B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
  • B-07637: Language selector now shows the language options in local languages.
  • B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
  • B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
  • B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
  • B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
  • B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
  • B-07716: ShortString columns are now properly detected in SQL Server queries.
  • B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
  • B-07688: AddColumns function for Datatables to create multiple columns in one call.

Fixed issues:

  • D-13092: Table conditional formatting didn't work when color code was fetched from other column.
  • D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
  • D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
  • D-13104: In BPMN model editor, context menus to edit elements didn't appear.
  • D-12939: Script editor tabs Close buttons didn't work.
  • D-13154: "Search by case ID" didn't work in in-memory chart.
  • D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
  • D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
  • D-12928: Pivot table headers were empty when there were two column levels and two values.
  • D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
  • D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
  • D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
  • D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
  • D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
  • D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
  • D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
  • D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
  • D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
  • D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
  • D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
  • D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
  • D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
  • D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
  • D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
  • D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
  • D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
  • D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
  • D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
  • D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
  • D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
  • D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
  • D-12937: Added maximum value limitation to several number input fields in charts.
  • D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
  • D-12948: Defining column setting caused error when Measure Expression was not defined.
  • D-12946: Filter rule text couldn't be seen entirely from tooltip.
  • D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
  • D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
  • D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
  • D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
  • D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
  • D-13116: BPMN editor had some translations missing.
  • D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
  • D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
  • D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
  • D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
  • D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
  • D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
  • D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
  • D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
  • D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
  • D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.

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