QPR ProcessAnalyzer Release Notes: Difference between revisions

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


== Next Release: QPR ProcessAnalyzer 2020.3 (planned release date 2020-04-14) ==  
== Next Release: QPR ProcessAnalyzer 2024.8 (planned release date 2024-12-10) ==
Build number: 2020.3.0.xxxxx, Model compatibility version: x, Database version: xx, PACM file version: x, Protocol version: xx.


'''Notes:'''
See [[Next_Release_Content|the next release content]].
* 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:'''
== Latest Release: QPR ProcessAnalyzer 2024.7 (build 8234) (released 2024-10-29) ==
* 307849: Securely stored strings for passwords.
 
* 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.
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307880: When a datatable model is moved to another project, the linked datatables should also be moved to the project.
If using local datatables (stored in SQL Server), the [[PA_Configuration_database_table#SqlServerConnectionString|SqlServerConnectionString]] setting is now mandatory. Starting from QPR ProcessAnalyzer 2024.7, local datatables cannot be created if the setting is not configured. It's recommended to have a separate database for the datatables data, but it's also possible to configure the same connection to the SqlServerConnectionString setting as for the configuration database (in [[Installing_QPR_ProcessAnalyzer_Server#Server_settings_file_(appsettings.json)|appsettings.json]]). See [[QPR_ProcessAnalyzer_System_Architecture|System Architecture]] for more information about the data storage.
* 307556: Functions to expression language to improve usability and performance: CaseCount, EventCount, EventCountByType and Round.
</div>
* 307895: SQL scripting command for database commit.
* 307850: Expression language performance improvement by a new way to calling functions and properties.
* 307858: Expression language: Support for array operators.
* 307845: Header buttons layout has been improved.
* 307870: Preprocessings are determined automatically.
* 307761: Functionality that user doesn't have access is now disabled in the dashboard designer and workspace to avoid access denied errors.
* 307839: Generic chart and gauge presentation objects are removed.
* 307863: Automatic redirection to SAML authentication.
* 307872: API support for querying if SAML is configured.
* 307846: Error message further improvements.


'''Fixed bugs:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219341: Analysis function unnecessarily required FilterId parameter.
Check whether there are custom roles in the database (table PA_ROLE) which have the ROL_FLAGS field set to NULL. The NULL values don't work with this release, so set a correct value (either 1, 2, or 3). Following query can be run in the database showing roles which have an incorrect ROL_FLAGS field:
* 219343: Root causes analysis gave access denied when using Analysis function.
<pre>
* 219348: Query cancellation caused database connection leakage.
SELECT *
* 219332: "Thread was being aborted" returned to client while loading model from datatable.
FROM [PA_ROLE]
* 219321: Removed unnecessary error log lines "Missing expected HttpRequest X-Forwarded-For" that appeared even if UseXForwardedForAsClientIp=false.
WHERE [ROL_FLAGS] = NULL;
* 219335: [_remove ]._ or empty array is not handled correctly in a KPI dimension.
</pre>
* 219340: default.aspx does not work.
</div>
* 219330: EditDashboards permission should be needed for target project when moving dashboards between projects.
* 219347: Queries done by the main header were cancelled when view is changed.
* 219355: Expression language: Was unable to use properties of the parent context in dictionary initialization.
* 219346: PAPO flowchart should have by default median duration shown on flows and flow counts hidden.
* 219333: PAPO generated incorrect filter JSON and unnecessary query.
* 219311: When opened a view by identifier, the view was fetched twice from the server.
* 219329: Unnecessary information was stored in database for dashboard definitions.
* 219326: Data grid export service showed times differently than the data grid.
* 219362: Issues with session expiration checks.
* 219364: Session expiration with SAML authentication configured gives incorrect error message.


== QPR ProcessAnalyzer 2020.2 (release date 2020-03-09) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2020.2.0.41129, Model compatibility version: 3, Database version: 67, PACM file version: 7, Protocol version: 33.
Snowflake user-defined functions (UDF) used by QPR ProcessAnalyzer have been updated to use Python 3.11. Old versions of the functions use Python 3.8 which has been deprecated by Snowflake. Although the old versions are not anymore used by QPR ProcessAnalyzer, they are not automatically deleted and thus Snowflake may send notifications emails about existing deprecated functions. It's recommended to remove the old functions which are following:
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V2
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V3
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V4
* QPRPA_UDF_BC_DURATION_BETWEEN_DATES_V5
* QPRPA_UDTF_CLUSTER
* QPRPA_UDTF_CLUSTER_V2
* QPRPA_UDTF_CLUSTER_V3
* QPRPA_UDF_BPMN_IS_CONFORMANT
* QPRPA_UDF_BPMN_CONFORMANCE_VIOLATIONS_FLOWS
</div>


'''Notes:'''
'''Features'''
* Expression language has now a [[QPR_ProcessAnalyzer_Expressions#Conditional_operator_.28if.29|conditional operator "if"]] and [[QPR_ProcessAnalyzer_Expressions#Define_variables_.28let.29_and_assign_variable_values_.28.3D.29|variable declaration operator "let"]]. In earlier QPR ProcessAnalyzer versions, the expression language had functions [[Generic_Properties_and_Functions_in_QPR_ProcessAnalyzer_Expressions#If|If]] and [[Generic_Properties_and_Functions_in_QPR_ProcessAnalyzer_Expressions#Let|Let]] which earlier could also be written in lowercase (i.e. "if" and "let"). Starting from QPR ProcessAnalyzer 2020.2, the lowercase versions refer to the conditional and variable declaration operators, and the uppercase versions refer to the corresponding functions. If there are expressions containing "If" and "Let" functions written in lowercase, please change them starting with uppercase.
* B-08458: Object-centric perspectives can be stored as filters and object-centric model can be selected for dashboard.
* Issue workaround: The Root Causes analysis don't work (shows empty) in the right side chart (PAPO) of the ''Process Discovery'' view. The issue can be fixed as follows by an administrator: click the ''Edit'' toggle button, click the right side chart, click the ''Edit'' icon in the top right of the chart, click the chart again, click ''Properties'' icon in the top right of the chart, open ''Variables'' tab, find the ''InfluenceAttributeTypeId'' variable, and change its value to empty (instead of ''20''). Click ''Close'' twice to go back to the main level and click ''Save'' button. The issue will be fixed to 2020.3.
* B-08472: Snowflake filter cache tables are now created in background to improve performance.
* Issue workaround: In ChartView, the ''Duration between events'' measure and dimension don't work when there are filters in use (the chart is empty). Workaround is to add the following ''Suffix expression'' to the measure or dimension settings (without quotes): "''//eventtypes''". The issue will be fixed to 2020.3.
* B-08452: Limited sampled cases to 10000 in Snowflake and in-memory clustering presets.
* B-08430: Improved [[Process_Flowchart|Snowflake flowchart]] performance by calculating variations using sampling.
* B-08446: QPR ProcessAnalyzer can be deployed as Snowflake application package to publish it as a [[QPR_ProcessAnalyzer_Native_App_in_Snowflake|native app]].
* B-08418: QPR ProcessAnalyzer has been integrated into Snowflake authentication for Snowpark Container Services.
* B-08420: Legacy "Local" datatables cannot be created anymore - only separate SQL Server database is supported (see release note above).
* B-08437: Snowflake cache is now bypassed for queries that have caching disabled.
* B-08443: Improved object-centric models performance by optimizing perspective generation.
* B-08450: Updated Snowflake UDF's python version from 3.8 to 3.11 (see release note above).
* B-08425: Migrated nine configuration data tables to use Entity Framework.
* B-08334: Removed legacy functionality related to models.
* B-08337: Removed legacy functionality related to roles.
* B-08456: Frontend components have been updated.
* B-08477: Backend components have been updated.
* B-08478: Updated translations for release 2024.7.


'''Features:'''
'''Fixed issues'''
* 307779: SAML 2.0 support for PA UI.
* D-14263: Filtering with case id caused error when Snowflake model didn't have case attributes datatable.
* 307789: PAPO now supports ModelId variable and new filters.
* D-14256: Workspace showed progress spinner forever if trying to remove rows from table where there is no access.
* 307854: Filter selector for main header.
* D-14250: "Show in Query Designer" button didn't show full query sent to server.
* 307844: Improved main header (visible in view designer and workspace) (part 2).
* D-14285: Non-breaking spaces didn't work in json fields.
* 307820: Improved main header (visible in view designer and workspace).
* D-14278: Workspace models list showed linked cases/events datatable even though datatable didn't exist.
* 307840: Model loading script is now run in a security context allowing access to the project. Setting AllowExternalDatasources for disabling ODBC interfaces.
* D-14251: Aggregations list in Combined measure/dimension/column incorrectly showed aggregations for all data types.
* 307763: Root causes analysis supports multiple case attributes.
* D-14257: Exporting datatable with no columns froze loading spinner.
* 307737: Datatable columns can be queried without loading entire datatable into memory.
* D-14188: Script incorrectly aborted after error occurring in the import phase of client-side import.
* 307780: When user logs in, last used model and default filter of the model is added to the session context.
* D-14275: Several "Loop percentage" event measures caused flowchart error.
* 307547: Expression filter rule supports value conversion expression for better compatibility with e.g. date values.
* D-14259: Removed malfunctioning undo/redo operations from Design diagram.
* 307841: Expression language has a new function [[Process_Mining_Objects_in_Expression_Language#Case|Case.DurationBetweenEvents]].
* D-14260: Design diagram toolbar incorrectly scrolled to left when diagram was zoomed.
* 307819: Expression language improvements for functions, variables and statements.
* D-14262: Opening version information caused javascript error if backend communication failed.
* 307827: New function EventsWindow (and expression optimization to take it into use automatically)
* D-14271: None aggregation didn't work with some Statistical calculations.
* 307794: [[ QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model | GenericWrite permission]] should see model object counts when case level permissions are in use.
* D-14283: BPMN editor toolbox has now correct font.
* 307776: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|Effective permissions]] can be queried using expression language.
* D-14280: Dashboard component stacking order buttons didn't work if dashboard had z-indeces with gaps.
* 307838: /api/projects returns effective permissions for each project.
* 307832: Browser side caching has been optimized for performance.
* 307787: Session data and permission are cached for improved performance.
* 307853: Memory management operations to expression language.
* 307803: Error message improvements (part 2).


'''Fixed bugs:'''
<span id="84516a70"></span>
* 219198: In web.config, empty setting names are formatted as <value></value>.
* 219199: In web.config, ResponsePollingInterval is 3600000.
* 219200: Model.EstimatedMemory gave too large estimate for models with lot of event types.
* 219222: AggregateOthers didn't work with MaximumRowCount when dimensions is null in expression analysis.
* 219276: It should be possible to set filter to be model default filter when the filter is created.
* 219280: It should be possible to delete model default filter.
* 219275: Changing model default filter should only be possible for ManageViews permission.
* 219297: Designer user can delete other people published filter from web UI but cannot delete it from PA Excel Client.
* 219285: Expression filter gives "Value was either too large or too small for an Int32".
* 219304: Expression analysis returning DataFrame doesn't work in SQL script that prints to Excel sheet.
* 219251: Sample files removed from \\Release\Files\OfficeAddIns\Excel\Example Data.
* 219293: AnalyzeConformance function throws KeyNotFoundException - variation data missing.
* 219261: Restored model model could not be open.
* 219271: Invalid security notification when using Excel client.
* 219298: X-Forwarded-For handled incorrectly in Functions.GetClientIpAddress.
* 219305: Decimal datatype caused problems in the expression language.
* 219323: Delete operation deleted unexpected project, models and datatables.
* 219337: EventTypes in ModelInformation in PA response should contain entire model data.
* 219339: Expression language: If statement without false statement causes an exception if the condition is false.
* 219172: Invalid filterId causes "Internal server error" and " Method Not allow" error.
* 219258: Exception message is not shown properly in PA Web UI for FaultException.
* 219281: Improving the error handling for invalid ModelId.
* 219284: Client side forces filterId=0 even if filter is not mentioned.
* 219313: After adding the same existing panel twice, not possible to delete it from the view.
* 219320: Duplicate id on PanelDesigner field-properties.html template.
* 219336: When PAPO is added from tool palette, InfluenceAttributeTypeId variable contains invalid value "20" (should be empty).


== QPR ProcessAnalyzer 2020.1 (release date 2020-01-21) ==  
== QPR ProcessAnalyzer 2024.6 (build 7414) (released 2024-09-18) ==  
Build number: 2020.1.0.40909, Model compatibility version: 3, Database version: 65, PACM file version: 7, Protocol version: 32.


'''Features:'''
'''Features:'''
* 307749: Support for importing data to the datatable models.
* B-08366: Frontend for [[Object-centric_Process_Mining_Model|OCPM model]] configuration and Snowflake charts using perspectives.
* 307813: DataSourceType parameter to --#ImportEvents and --#ImportCaseAttributes ETL scripting commands.
* B-08365: Added following visual settings for [[QPR_ProcessAnalyzer_KPI_Card|KPI Card]]: font size, text color, text styles, vertical and horizontal alignment.
* 307743: Backend support for saving the new filters.
* B-08382: Measures, dimensions and columns can be duplicated in [[QPR_ProcessAnalyzer_Chart#Measure,_Dimension_and_Column_Settings|chart settings]].
* 307775: Effective dashboard permissions are included to dashboard definition when fetched from the server.
* B-08381: [[QPR_ProcessAnalyzer_Table|Table]] vertical scrollbar is now hidden when table is not scrollable.
* 307772: Dashboard project path is added to dashboard definition when fetched from the server.
* B-08355: Expression language identifiers are primarily assumed as variables and secondarily as property names.
* 307778: When saving a view, the view is not anymore reloaded unnecessary.
* B-08402: QPR ProcessAnalyzer can now connect to Snowflake when running in Snowpark Container Services.
* 307810: Expression language adjustments.
* B-08389: Added support for making multiple Snowflake queries in same request for OCPM queries.
* 307818: Drop support for QPR ProcessAnalyzer Excel Client for Excel 2013.
* B-08416: Improved backend functionality for partially configured OCEL models.
* B-08428: Improved Snowflake calculation performance by including to filter cache tables only the event table key (this behavior can be opt-in with a [[PA_Configuration_database_table#CacheOnlyPrimaryKeysForFilters|CacheOnlyPrimaryKeysForFilters setting]]).
* B-08448: Add configuration to disable event cache tables storing primary key only.
* B-08340: New users don't have a default model selected when login for the first time.
* B-08413: Frontend components have been updated.
* B-08397: Backend components have been updated.
* B-08398: Updated translations for release 2024.6.


'''Fixed bugs:'''
'''Fixed issues:'''
* 219236: Microsoft.AspNet.Identity.Core.dll and Microsoft.AspNet.Identity.Core.xml files missing when installing QPR ScriptLauncher from the installation package.
* D-14209: Fixed issue where moving projects in Workspace was not possible.
* 219291: QPR ProcessAnalyzer didn't work in https only configuration.
* D-14186: Highcharts visualizations datalabel texts were incorrectly shown over tooltips.
* 219264: DataFrameMode enabled for KPI analysis even if Values have been defined (but Dimensions is empty).
* D-14210: Fixes for issue with incorrectly shown pending tasks in System Reports.
* 219223: Variable function don't work with upper case variables.
* D-14242: SqlDataFrame Persist function now keeps the original column types even if they are changed.
* 219267: Viewing DataFrame contents in KPI analysis gives incorrect results.
* D-14147: Snowflake queries gave "Object reference not set to an instance of an object" error with MaximumRowCount higher than 2 billion.
* 219279: DataFrame columns by name is unavailable inside user defined functions in KPI analysis.
* D-14189: Dropdown list component gave following error when clicking Add button for "List items": Cannot read properties of undefined (reading 'axisLabel').
* 219259: It should be possible to enable CORS from all origins.
* D-14192: Datagrid paging settings are now preserved when resizing or zooming window.
* 219274: "Inconsistent or unavailable ids" error when using all cases filter.
* D-14214: In System reports, dropdown list showing dashboards didn't open if there were more than 1000 dashboards.
* 219290: Getting contents of a dashboard is slow in a customer environment.
* D-14218: CSV file import didn't detect existing column correctly when there was difference only in letter case.
* 219286: User could not open any models after using broken model.
* D-14184: Giving ScriptText or ScriptFileName as parameter for QPR ScriptLauncher created a broken script.
* 219227: Slowness in model creation when read data from datasource - event cost calculation improvements.
* D-14220: AI assistant gave strange error message when trying to explain chart showing error.
* 219250: Slowness in event creation when read data from datasource - group by event sorting.
* D-14135: Expression based Snowflake filter rule caused error "Object reference not set to an instance of an object".
* 219292: Performance issue in /api/uielements as it unnecessarily fetched dashboard contents.
* D-14229: In Snowflake, disabled filter rules didn't affect header object counts when there were several filter rules.
* 219295: Client side fix for 219292.
* D-14228: In Models and Model statistics reports, columns showing case and event attributes didn't work.
* 219269: Query results were handled incorrectly in the client side - datatype is cell specific, not column specific.
* D-14213: In User Settings dialog, Effective Permissions settings are now preserved while dialog is open.
* D-14227: Fixed issue where applying chart settings in System reports made settings pane empty.
* D-14185: Stack traces were incorrectly returned even if IncludeExceptionDetailsInErrors was false.
* D-14226: Fixed several OCPM calculation related issues in backend.
* D-13943: Added error message to Case attribute selector when model doesn't have selected case attribute.
* D-14162: Expression "0.()" gave null reference error.
* D-14246: Chart setting dialog may have been partly out of screen when activating other chart while in dashboard is scrolled.
* D-14238: Snowflake chart measure aggregation is incorrectly affected by statistical calculations.
* D-14133: In Snowflake chart, events Aggregate settings caused JaveScript error and UI messed up.
* D-14172: Fixed issue where validation error appeared when copying and moving elements in Design Diagram.
* D-14253: Table didn't show column filter icon when column name was empty.


== Additional QPR ProcessAnalyzer 2019.9 (release date 2019-12-18) ==  
== Additional release for QPR ProcessAnalyzer 2024.5 (build 6814) (released 2024-07-01) ==
Build number: 2019.9.0.40754, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Known issue: It's not possible to move projects that existed before updating to this release. The issue will be fixed in the next release. There is a following workaround available: Administrator user can go to the [[Navigation_Menu#Expression_Designer|Expression Designer]] and run the following expression: '''Projects.Modify(#{})'''.
</div>


'''Notes'''
'''Fixed issues:'''
* Starting from QPR ProcessAnalyzer 2019.9 the separately installed QPR UI is not needed anymore. Instead, the web UI is now part of QPR ProcessAnalyzer and does not require a separate installation. The new UI can be accessed in ''http(s)://SERVER/QPRPA/ui/'' (where SERVER is the hostname of your QPR ProcessAnalyzer server). Dashboards in the old QPR UI are not moved automatically to QPR ProcessAnalyzer, and also the QPR UI dashboard export files are not compatible with the new QPR ProcessAnalyzer UI.
* D-14191: Running script by id failed on data import when parameters contained ScriptId.
* D-14183: Fixed issue where flowchart SVG export only exported the visible part of flowchart.


'''Features for QPR ProcessAnalyzer:'''
== Additional release for QPR ProcessAnalyzer 2024.5 (build 6769) (released 2024-06-27)==
* 307785: Angular Migration: Migrate ProcessAnalyserService.
* 307786: Angular Migration: Migrate FieldPropertiesUtils.


'''Fixed bugs for QPR ProcessAnalyzer:'''
'''Features:'''
* 219262: Login to PA UI is not possible when there is + character in the password
* 219263: Opening dashboard which definition is large
* 219257: It should be possible to get DataFrame cell value by column name in expression analysis


== QPR ProcessAnalyzer 2019.9 (release date 2019-12-10) ==
*B-08388: Added backend support for OCPM model perspectives to convert object-centric eventlogs into case-centric.
Build number: 2019.9.0.40704, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.


'''Features for QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 307484: Implemented Excel client protocol version for improved compatibility for older Excel Clients.
* 307564: [[Web.config_file_in_QPR_ProcessAnalyzer|Case sampling]] is disabled by default.
* 307724: There is a support for self-signed certificate for QPR ProcessAnalyzer service.
* 307705: User related information and session id is available for HTML presentation objects.
* 307712: Error messages from the backend are shown in UI
* 307750: PA UI Frontend (part 3)


'''Fixed bugs for QPR ProcessAnalyzer:'''
*D-14187: Creating local datatables was not possible in Workspace if datatables were stored to the configuration database (i.e., SqlServerConnectionString setting is not used).
* 219170: Conformance checking didn't work when there is a non-existing bpmn task between parallel gateway and the end event.
* 219152: Loading model into memory doesn't anymore require a ResetModelCache permission.
* 219213: Improved model loading performance when using ODBC, datatable and expression datasources.
* 219218: Order of the comparison rules incorrectly affected the influence analysis results.
* 219240: Import model or export model from filter gave "Input string was not in a correct format" error.
* 219238: Fix for error message "CommunicationException: The remote host closed the connection".
* 219249: Access was incorrectly denied for non system admins when saving a new dashboard.


== QPR ProcessAnalyzer 2019.8 (release date 2019-10-30) ==  
==QPR ProcessAnalyzer 2024.5 (build 6746) (released 2024-06-25)==
Build number: 2019.8.0.40391, Model compatibility version: 2, Database version: 62, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307633: [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_Datatables|Datatables]] can be used as a PA model datasource (part 1).
*B-08338: Added reports to monitor dashboards usage: Popular dashboards, Dashboards by users and by time, and specific dashboard usage.
* 307700: JSON filter rules should not give error for non-existing values, such as event type names.
*B-08314: Snowflake connection string can be [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Connection|specified for each project]] to allow projects connecting to different Snowflake accounts, databases or schemas.
* 307721: Improvements to model [[QPR_ProcessAnalyzer_Model_JSON_Settings#Automatic_Loading_on_Server_Startup|Improvements to model LoadOnStartup]]: loading is done in a separate thread and in parallel.
*B-08341: Added [[SQL_Expressions#GetRelatedValueFrom_function|GetRelatedValueFrom]] and [[SQL_Expressions#AggregateRelatedValueFrom_function|AggregateRelatedValueFrom]] SQL expression functions to extend models data with additional tables.
* 307693: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language|Expression language: Return attributes in alphabetical order]].
*B-08301: In chart settings, selecting another measure/dimension/column now doesn't reset settings.
* 307738: Expression language: [[QPR_ProcessAnalyzer_Expressions#Null_conditional_operator_.28.3F._and_.3F:.29 | null-conditional]] and [[QPR_ProcessAnalyzer_Expressions#Null_coalescing_operator_.28.3F.3F.29 | null-coalescing operators]].
*B-08317: Added Snowflake presets for Root Causes for Attributes in table and detailed table format.
* 307725: Expression language: AsParallel function for making calculations in parallel to improve performance.
*B-08318: Improved Snowflake Events preset performance by adding a filter that picks a subset of cases.
* 307715: New PA Web UI Backend (part 3).
*B-08385: Open AI default large language model has been changed to "gpt-4o".
* 307728: New PA Web UI Backend (part 4).
*B-08342: Added DashboardName and DashboardProjectName properties to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
*B-08320: Added RenameAllColumns function to dataframes to easily rename all columns.
* B-08321: Added DataSourceConnection property to dataframes in expression language.
*B-08307: Finetuned Workspace functionality for models that don't have datasource defined.
*B-08329: Optimized metadata queries to Snowflake to improve performance.
*B-08311: Changed QPR ScriptLauncher interaction with the server by changing long polling to short calls to improve robustness.
*B-08368: Implemented backend support for configuring and importing OCPM models.
*B-08352: Frontend components have been updated.
* B-08348: Backend components have been updated.
*B-08349: Updated translations for release 2024.5.


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


== QPR ProcessAnalyzer 2019.7 (release date 2019-09-25) ==  
==QPR ProcessAnalyzer 2024.4 (build 6246) (released 2024-05-14)==
Build number: 2019.7.0.40226, Model compatibility version: 2, Database version: 61, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
'''Features:'''
* 307655: Drop support for SQL core as PA data source (Part 5 Memory optimization).
*B-08227: Dashboards have [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] (powered by ChatGPT) helping users in process analysis. AI Assistant can answer general questions about the process, create filters based on user prompt, and explain charts and analyses.
* 307696: New PA Web UI Backend.
*B-08277: QPR ProcessAnalyzer now detects automatically when cases or events data in Snowflake updates. Check is done every 5 minutes which is the maximum delay of detecting new data. ([[Snowflake_Connection_Configuration#Automatic_data_update_detection|more information]])
* 307710: New PA Web UI Backend (part 2).
*B-08322: OpenAI model name can be configured by administrator. The model is used by the AI Assistant and (by default) the OpenAIChatCompletion function.
*B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
*B-08276: Adjusted permissions for [[Roles_and_Permissions#Project_Permissions|moving projects]].
*B-08310: Added Details property to [[Generic_Objects_in_Expression_Language#Exception|Exception object]] in expression language.
*B-08328: Language translations have been updated to 2024.4.
*B-08312: Frontend components have been updated.
*B-08308: Backend components have been updated.


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


== QPR ProcessAnalyzer 2019.6 (release date 2019-08-08) ==  
==QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)==
Build number: 2019.6.0.40009, Model compatibility version: 2, Database version: 59, PACM file version: 7.


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


'''Fixed bugs for QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 219106: Datetime ticks property in the expression language should be in UTC.
*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.


== QPR ProcessAnalyzer 2019.5 (release date 2019-06-19) ==  
==Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)==
Build number: 2019.5.0.39902, Model compatibility version: 2, Database version: 59, PACM file version: 7.


'''Features for QPR ProcessAnalyzer UI:'''
'''Features:'''
* 307330: Filtering renewal: PAPO.
* 307638: Angular Migration: Migrate Analysis classes part 3.
* 307653: Angular Migration: Migrate Analysis classes part 4.


'''Features for QPR ProcessAnalyzer:'''
*B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.
* 307649: Drop support for SQL core as PA data source (Part 4 Source code removal).


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
'''Fixed issues:'''  
* 219040: Clustering analysis expression doesn't take into account model without any case attributes.
* 219001: Case Analysis always limited to 1000 rows (other analyses have the same problem).
* 219042: PAPO: "Influence Analysis for Case Attributes", value is rounded to closest integer.
* 218944: PAPO: Recycle bin icon in filter rule name is not visible when there is long text without spaces.
* 219041: When duration limit 0, filters made from duration beams don't work.
* 219099: Datetimes in expression language query don't show fraction of seconds (QPR UI).
* 219103: PAPO: context menu is not working in KPI analysis.


'''Fixed bugs in QPR ProcessAnalyzer:'''
*D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.
* 219062: GetModels is slow for admin.
* 218978: Odd 1 million filter is adapted once you remove your custom filter.
* 219015: Script Launcher million rows limit when exporting to excel csv.
* 219022: GetModelAsStream webservice not support modelId.
* 219080: JSON filtering does not work with flowchart analysis.
* 219087: Increase from 1GB to 2GB limit in PA webservice.
* 219032: PAPO Variation Analysis is not drawn.
* 219017: Datetimes in expression language query don't show fraction of seconds (PA CORE).


== Additional Release for QPR ProcessAnalyzer 2019.4 (release date 2019-05-31) ==
==QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)==
Build number: 2019.4.0.39800, Model compatibility version: 2, Database version: 59, PACM file version: 7.


'''Fixed bugs in QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219078: PAPO loses saved filter when changing analysis
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.
* 219000: User with only Analyzer role can see and use private filter created by Administrator.
</div>
* 219049: Copy of a model with odbc datasource doesn't have filters from the original model.
* 219044: Calculated case attributes don't work with odbc model without defined cases.


'''Features for QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307611: Drop support of PAIK.
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).
* 307636: Drop PA Excel client support for Excel 2010, Windows 7 and Windows 8.1.
</div>
* 307628: Drop support for SQL core as PA data source (Part 3 Source code removal).


== QPR ProcessAnalyzer 2019.4 (release date 2019-05-07) ==
'''Features:'''
Build number: 2019.4.0.39420, Model compatibility version: 2, Database version: 58, PACM file version: 7.
*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.


'''Release Highlights''':
'''Fixed issues:'''
* Custom dashboards for QPR ProcessAnalyzer can be browsed and edited more easily, as there is a Dashboards menu item available.
*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.


'''Features for QPR ProcessAnalyzer:'''
==QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10)==
* 307419: Change the database connection type to use in-memory core (PA Core).
* 307324: Drop support for SQL core as PA data source (Part 1: Export from EventLog).
* 307619: Drop support for SQL core as PA data source (Part 2: Remove analysis 26, 27 and 28).
* 307523: Refactor ModelInformation code in PA Core.
* 307613: Quick & Easy memory usage optimizations: PA Core.
* 307618: Prediction capability to expression language.


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 218909: Data grid based analysis jumping.
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.
* 218971: PAPO Variation analysis has both paths and counts at the same time.
</div>
* 218972: PAPO Duration analysis missing the grouped by dimension (default value is not set in analysis).
* 218969: Event attribute "Cost" doesn't work in Profiling Events analysis and in Expression language.
* 219006: Case id's (case names) are interpreted as numbers by PAPO.
* 219027: Numerical attributes are shown as zero decimals in some analysis in data grid presentations.


'''Fixed bugs in QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 218938: Filter rules information is not showing names for odbc loaded models and calculated case/event attributes.
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.
* 218945: PA UI Profiling and Event type analysis with selections costs are lost.
</div>
* 218976: Inconsistency in pre-processing CaseEvents results.
* 219012: Pre-loaded models give null reference exception.
* 219008: Key is not in dictionary is thrown when selecting benchmark case attribute.
* 219034: Model calculation context for expression data source is not initialized correctly.
* 218920: Private filters are visible for other users (which is fine for admins but not for other user types).


== QPR ProcessAnalyzer 2019.3 (release date 2019-03-27) ==
'''Features:'''
Build number: 2019.3.0.38860, Model compatibility version: 2, Database version: 58, PACM file version: 7.
*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|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* B-08163: Linked settings support for binding to [[Chart_Linked_Settings#Binding_to_case_attribute_filters_with_attribute_name_and_attribute_values|case attribute filter values without defining case attribute name]].
*B-08170: Snowflake model filters can be [[Filtering_in_QPR_ProcessAnalyzer#Filter_actions|saved as new models]] which can be used to create snapshots of part of models.
*B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
*B-08161: Added [[Datatable_in_Expression_Language#Modify|Modify]] function to change datatable properties and improved [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CreateDatatable|CreateDatatable]] function for creating datatables.
*B-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 [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
*B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|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, [[Datatable_in_Expression_Language#ForeignKeys|foreign keys]] to other datatables can be defined using expression language.
*B-08176: Translation updates for release 2024.1.
*B-08175: Workspace should show timestamps in user's local time.


'''Release Highlights''':
'''Fixed issues:'''
* It's possible to add [[Calculated_Attributes_in_QPR_ProcessAnalyzer|calculated case and event attributes]] to QPR ProcessAnalyzer models using the expression language. Calculated attributes are created when the model is loaded into memory, and they are available in the analyses like the normal imported attributes. Calculated attributes allow e.g. data conversions and cleansing, and also making calculations beforehand to improve performance.
* D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* QPR ProcessAnalyzer has a new [[Clustering Analysis]], which divides cases into similar groups based in case attributes and occurred types of events. Clustering analysis provides a new way to understand and structure your process mining data.
*D-13916: Chart filter could not be defined for some expressions in Big data chart.
* In the expression language, the left out rows can be [[QPR_ProcessAnalyzer_Expression_Analysis#Expression_Analysis_JSON_Configuration|aggregated as the last row]], which is useful, e.g. when you want to present only the most important data but still see the total amount of cases in the model. Also ChartView contains a new setting Group and Show Others using this expression language feature.
*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.


'''Features for QPR ProcessAnalyzer UI:'''
==QPR ProcessAnalyzer 2023.7 (build 4326) (released 2023-11-28)==
* 307507: Disable rectangular selection in flowchart.


'''Features for QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307545: KPI: Clustering analysis and related utility functions.
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.
* 307512: Expression language: Description attribute to Model.
</div>
* 306900: Calculated case and event attributes.
* 307533: Level of event log pre-processing can be set for [[QPR_ProcessAnalyzer_Expression_Analysis#KPI_Analysis_JSON_Configuration |expression analysis]].
* 307575: [[Web.config_file_in_QPR_ProcessAnalyzer#Qpr.ProcessAnalyzer.Common.Properties.Settings_Section |Change items memory caching times]].
* Support for Windows 8 has been dropped. Windows 8.1 is still supported.


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 218863: Model manager not updated after changing Filter Id.
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.
* 218874: Sorting and filtering icons overlap in datagrid.
</div>
* 218922: There should be default maximum number of items for different analyses created from tool palette.
* 218723: Empty analysis window after error thrown by PA service.


'''Fixed bugs in QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 218908: Wrong Client data in operation log.
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.
* 218928: Expression filter doesn't work with integers.
</div>
* 218940: Model eventlog can drop from memory.
* 218927: JSON filtering for case attributes doesn't work with nulls.
* 218779: Source data formatted to two decimals accuracy but PA total cost flowchart show much more decimals.
* 218943: ODBC SQL boolean values does not work with filter CaseAttributeValue.
* 218965: Accessing calculated event attribute value from EventType.Events -property does not work.


== QPR ProcessAnalyzer 2019.2 (release date 2019-02-14) ==
'''Features:'''
Build number: 2019.2.0.38539, Model compatibility version: 2, Database version: 58, PACM file version: 7.
* 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.
*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.
*B-08091: When filtering charts in Snowflake, case attribute filter is created instead of case id filter.
*B-08091: [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|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 [[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.
*B-08017: [[Dashboard_in_Expression_Language|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 [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|user objects]] in expression language: IsLocked, LastLockedDate, LastLoginDate.
*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]].
*B-08151: For Snowflake expressions support for following [[SQL_Expressions#Window_functions|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.


'''Release Highlights''':
'''Fixed issues:'''
* Support for [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Excel_Client| Microsoft Office 2019]] for QPR ProcessAnalyzer Excel Client.
*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.


'''Features for QPR ProcessAnalyzer:'''
==Additional release for QPR ProcessAnalyzer 2023.6 (build 3933) (released 2023-10-24)==
* 307423: Improved memory management: unused objects are automatically dropped from the memory. Settings can be configured in [[Web.config_file_in_QPR_ProcessAnalyzer#Qpr.ProcessAnalyzer.Common.Properties.Settings_Section | web.config]] or from the [[QPR_ProcessAnalyzer_Model_JSON_Settings#Memory_Usage_Settings | model JSON settings]].


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
'''Features:'''
* 218838: KPI analysis: Event Occurrence Time isn't calculated properly, e.g. Period=Month fails.
*B-08055: Error message for locked account has been replaced with generic error message, so that username enumeration is not possible.


'''Fixed bugs in QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 218880: PAPO: odbc case and event attributes are not shown in dropdown menu.
*D-13884: Attributes dialog crashed with some older model configurations.
* 218877: Support material - Project admins are not able to create new users.
*D-13843: In charts, selected case and event attributes switched away when attribute data type was ShortString.
* 218898: Importing XES file with xmlns -definition fails.
* D-13877: Some Snowflake expressions gave error "exceeds maximum length limit of 255 characters" when selecting lot of items.
* 218893: Model status shows incorrectly "offline" when Model event log is in memory and Model information not.
*D-13878: Snowflake expression filters for case attribute values didn't accept other than string type of case attributes.
* 218917: BaseContext.EvaluateChildExpression with given root object iterates the root object if it is an array.
*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.


== Additional Release for QPR ProcessAnalyzer 2019.1 (release date 2019-01-23) ==
== QPR ProcessAnalyzer 2023.6 (build 3847) (released 2023-10-17)==
Build number: 2019.1.0.38400, Model compatibility version: 2, Database version: 58, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
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>


* 307357: PA model management: Analysis requests canceling. All operations have new parameters QueryIdentifier and CancelEarlierQueriesWithIdentifier.
'''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: [[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.
*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 bugs in QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 218806: Variation filter doesn't filter correctly.
*D-13830: Object counts indicator in header showed incorrect counts when there was disabled filter rules in Snowflake models.
* 218802: It should not be able to load deleted models into memory.
*D-13833: In-memory charts didn't work with boolean type of dimensions when filtering with the false value.
* 218866: Case Analysis shows "0" for textual Case Attribute (SelectedActivityCounts=0 column count and data not match).
*D-13858: Target value measures didn't update chart when controlled using an on-screen setting.
* 218862: Case Analysis returns incorrect Start and End times when start or end transition is selected.
*D-13827: Calculated attributes data type was incorrectly set as Any by the Attributes dialog.
* 218847: Variation Analysis Include Only Cases Filter Fails when using Event Counts and filter.
* D-13849: Multiselect list search didn't allow spaces.
* 218765: Event Occurrence Time calculation for KPI analysis (Server side).
*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.


== QPR ProcessAnalyzer 2019.1 (release date 2019-01-03) ==
==Additional release for QPR ProcessAnalyzer 2023.5 (build 3334) (released 2023-09-07)==
Build number: 2019.1.0.38310, Model compatibility version: 2, Database version: 58, PACM file version: 7.


'''Release Highlights''':
'''Fixed issues:'''
* There are new training videos available for QPR ProcessAnalyzer in QPR Community. QPR ProcessAnalyzer users can access the videos by clicking Training Videos in the header menu of QPR ProcessAnalyzer UI.
* 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.
* ChartView can show several measures at the same time. In table, measures are in different columns, and in chart, measures are presented as different series.
*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.


'''Fixed bugs for QPR ProcessAnalyzer UI:'''
== QPR ProcessAnalyzer 2023.5 (build 3304) (released 2023-09-05)==
* 218768: Number of decimals is not updated in KPI analysis due to HistoryId context variable.
* 218787: Datagrid export fails with numerical values.
* 218757: KPI analysis - null value shown as NaN.0 in table.
* 218794: Popup menu is replicated when PAPO is drawn multiple times.
* 218740: Case Analysis Year period should not show thousand separator.
* 218805: Analysis not shown after adding duration analysis to panel using view designer "shortcuts buttons".
* 218804: PAPO showing only Analysis Window doesn't show anything when other PAPO hides the Analysis window.
* 218815: Flowchart influence analysis does not always show the results in an identical way.
* 218791: Flowcharts visibility stepper don't work in PA deployment package Process benchmarking view.
* 218844: KPI Analysis sorting is not saved to the context variable.


'''Fixed bugs in QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 218755: If user selects Influence Analysis for Case Attributes into analysis window, it freezes the analysis window completely.
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.
* 218756: PA model - with event attributes - without case attributes = event attributes shown in profiling case attributes analysis.


== QPR ProcessAnalyzer 2018.8 (release date 2018-11-29) ==
Exmaple: Old configuration:
Build number: 2018.8.0.38236, Model compatibility version: 2, Database version: 58, PACM file version: 7.
<pre>
"colorMappings": {
  "1": "#36d475ff",
  "0": "#f5403bff"
}
</pre>
New configuration:
<pre>
"colorMappings": {
  "true": "#36d475ff",
  "false": "#f5403bff"
}
</pre>
</div>


'''Release Highlights''':
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* New types of charts have been added to the KPI Analysis in PAPO. In addition to the previously available column chart and table presentations, there are now bar, donut, area, line and spline charts.
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).
* Tool palette contains now items for each QPR ProcessAnalyzer analysis making it easier to create dashboards with different analyses. The analyses have also needed context variables predefined so that settings are saved to the dashboard.
</div>
* Duration Influence Analysis is now calculated in the memory which makes it significantly faster than previously when it was calculated in the SQL Server.


'''Features for QPR ProcessAnalyzer UI:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307398: More chart types to KPI analysis, such as line chart, bar chart and donut chart.
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]].
* 307473: PAPO tables exporting to Excel, Word and PDF


'''Features for QPR ProcessAnalyzer:'''
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):
* 307417: Duration Influence Analysis in In-Memory.
<pre>
* 307458: Performance improvement in reusing event logs.
let removedAnalyses = [12, 14, 15, 16, 29];
* 307456: Expression language plugin mechanism.
OrderByDescending(Flatten(Projects.Scripts).Where({
* 307459: [[QPR_ProcessAnalyzer_Web_Service_API#Functions_in_the_Web_Service_API|PA service support for script generated reports as csv file (for QPR UI Script Manager)]].
  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>


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 218711: PAPO duration analysis is failing.
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.
* 218663: PAPO - KPI Analysis - Number of decimals effects column height.
</div>
* 218664: PAPO - KPI Analysis - Default number of decimals in the drop-down list should be 1.
* 218669: PAPO - KPI Analysis duration from - to.
* 218557: PAPO - Duplicate flows when increasing the flow amounts in flowchart.
* 218718: PAPO - Flowchart sometimes shows portions of the flowchart completely unconnected from start/end nodes of the flowchart.
* 218668: PAPO - KPI Analysis - wrong names in droplist and wrong chart title.
* 218666: PAPO - KPI Analysis - CamelCase column headers.
* 218670: PAPO - KPI Analysis - title Duration between "undefined" and "undefined".  
* 218665: PAPO - KPI Analysis - numerical data should be shown linear on X axis.
* 218629: PAPO - KPI Analysis - Year period should not show thousand separator.
* 218667: PAPO - KPI Analysis - units are missing in table.
* 218725: PAPO - KPI Analysis - NumberOfDecimals should be enabled for numerical case&event attribute.
* 218731: PAPO - layout issue when displaying error message.
* 218747: PAPO - KPI analysis - Column header text is not consistent with x-axis label.
* 218762: PAPO - KPI Analysis - Error message doesn't disappear when switching from wrong selections to correct ones.


'''Fixed bugs in QPR ProcessAnalyzer:'''
'''Features:'''
* 218727: Null values don't work in GroupBy/GroupByValue functions.
* B-07971: Machine learning based [[Clustering_Analysis|Clustering analysis]] can be run in Snowflake.
* 218708: Filtering with duration value 0 does not work in duration analysis.
*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]].
* 218770: Case analysis with variation Id -> Exception: The given key was not present in the dictionary.
* 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.
* 218771: Conformance: Parallel gateways having multiple branches with only one node aren't analyzed correctly.
*B-08010: To improve performance, charts are loaded and updated only when they are visible in the dashboard.
*B-07975: Added following [[SQL_Expressions#Date_functions|date related functions]] to Snowflake: DayOfYear, DayOfWeek, WeekOfYear, Quarter.
*B-07908: When [[QPR_ProcessAnalyzer_Project_Workspace#Duplicating_Model|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 [[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.
*B-07999: Filters report has been changed to use the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|expression language API for filters]].
*B-07540: Added [[QPR_ProcessAnalyzer_Expressions#Throwing_objects|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).


== QPR ProcessAnalyzer 2018.7 (release date 2018-10-10) ==
'''Fixed issues:'''
Build number: 2018.7.0.38036, Model compatibility version: 2, Database version: 58, PACM file version: 7.
*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.


'''Features for QPR ProcessAnalyzer:'''
==QPR ProcessAnalyzer 2023.4 (build 2628) (released 2023-06-14)==
* 307319: Expression language: [[Generic_Properties_and_Functions_in_QPR_ProcessAnalyzer_Expressions#Other_functions | GroupBy and GroupByValue -functions]].
* 307370: PAPO/A1 cell case/event/event type/variation count should only show cases user has permissions in case level security.
* 307369: String handling functions in the expression language.
* 307424: KPI analysis in generic context.
* 307439: Quick & easy expression language improvements.
* 307336: PA performance improvement (part 1).


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
'''Features:'''
* 218673: Null values in PA expression language should appear as nulls in datasets.
*B-07767: Added [[Gantt_Chart|Gantt chart]] to visualize timeline of cases and events divided into swimlanes.
* 218693: Performance for PAPO's data grids has been optimized.
*B-06383: Added [[Sankey_Chart|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 [[Conformance_Analysis#Top_Deviations_(in-memory)_/_Deviating_Flows_(Snowflake)|reasons for conformance deviations]], such as which event occurrences deviated from the design model.
*B-07909: Snowflake conformance analysis visualizes [[Conformance_Analysis#Undesired_Events_(Snowflake)|undesired event types]] in table and flowchart.
*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.
*B-07891: User interface has been [[Languages_and_Localization|translated into Portuguese]].
*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.
*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.
*B-07912: Added more SQL expression [[SQL_Expressions#Array_functions|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 [[SqlDataFrame_in_Expression_Language#WithClusterColumn|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 [[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 bugs in QPR ProcessAnalyzer:'''
'''Fixed issues:'''
* 218453: .TMP files is not deleted always. After 65k .TMP files exist then PA service stop working. If issue is encountered, workaround is to manually delete .TMP files (e.g. files are located in folder C:\Windows\Temp or C:\Users\<pa_applicationpool_user>\AppData\Local\Temp).
*D-13709: If image width-to-height ratio was lower than container's ratio, image was incorrectly stretched to fit the container.
* 218643: InMemory: Open model after pacm file import fails to "Object reference not set to an instance of an object.".
*D-13660: Disabling filter rules didn't work in Snowflake models.
* 218652: Access denied. Unexpected ModelEventLog dropping object with from cache.
*D-13526: Passing dataframes from SQL scripts to expression scripts didn't work.
* 218648: Import empty model with filter crash (evevenlog.Content is null).
*D-13661: Snowflake conformance analysis crashed when there was no access to conformance related Snowflake UDF's.
* 218685: XES import runs out of memory when importing BPIC2018 -model.
*D-13693: Resolved major Snowflake conformance analysis performance issues in the BPMN model handling.
* 218690: Expressions returning boolean values should be returned to QPR UI as booleans.
*D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
* 218687: Average and Sum functions should return null for zero length arrays instead of zero.
*D-13707: In SQL Scripting, the datatable analysis (number 18) didn't always copy the data table contents to the target table correctly.
* 218705: InMemoryCore: TotalCost in event analysis has incorrect values.
*D-13653: Big data flowchart Root causes preset showed incorrect legend.
* 218704: Mismatch in case counts in Variation Analysis when event type filter has been applied.
*D-13626: Flowchart froze when converting into big data flowchart and vice versa by modifying chart json settings.
* 218709: FileType parameter not select correct stream compression mode in ImportFromStream.
*D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
* 218698: The given key was not present in the dictionary - Variation Analysis error.
* D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
* 218710: PAPO case analysis is currently failing.
* 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 2018.6 (release date 2018-08-29) ==
==Old Releases==
Build number: 2018.6.0.37869, Model compatibility version: 2, Database version: 58, PACM file version: 7.
See older releases in [[QPR ProcessAnalyzer Release Archive]]


'''Release Highlights'''
__NOTOC__
* KPI Analysis update: The KPI Analysis feature has new updates to it. The Analysis Menu design has new options that allow for efficient creation of KPI analysis presentations. Menu items have been grouped into sub-groups making finding analysis options much swifter.
* Model load on startup: You can now define which models are loaded onto memory on startup allowing for quicker setup of QPR ProcessAnalyzer servers. This loads the key models needed directly into memory without any separate in-memory loading.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307351: KPI analysis UI - part 2


'''Features for QPR ProcessAnalyzer:'''
[[Category: QPR ProcessAnalyzer]]
* 307323: Remove old PA web client.
* 307200: [[QPR_ProcessAnalyzer_Model_JSON_Settings#Necessary_IIS_setup |PA model management: PA model automatic loading on startup]].
* 307350: KPI analysis UI - part 2 (server side).
* 307208: PA model management: PA model status information to expression language.
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218391: PA UI Flowchart selection does not clear automatically.
* 218606: Edit mode is ON  > Floating Action Buttons are not clickable.
* 218626: PAPO: some popup menus are not closed properly in IE 11.
* 218607: PAPO: popup menu is not displayed in IE 11.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218597: PA Exception details show null in QPR UI.
* 218575: Incorrect results in conformance analysis calculation.
* 218540: KPI analysis not working properly.
* 218314: Variation analysis shows duplicate variations if there are excluded event types.
* 218604: PA Excel client does not log enough during connection creation.
* 218624: Estimatedmemory not calculated correctly when model not have events.
* 218396: KPI analysis - ApplyAnalysisFilters. InvalidOperationException: Sequence contains no elements.´
* 218628: PAPO: Error popup appears, "Error processing QPR ProcessAnalyzer request.
* 218631: Performance improvements (Path analysis was slow).
* 218485: ProcessAnalyzer Excel client cannot be removed from Programs and Features, as it wont show up there.
* 217775: GetAnalysis(18) should write a progress log entry after each chunk.
* 217653: SQL command not in log when ODBC connection failed.
 
== QPR ProcessAnalyzer 2018.5 (release date 2018-07-17) ==
Build number: 2018.5.0.37716, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights'''
*QPR ProcessAnalyzer Deployment Package for QPR UI: The new version comes with preloaded QPR UI views that can instantly kickstart your Process Mining experience. These views are readymade and require no extra configuration. These views introduce new functionalities, such as ready made conformance views, for deploying a more varied Process Mining offering.
*New Dashboard Design features: Panels can be now instantly developed and evaluated in viewer mode, allowing for a more powerful dashboard creation. The object placing logic has been overhauled, allowing for new options in creating dashboards.
 
'''Features for QPR ProcessAnalyzer:'''
* 307338: [[QPR_ProcessAnalyzer_API:_ResetModelCache | Web service support to load and drop PA models]].
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218536: PAPO: KPI Analysis should not be available from Control Windows.
* 218519: The numerical values in QPR ProcessAnalyzer Influence Analysis were aligned to the left.
* 217888: Selection lost from influence analysis table when user slightly adjusts browser window or panel/presentation object window size.
* 218465: PAPO: Newly created filters are not displayed in the list.
* 218556: PAPO: An unnecessary vertical scrollbar was shown after PAPO Case Analysis was resized.
* 218520: PAPO: Filter does not recognize decimal separators.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218537: ODBC xlsx loading failed with data format issue.
* 218495: Changing default filter does not drop cached model information.
* 218550: Accessing projects from expression language fails in some cases.
* 218549: Datatable import from Excel sheet data corruption if first column value is empty.
* 218558: Errors in default.aspx. Login fails.
 
== QPR ProcessAnalyzer 2018.4 (release date 2018-06-11) ==
Build number: 2018.4.0.37669, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights:'''
* ODBC driver support for QPR ProcessAnalyzer: Use external data sources to create a dynamic model that is updated every time the model is loaded. Using the ODBC driver, the model data can be accessed from a separate data source. All the event data information can be defined in JSON format allowing for automatic model creation.
* KPI Analysis: A new analysis is added to QPR ProcessAnalyzer. KPI Analysis utilizes the KPI expression engine for creating visualizations of data. KPI Analysis is a fully fledged analysis that can be used in conjuction with the existing QPR ProcessAnalyzer analysis for more focused results. In addition, KPI Analysis is available as a separate QPR UI view for creation of dashboards that present real-time data taken from QPR ProcessAnalyzer.
* Tabular Analysis results updated with data types: Analysis featuring tabulated data are now automatically updated with correct data types. Automatic data types allow for exporting the data in a format that can be used in other compatible tools as the data types are automatically defined into the data.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307265: KPI analysis UI - part 1 (KPI).
* 307278: The tabular analyses (e.g. Case analysis) in QPR ProcessAnalyzer UI now have the correct column data types based on the information from the QPR ProcessAnalyzer server.
 
'''Features for QPR ProcessAnalyzer:'''
* 307204: [[QPR_ProcessAnalyzer_Model_JSON_Settings#Model Datasources|Load PA model from ODBC datasource]].
* 307313: Expression language improvements - part 7 (performance).
* 307317: Update new [[QPR_End_User_Software_License_Agreement|EULA]] to QPR ProcessAnalyzer.
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218487: Influence analysis for Flowchart changes the flowchart settings.
* 218498: No history entry is created while changing visibility threshold via stepper or context variable.
* 218508: PAPO variation analysis should limit the queried number of variations.
* 218513: PAPO settings buttons cover analysis content.
* 218532: PAPO: Profiling analysis does not work with data loaded via ODBC.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218515: IIS crashes in kernel during Odbc query reading csv/xlsx file with Microsoft Access Text Driver and Microsoft Excel Driver.
* 218484: ImportEvents fails in StartBackground mode.
* 218525: InMemory CaseAnalysis ShowAllCases not work if there is cases without events.
* 218463: Issue to install excel client (part 2).
 
== QPR ProcessAnalyzer 2018.3 (release date 2018-04-23) ==
Build number: 2018.3.0.37545, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights:'''
*Conformance Checking is supported in QPR ProcessAnalyzer. Using the KPI Expression Language as a basis, process mining models can be compared to BPMN notation and analyzed if the process data conforms to the BPMN design. These results are implemented in ChartView and KPI Expression Language allows them to be implemented into dashboards.
*BPMN Editor has been added to ChartView. You can now import and design BPMN process maps for use in conformance analysis. The BPMN editor is a web component that is used in the browser, allowing for quick and easy process design. The designs can also be exported for further use.
*Flowchart Visibility Settings have been overhauled with a new visual presentation. New stepper elements allow for more flexible flow threshold settings while maintaining a user-friendly approach.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307276: Remove PAPO Offline mode.
* 307193 & 307298: The [[Flowchart_Analysis#Visibility_Settings|Flowchart Visibility Settings]] were improved.
'''Features for QPR ProcessAnalyzer:'''
* 307077: [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server | Support for Windows Server 2016 (PA Service)]].
* 307246: Expression function to calculate conformance to BPMN.
* 307297: Expression language improvements - part 6.
* 307301: In-memory memory usage optimizations.
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218306: PAPO control window is affected by analysis window's 'Show as' setting.
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218241: PA Duration Analysis In-Memory - numbers for Events and Cases too high (focus flow).
* 218456: Issue to install excel client (part 1).
 
== QPR ProcessAnalyzer 2018.2 (release date 2018-03-12) ==
Build number: 2018.2.0.37453, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights:'''
* Case Permissions have been added to the data security featureset. Case Permissions allow for limiting model visibility based on rules that reference the case attributes of a set model. Case permissions can refer to usernames or user groups, creating a link between the attributes and groups.
* Influence Analysis for Case Attributes has been simplified. The feature presents basic information relating to the root causes when it is opened. If further information is needed, this can be accessed via the feature menu.
* DataGrids support Excel exporting. You are now able to export data from fixed dashboards featuring datagrids. With this feature, you can take your data for further manipulation using Microsoft Excel.
* Chartview has been improved with a new layout and excel exporting. The new layout allows for quicker access to creating charts using the ChartView tool. With the exporting functionality, the views created are exported for use in presentations in Microsoft Excel.
* KPI Expression Language has been added with support for Influence Analysis for Case Attributes. This allows for further creation of dashboards with specific analysis result queries. Using the KPI expression language, dashboards can be made to present up-to-date data based on influence analysis results.
* Dataset tag support for data visualization. Adding dataset tags will help in creating more dynamic chart presentations as the data can be inserted into the JSON settings of charts and datagrids.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307220: The Influence Analysis for Case Attributes settings now has a toggle for showing and hiding the detail columns.
 
'''Features for QPR ProcessAnalyzer:'''
* 307273: [[QPR ProcessAnalyzer Web Service API#Example| PA model JSON settings]].
* 307269: [[QPR_ProcessAnalyzer_Model_JSON_Settings#Case_Permissions |Case permissions]].
* 307261: PA InMemory core, part 8 (Path Analysis).
* 307282: PA KPI's and expressions (part 5).
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218426: Using PAPO with customers model crashes PA Server (Entice Changes).
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218371: Event types aren't provided to PAPO by PA server.
* 218372: Having multiple expressions in one selection item in a JSON filter does not work.
* 218375: Empty comparison -setting with nonempty filter -setting causes influence analysis to return incorrect results.
* 218380: PA Activation ends one day before the actual end date.
* 218362: WebService GetAnalysisAsImage does not work.
* 218389, 218397: Performance issues in PA in-memory core with multiple simultaneous users.
* 218412: PercentageNumber property is not set properly in PA analyses.
* 218410: Event attribute profiling event amount mismatch.
* 218404: Using PAPO with customers model crashes PA Server (PA changes).
* 218430: Pre-release mandatory PA bugfixes.
 
== QPR ProcessAnalyzer 2018.1 (release date 2018-01-31) ==
Build number: 2018.1.0.37330, Model compatibility version: 2, Database version: 57, PACM file version: 7.
 
'''Release Highlights:'''
* ChartView is introduced as a new QPR UI view. This interactive view allows the creation of customized charts to answer specific business needs, with measures and dimensions the user has selected. ChartView comes preloaded with numerous different presentation features for the creation of customized charts fit for any business need.
* New Table Filtering for Data Table Views. A new Excel-style filtering feature has been added to the different analysis features, such as Influence Analysis for Case Attributes and Event Analysis. The feature allows the presentation and comparison of different data using robust filters.
* The QPR UI version of QPR ProcessAnalyzer has an overhauled popup menu. Selecting different analysis and creating new filters is quicker and new icons have been added for added clarity.
* XES filetype importing support. The IEEE TaskForce standardized XES logs are now supported by QPR ProcessAnalyzer. This filetype aims to unify the transactional data produced by information systems and makes them usable in tools used in data analysis.
 
'''Full Features for QPR ProcessAnalyzer UI:'''
* 307244: The various tables (e.g. Case Analysis) in QPR ProcessAnalyzer UI received filtering functionality familiar to the one in Microsoft Excel.
* 307163: Popup menu improvements.
* 307224: Cache model information into browser side.
 
'''Features for QPR ProcessAnalyzer:'''
* 307271: PA InMemory core, part 7 (Canceling analysis).
* 307247: XES Event log file format support.
* 307257, 307270: PA KPI's and expressions (part 3, 4).
* 307211: Enable custom data sources: Selections as JSON.
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218327: PAPO Grid view row selection issues when opening popup menu.
* 218328: PAPO Missing null check in ModelState.
* 218365: PAPO: Settings etc. buttons not visible in the latest chrome version (automatically updated).
* 218324: Fixed an issue where a dataset wasn't refreshed when a context variable was changed from PAPO.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218288: PA service installation with DeployPAService.ps1.
* 218291: Problem with --#GetAnalysis type 31 (filter rules).
* 218315: PAPO: InMemoryCore: Offline mode shows incorrect case attribute values.
* 217922: Filtering Flow Table with Case Attribute is too slow.
* 218321: PA core - Internal server error in PAPO when duration analysis result is empty.
* 218322: Flow analysis results not always in same order (InMemory).
* 218340: Not allow to delete default filter ("No access/Access denied").
* 218345: Unknown filter rule. The given key was not present in the dictionary.
* 218363: Attribute values are sent to clients as strings from InMemory profiling analysis.
* 218365: PAPO: Settings etc. buttons not visible in the latest chrome version (automatically updated).
* 218379: PAPO: Side panels visible in multi papo even if they should be closed and invisible.
 
== Old Releases ==
See older releases in [[QPR ProcessAnalyzer Release Archive]]
__NOTOC__

Latest revision as of 17:20, 30 October 2024

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

Next Release: QPR ProcessAnalyzer 2024.8 (planned release date 2024-12-10)

See the next release content.

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

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

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

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

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

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

Features

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

Fixed issues

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

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

Features:

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

Fixed issues:

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

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

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

Fixed issues:

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

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

Features:

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

Fixed issues:

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

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

Features:

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

Fixed issues:

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

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

Features:

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

Fixed issues:

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

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

Features:

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

Fixed issues:

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

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

Features:

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

Fixed issues:

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

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

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

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

Features:

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

Fixed issues:

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

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

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

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

Features:

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

Fixed issues:

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

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.

Old Releases

See older releases in QPR ProcessAnalyzer Release Archive