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.4 (planned release date 2020-05-26) ==  
== Next Release: QPR ProcessAnalyzer 2025.7 (planned 2025-11-11) ==
Build number: 2020.4.0.xxxxx, Model compatibility version: x, Database version: xx, PACM file version: x, Protocol version: xx.
[[Next_Release_Roadmap|See roadmap for next release features and fixes]]


'''Notes:'''
== Latest Release: QPR ProcessAnalyzer 2025.6 (build 10690) (released 2025-10-01) ==
* In QPR ProcessAnalyzer 2020.4, the deployment packages views are embedded to the product, so there is no deployment package any more to be installed. The previous deployment package located in the ''QPR ProcessAnalyzer UI'' project can be deleted.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_6.pdf QPR_ProcessAnalyzer_2025_6.pdf]


'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307859: Deployment package views are embedded to the product.
Known issue: If the [[PA_Configuration_database_table#:~:text=DefaultUiLanguage|DefaultUiLanguage]] system configuration is not defined, users who haven't changed their own language, are unable to login. To prevent this problem, please ensure the DefaultUiLanguage is defined. The next release will fix this issue (D-14706).
* 307899: New function RemoveNulls to remove null values from arrays.
</div>


'''Fixed bugs:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219371: Error message texts has been improved for session expired and unknown error.
Content-Security-Policy (CSP) HTTP header has been updated to enhance security by implementing more restrictive settings. The following directives have been added:
* object-src 'none'
* frame-ancestors 'self'
* form-action 'none'
* base-uri 'none'
* worker-src blob:


== Additional release for QPR ProcessAnalyzer 2020.3 (release date 2020-04-23) ==
These new restrictions may affect usage that has previously been possible. For example, with the new settings, QPR ProcessAnalyzer can be embedded to a website only within the same origin. For detailed instructions on embedding QPR ProcessAnalyzer on a different website, please refer to [[Embed_to_Website|this quide]]. Additionally, for information on modifying the CSP settings, see documentation for [[QPR_ProcessAnalyzer_Security_Hardening#HTTP_Response_Headers|security hardening]].
Build number: 2020.3.0.41450, Model compatibility version: 3, Database version: 71, PACM file version: 7, Protocol version: 33.
</div>


'''Features''':
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 307902 ChartView improvements for 2020.3 hotfix: Custom expressions have by default datatype "auto", added support for binding to multi-select lists in Variable bindings, bugfix: Custom sorting didn't work in presets, bugfix: Aggregation method for Pivot table was not selected correctly.
In the QPR ProcessAnalyzer 2025.6 Native App, the release version number is not displayed correctly in the User Settings dialog. This omission does not have any other complications. QPR ProcessAnalyzer 2025.6 is the only release with this issue, making it possible to identify this release despite the missing version number. This issue is specific to the Native App only. The next release will fix this issue (D-14703).
</div>


'''Fixed bugs:'''
===New features===
* 219370: Dashboards could not be edited by other than administrators.
* [[User_Settings#Starting_dashboard|Starting dashboard]] after login can be defined for user groups, allowing to create customized starting pages for easy navigation. (B-08791)
* 219361: Flowchart sometimes crashed to ThrowKeyNotFoundException when pressing Root Causes button.
* Snowflake [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|chart's event filters]] are now embedded to filters created from chart, to precisely follow chart calculation. (B-08845)
* Result data can be filtered in Snowflake charts using [[QPR_ProcessAnalyzer_Chart#:~:text=Result%20filtering%20expression|result filtering expression]] which works for any datasets. (B-08751)
* Filter rules order now stays the same when making filter selections and confirming filter. (B-08801)
* Added model setting [[QPR_ProcessAnalyzer_Project_Workspace#Hiding_Object_Count_Statistics|Show object count statistics]] to hide object counts information in dropdown lists to optimize performance. (B-08849)
* Added support for [[Chart_On-screen_Settings#:~:text=showStatistics|hiding statistics for on-screen setting]] dropdown lists to improve performance, and in addition the case ID is hidden Case/Event attribute profiling presets. (B-08840)
* Added following audit fields to users and groups: Created date, Created by, Last modified date, and Last modified by. (B-08792)
* Snowflake Native App: Added procedure to that [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Recover_administrator_access|creates administrator user to Native App]] if access to the app has been lost. Also, prevented user management operations that remove own access. (B-08733)
* Snowflake Native App: Added procedure to [[Change_Native_App_Compute_Pool_Size|change Native App compute pool size]]. Changed new Native Apps to use CPU_X64_S size compute pool, and improved Native App stability. (B-08859)


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


'''Notes:'''
===Other improvements===
* 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.
* Added QPR ProcessAnalyzer API request ID to Snowflake queries to easily find matching query in Snowflake query history. (B-08839)
* 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.
* [[QPR_ProcessAnalyzer_Security_Hardening#Added_HTTP_Headers|Content Security Policy HTTP header]] includes now object-src, frame-ancestors, form-action, base-uri, and worker-src. (B-08794)
* Snowflake queries have been optimized by removing null and empty string checks from mapped columns as they are now handled by the model validation check. (B-08837)
* Added backend support for object-centric model filtering based on case-centric filter rules. (B-08836)
* Frontend components have been updated. (B-08851)
* Backend components have been updated. (B-08852)


'''Features:'''
== QPR ProcessAnalyzer 2025.5 (build 10361) (released 2025-08-21) ==
* 307849: Securely stored strings for passwords.
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_5.pdf QPR_ProcessAnalyzer_2025_5.pdf]
* 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.
* 307880: When a datatable model is moved to another project, the linked datatables should also be moved to the project.
* 307556: Functions to expression language to improve usability and performance: CaseCount, EventCount, EventCountByType and Round.
* 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.
* 307888: Error message text changes for Dashboard not found and Multiple dashboards found.
* 307874 & 307887: ChartView and main header has been improved.


'''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.
When using Snowflake Cortex, the AI Assistant is not showing the results table in the assistant's response. This issue has been fixed by the next release.
* 219343: Root causes analysis gave access denied when using Analysis function.
</div>
* 219348: Query cancellation caused database connection leakage.
* 219332: "Thread was being aborted" returned to client while loading model from datatable.
* 219321: Removed unnecessary error log lines "Missing expected HttpRequest X-Forwarded-For" that appeared even if UseXForwardedForAsClientIp=false.
* 219335: [_remove ]._ or empty array is not handled correctly in a KPI dimension.
* 219340: default.aspx does not work.
* 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.
* 219344: Case count view in model manager header and Home view can cause unwanted model loading.
* 219242: Flowchart is not updated correctly after event type filtering.


== QPR ProcessAnalyzer 2020.2 (release date 2020-03-09) ==
===New features===
Build number: 2020.2.0.41129, Model compatibility version: 3, Database version: 67, PACM file version: 7, Protocol version: 33.
* [[Object-Centric_Flowchart|Object-centric flowchart]] can also use object-to-object relations to link events and objects simplifying event-to-object configuration. (B-08671)
* [[AI_Assistant_for_QPR_ProcessAnalyzer|AI Assistant]] can provide precise quantitative analysis by making queries to eventlog data (powered by Snowflake Cortex Analyst and Agents). (B-08652)
* [[Filtering_in_QPR_ProcessAnalyzer|Flows and variations can be filtered]] from any event attribute viewpoint in Snowflake. (B-08737)
* Added [[Project_Properties_Dialog|project properties dialog]] for viewing project information, changing Snowflake connection settings and project secrets. (B-08655)
* [[QPR_ProcessAnalyzer_Project_Workspace#Validating_Model|Model validity check]] easily detects technically invalid models and shows detailed reason for invalidity. (B-08624)
* Projects can be [[QPR_ProcessAnalyzer_Project_Workspace#Exporting_Project|exported]] to json files and imported as new projects. (B-08717)
* Action buttons can be added to dashboard by defining [[Label_and_Link|label component]] that can change dashboard variables and run scripts. (B-08694)
* Web user interface is available in [[Languages_and_Localization|Ukrainian language]]. (B-08734)


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


'''Features:'''
===Other improvements===
* 307779: SAML 2.0 support for PA UI.
* When trying to open dashboard with an invalid model, the precise model validation error message is shown. (B-08629)
* 307789: PAPO now supports ModelId variable and new filters.
* Account locked message is now same as username/password incorrect to prevent account enumeration attack. (B-08740)
* 307854: Filter selector for main header.
* Stringified value format supports also json objects. (B-08766)
* 307844: Improved main header (visible in view designer and workspace) (part 2).
* Event attribute used as event type can be defined for flow and variation filters in Snowflake models (backend support). (B-08705)
* 307820: Improved main header (visible in view designer and workspace).
* Translations have been updated. (B-08757)
* 307840: Model loading script is now run in a security context allowing access to the project. Setting AllowExternalDatasources for disabling ODBC interfaces.
* Frontend components have been updated. (B-08760)
* 307763: Root causes analysis supports multiple case attributes.
* Backend components have been updated. (B-08759)
* 307737: Datatable columns can be queried without loading entire datatable into memory.
* 307780: When user logs in, last used model and default filter of the model is added to the session context.
* 307547: Expression filter rule supports value conversion expression for better compatibility with e.g. date values.
* 307841: Expression language has a new function [[Process_Mining_Objects_in_Expression_Language#Case|Case.DurationBetweenEvents]].
* 307819: Expression language improvements for functions, variables and statements.
* 307827: New function EventsWindow (and expression optimization to take it into use automatically)
* 307794: [[ QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model | GenericWrite permission]] should see model object counts when case level permissions are in use.
* 307776: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|Effective permissions]] can be queried using expression language.
* 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:'''
== QPR ProcessAnalyzer 2025.4 (build 9985) (released 2025-05-28) ==
* 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) ==
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_4.pdf QPR_ProcessAnalyzer_2025_4.pdf]
Build number: 2020.1.0.40909, Model compatibility version: 3, Database version: 65, PACM file version: 7, Protocol version: 32.


'''Features:'''
===New features===
* 307749: Support for importing data to the datatable models.
* Added new AI Agent presets analyzing current state and proposing improvements based on different viewpoints, such as Event and Case Counts, Automation, Bottlenecks, and Root Causes. (B-08710)
* 307813: DataSourceType parameter to --#ImportEvents and --#ImportCaseAttributes ETL scripting commands.
* Added a [[Filter_Selectors#Filter_selector|generic filtering component]] that can be configured for creating any type of filters for distinct values. (B-08654)
* 307743: Backend support for saving the new filters.
* Volume declining in measures due to case sampling can be compensated in chart and flowchart by using a [[Measure,_Dimension_and_Column_Settings#Statistical_calculations|Statistical calculation method]]. (B-08598)
* 307775: Effective dashboard permissions are included to dashboard definition when fetched from the server.
* In object-centric models, Object ID, Event ID, Event timestamp, and Event type [[Object-centric_Process_Mining_Model#Object-centric_perspectives|attribute names]] are shown correctly. (B-08680)
* 307772: Dashboard project path is added to dashboard definition when fetched from the server.
* Snowflake native app has now [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#User_access_to_application|application roles]] for user (for using app) and administrator (for managing app). (B-08660)
* 307778: When saving a view, the view is not anymore reloaded unnecessary.
* For Snowflake native app, IMPORTED PRIVILEGES ON SNOWFLAKE DB privilege is removed and instead the [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Optional_privilege_for_AI_Agent|CORTEX_USER database role]] can be assigned. (B-08718)
* 307810: Expression language adjustments.
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Logging|Native app logging]] has been improved and now sharing application logs with QPR is possible. (B-08661)
* 307818: Drop support for QPR ProcessAnalyzer Excel Client for Excel 2013.
* Added [[DataFrame_in_Expression_Language#CsvToDataFrame|CsvToDataFrame]] function to expression language to convert textual CSV data into in-memory dataframe. (B-08246)


'''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.
* Fixed "Invalid identifier" error when opening attribute selection list for case attribute preset caused by object id columns which differed only by letter capitalization. (D-14539)
* 219291: QPR ProcessAnalyzer didn't work in https only configuration.
* When Image component is clicked in dashboard edit mode, the component is now selected instead of link followed. (D-14525)
* 219264: DataFrameMode enabled for KPI analysis even if Values have been defined (but Dimensions is empty).
* Filters created from dimensions having dimension-specific filter rules will now create expression filter rule where dimensions-specific filter is embedded, for accurately following the selection. (D-14499)
* 219223: Variable function don't work with upper case variables.
* Filtering variations or list of event attribute values didn't work in in-memory models. (D-14476)
* 219267: Viewing DataFrame contents in KPI analysis gives incorrect results.
* Fixed issue where AI Agent didn't update when dashboard variable changed used by prompt chart. (D-14537)
* 219279: DataFrame columns by name is unavailable inside user defined functions in KPI analysis.
* Fixed issue where some statistical calculations inadvertently changed row order when applying in groups. (D-14495)
* 219259: It should be possible to enable CORS from all origins.
* In in-memory models, array type of data was not dimensioned correctly. (D-14518)
* 219274: "Inconsistent or unavailable ids" error when using all cases filter.
* AI Agent Process Variations preset gave "division by zero" error when there were zero cases. (D-14508)
* 219290: Getting contents of a dashboard is slow in a customer environment.
* Table grouping header labels were not formatted correctly. (D-14514)
* 219286: User could not open any models after using broken model.
* Fixed Root causes analysis to work with object-centric models. (D-14515)
* 219227: Slowness in model creation when read data from datasource - event cost calculation improvements.
* Filtering by OcelObjectId didn't work when model didn't have object type table for perspective used in filter. (D-14522)
* 219250: Slowness in event creation when read data from datasource - group by event sorting.
* Fixed Root causes analysis with weighting expression to work with object-centric models. (D-14517)
* 219292: Performance issue in /api/uielements as it unnecessarily fetched dashboard contents.
* Fixed issue where persisting query results where query is started from datatable having custom table name overwrote data in original table. (D-14528)
* 219295: Client side fix for 219292.
* Flowchart SVG export did not show start and end symbols. (D-12401)
* 219269: Query results were handled incorrectly in the client side - datatype is cell specific, not column specific.
* Fixed issue where join operation didn't find renamed columns in SqlDataFrames. (D-14512)
* Improved chart filtering button positions to work with small chart sizes. (D-14509)
* Datatable foreign key columns dictionary data type was incorrect preventing reading columns information. (D-14505)
* Workspace scripts editor allowed to change script code for viewer users (altough not save it). (D-14534)
* In chart custom sorting, trying to refer to measure that had None aggregation, caused SQL compilation error. (D-14526)
* Model validation check crashed when the datatables were in different datasources. (D-14502)


== Additional release for QPR ProcessAnalyzer 2019.9 (release date 2019-12-18) ==
===Other improvements===
Build number: 2019.9.0.40754, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.
* Added expression language functions for using Snowflake Cortex Agents with Cortex Analyst access to query eventlogs. (B-08647)
* Projects can be export and imported in JSON format containing dashboards, models, datatables and scripts. (B-08613)
* Simplified object-centric model queries by accepting OcelObjectId as object attribute name in filters. (B-08702)
* Streamlined import API by removing importMode parameter and changing default fileType to CSV. (B-08704)
* Frontend components have been updated. (B-08695)
* Backend components has been updated. (B-08696)


'''Notes'''
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9805) (released 2025-04-30)==
* 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.


'''Features for QPR ProcessAnalyzer:'''
===New features===
* 307785: Angular Migration: Migrate ProcessAnalyserService.
* Navigation menu is now displaying dashboards from open dashboard's project or from selected Workspace project (earlier dashboards were shown from the selected model's project). (B-08673)
* 307786: Angular Migration: Migrate FieldPropertiesUtils.


'''Fixed bugs for QPR ProcessAnalyzer:'''
===Fixed issues===
* 219262: Login to PA UI is not possible when there is + character in the password
* Fixed issue where AI Agent made unnecessary queries when filtering dashboard, and also opening dashboard with lot of chart may have been slow. (D-14503)
* 219263: Opening dashboard which definition is large
* When datatable columns were modified, queries to the data may have given "Invalid identifier" error. (D-14507)
* 219257: It should be possible to get DataFrame cell value by column name in expression analysis
* Clustering analysis didn't work with object-centric models. (D-14486)
* When a new groups is added, it's selected by default in the Manage Users dialog. Also clicking a selected group does not deselect it. (D-14491)
* Deleting last group didn't remove the group from the list. (D-14504)


== QPR ProcessAnalyzer 2019.9 (release date 2019-12-10) ==  
== Additional release for QPR ProcessAnalyzer 2025.3 (build 9725) (released 2025-04-23)==
Build number: 2019.9.0.40704, Model compatibility version: 2, Database version: 63, PACM file version: 7, Protocol version: 32.


'''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;">
* 307484: Implemented Excel client protocol version for improved compatibility for older Excel Clients.
There is an issue causing some dashboards having more than 50 charts to open slowly. The issue has been fixed in the next release by D-14503.
* 307564: [[Web.config_file_in_QPR_ProcessAnalyzer|Case sampling]] is disabled by default.
</div>
* 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:'''
=== Fixed Issues ===
* 219170: Conformance checking didn't work when there is a non-existing bpmn task between parallel gateway and the end event.
* Fixed issue where system stopped responding after opening Scripts tab several times (error in logs: Timeout expired prior to obtaining a connection from the pool). (D-14506)
* 219152: Loading model into memory doesn't anymore require a ResetModelCache permission.
* Fixed issue where the object-centric models object types tables didn't work without the timestamp column. (B-08683)
* 219213: Improved model loading performance when using ODBC, datatable and expression datasources.
* Snowflake cache tables are now created after initiating calculation is completed to improve performance. (D-14460)
* 219218: Order of the comparison rules incorrectly affected the influence analysis results.
* Fixed issue in User Management where assigning role to project or adding user to group was not saved when there was a column filter. (D-14124)
* 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 2025.3 (build 9699) (released 2025-04-16)==
Build number: 2019.8.0.40391, Model compatibility version: 2, Database version: 62, PACM file version: 7.


'''Features for QPR ProcessAnalyzer:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_3.pdf QPR_ProcessAnalyzer_2025_3.pdf]
* 307633: [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_Datatables|Datatables]] can be used as a PA model datasource (part 1).
* 307700: JSON filter rules should not give error for non-existing values, such as event type names.
* 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.
* 307693: [[QPR_ProcessAnalyzer_Objects_in_Expression_Language|Expression language: Return attributes in alphabetical order]].
* 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]].
* 307725: Expression language: AsParallel function for making calculations in parallel to improve performance.
* 307715: New PA Web UI Backend (part 3).
* 307728: New PA Web UI Backend (part 4).


'''Fixed bugs for QPR ProcessAnalyzer:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* 219210: ScriptLaucher CSV export should quote string values with double quotes when the string value contains semicolon.
There is a potentially serious issue that can cause the system to stop responding, when opening the Scripts tab in the Workspace. The issue has been fixed in the next release (build 9725) by D-14506.
* 219143: IIS https only setup does not work.
</div>
* 219186: Event.IndexInCase had issue with event type filters.
* 219167: Event.OutgoingFlowOccurrence and Event.IncomingFlowOccurrence had issues with event type filters.
* 218689: _.Cases and _.Events doesn't work as a root in EventLog context in KPI Analysis.
* 219004: PA license expiration causes unclear error in UI.
* 219187: KeyNotFound exception occurred when include only all cases from the Path Analysis.
* 219197: Minor issues in ODBC datasource.
* 219207: Flowchart influence analysis does not work properly when using both Filter and Comparison parameters.


== QPR ProcessAnalyzer 2019.7 (release date 2019-09-25) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Build number: 2019.7.0.40226, Model compatibility version: 2, Database version: 61, PACM file version: 7.
Object-centric model simplification in the story B-08667 (object attributes can only have a single value) doesn't work with this release. The issue has been fixed in the next release (build 9725) by B-08683.
</div>


'''Features for QPR ProcessAnalyzer:'''
===New features===
* 307655: Drop support for SQL core as PA data source (Part 5 Memory optimization).
* Enhanced [[AI_Agent|AI Agent]] with UI for editing prompt datasets, and added checkbox to include other charts in dashboard to prompt. (B-08641)
* 307696: New PA Web UI Backend.
* In [[Object-centric_Process_Mining_Model|object-centric models]], object-to-object relations are now followed by traversing once all object types. (B-08606)
* 307710: New PA Web UI Backend (part 2).
* In object-centric models, event type and object type tables are not mandatory anymore, and common attributes can be specified in events and objects tables. (B-08663)
* Object-centric models support simplified structure where object attributes can only have a single value. (B-08667)
* "Object relation steps" setting can be empty to traverse all linked objects in the object-centric model. (B-08668)
* Snowflake Event Types preset has been improved by adding suggestion of desired and undesired activities based on frequency of occurrence. (B-08656)
* Added checkbox for [[Measure,_Dimension_and_Column_Settings#Advanced_settings|disabling filtering]] for individual dimensions or columns. (B-08589)
* Case and event attributes dropdown lists show number of unique values in Snowflake models (instead of attribute datatype as previously). (B-08316)
* [[SAML_2.0_Federated_Authentication|SAML authentication]] can now synchronize user groups from identity provider. (B-08612)
* Groups can be [[Manage_Users_and_Groups#Deleting_Group|deleted]] in user management. (B-08330)
* [[Storing_Secrets_for_Scripts|Secrets]] can be defines as global that can be used by all projects. To set global secrets, [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret|SetSecret]] function works also in the generic context. (B-08599)
* Snowflake [[Clustering_Analysis|Clustering analysis]] shows now number of event occurrences as features describing clusters. (B-08353)
* Model validity check has been extended to find issues in the eventlog data for Snowflake case-centric models. (B-07910)


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


== QPR ProcessAnalyzer 2019.6 (release date 2019-08-08) ==
===Other improvements===
Build number: 2019.6.0.40009, Model compatibility version: 2, Database version: 59, PACM file version: 7.
* Logging has been set to Warning level for Native App to avoid excessive number of log entries to Snowflake events table. (B-08687)
* Datatable duplication is now synchronous in Snowflake until 30 seconds to avoid showing the created duplicate datatable with zero rows while the operation is still in progress. (B-08634)
* Improved Snowflake cache table creation logic when there are multiple simultaneous queries. (B-08622)
* Refactored SQL Server operations to improve robustness and avoid leaking database connections. (B-08649)
* Frontend components have been updated. (B-08638)
* Backend components have been updated. (B-08639)
* Translations have been updated. (B-08640)


'''Features for QPR ProcessAnalyzer:'''
==Additional release for QPR ProcessAnalyzer 2025.2 (build 9476) (released 2025-03-19)==
* 307260: Update to Visual Studio 2017 and update to .Net 4.7.1.


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


== QPR ProcessAnalyzer 2019.5 (release date 2019-06-19) ==  
==QPR ProcessAnalyzer 2025.2 (build 9410) (released 2025-03-05)==
Build number: 2019.5.0.39902, Model compatibility version: 2, Database version: 59, PACM file version: 7.


'''Features for QPR ProcessAnalyzer UI:'''
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_2.pdf QPR_ProcessAnalyzer_2025_2.pdf]
* 307330: Filtering renewal: PAPO.
* 307638: Angular Migration: Migrate Analysis classes part 3.
* 307653: Angular Migration: Migrate Analysis classes part 4.


'''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;">
* 307649: Drop support for SQL core as PA data source (Part 4 Source code removal).
Detection of models with incomplete datasource configuration has been improved, and now models where the event timestamp column type is string, are not anymore considered valid models. Earlier the string type of data was accepted and converted into dates when model was loaded (for in-memory models) or in SQL queries (in Snowflake models).


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
The following query can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] (with System administrator user) to list models where the events datatable timestamp column type is string:
* 219040: Clustering analysis expression doesn't take into account model without any case attributes.
<pre>
* 219001: Case Analysis always limited to 1000 rows (other analyses have the same problem).
Models.Where({
* 219042: PAPO: "Influence Analysis for Case Attributes", value is rounded to closest integer.
let timestampColumn = _.Configuration?.TryGetValue("Datasource")?.TryGetValue("Events")?.TryGetValue("Columns")?.TryGetValue("Timestamp");
* 218944: PAPO: Recycle bin icon in filter rule name is not visible when there is long text without spaces.
return First(_.EventsDatatable?.Columns?.Where(Name==timestampColumn))?.Datatype == "String";
* 219041: When duration limit 0, filters made from duration beams don't work.
}).(Name + " (id: " + Id + ")");
* 219099: Datetimes in expression language query don't show fraction of seconds (QPR UI).
</pre>
* 219103: PAPO: context menu is not working in KPI analysis.
</div>


'''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;">
* 219062: GetModels is slow for admin.
For Snowflake dashboards, table actions to [[QPR_ProcessAnalyzer_Table#Table_actions|set dashboard variables]] now set the variable values in the [[Stringified_Value_Format|stringified format]] instead of as raw values. This makes the variables set by table actions compatible with the [[Chart_Linked_Settings|linked settings]] which also use the stringified format by default for the Snowflake models.
* 218978: Odd 1 million filter is adapted once you remove your custom filter.
</div>
* 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) ==
===New features===
Build number: 2019.4.0.39800, Model compatibility version: 2, Database version: 59, PACM file version: 7.
*Introduced [[AI Agent]] which is a new dashboard component showing LLM generated answers based on user prompt and input data. (B-08556)
*Added [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering by object attributes]] for object-centric models. Filters can be created from dialog or selecting items from charts. (B-08547)
*In object-centric models, object-to-object relations are followed only forward and backward directions. Additionally, there are performance improvements for object-centric models. (B-08577)
*Snowflake warehouse can be [[QPR_ProcessAnalyzer_Project_Workspace#Change_Snowflake_Warehouse_for_Model|specified for each model]] allowing to use optimal type of warehouse for different sizes of models. (B-08610)
*Home screen has been removed, and [[QPR_ProcessAnalyzer_Project_Workspace|Workspace]] has new card layout and other UX improvements. (B-08541)
* Added [[Filtering_in_QPR_ProcessAnalyzer#Saving_filters|filter description]] field to filter properties dialog. (B-08451)
*Removed event type existence check from charts, so that non-existing event types are allowed. (B-08585)
*Snowflake Native App configuration data can be [[QPR_ProcessAnalyzer_Native_App_in_Snowflake#Backup_configuration_data|backed up to a snapshot and restored]]. (B-08591)
*Improved detection of invalid models by adding [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CheckModelValidity|CheckModelValidity]] function returning model validation errors. (B-08426)


'''Fixed bugs in QPR ProcessAnalyzer:'''
===Fixed issues===
* 219078: PAPO loses saved filter when changing analysis
*Prevented following error in Snowflake dashboards: Object "qprpa_dt_cache_..." already exists when creating a cache table. (D-14348)
* 219000: User with only Analyzer role can see and use private filter created by Administrator.
*In-memory chart "Cases filtered by attribute" didn't work for date type of attributes. (D-14387)
* 219049: Copy of a model with odbc datasource doesn't have filters from the original model.
*Fixed issue where each dashboard element resize made element width or height increase when chart margin was more than zero. (D-14361)
* 219044: Calculated case attributes don't work with odbc model without defined cases.
*Chart related buttons are now hidden in datatable content preview. (D-14360)
*Fixed issue where gateway based data import didn't write SAP errors into script log. (D-14351)
* Snowflake chart gave error when "Last Row Aggregates Over-limit Rows" setting was used with list aggregation. (D-14352)
*"Users" system report performance has been improved by adding EffectivePermissionTypesFor function. (D-14266)
*Fixed issue where AI Assistant crashed when used with a model having ODBC or expression datasource. (D-14340)
*Fixed issue where AI Assistant explaining charts crashed when applying to Label component. (D-14344)
*Improved client-side import not to perform redundant datatable configuration data queries. (D-14347)
*Model was incorrectly identified as in-memory model when datatables were missing. (D-14325)
*Model default filter is now in use when model is opened from Workspace. (D-14376)


'''Features for QPR ProcessAnalyzer:'''
===Other improvements===
* 307611: Drop support of PAIK.
*Changed Snowflake charts to store [[QPR_ProcessAnalyzer_Table#Table_actions|variable change actions]] in stringified format to make them compatible with linked settings. (B-08587)
* 307636: Drop PA Excel client support for Excel 2010, Windows 7 and Windows 8.1.
*Backend support for [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|object-centric filter rules Disabled flag]]. (B-08611)
* 307628: Drop support for SQL core as PA data source (Part 3 Source code removal).
*Implemented Entity Framework based database initialization and migrations. (B-08566)
*Added support for following Entity Framework database providers: SQL Server (full), Snowflake Hybrid Tables (experimental), PostgreSQL (experimental). (B-08581)
*Frontend components have been updated. (B-08597)
*Backend components have been updated. (B-08596)
*Translations have been updated for release 2025.2. (B-08607)


== QPR ProcessAnalyzer 2019.4 (release date 2019-05-07) ==  
==QPR ProcessAnalyzer 2025.1 (build 9124) (released 2025-01-23)==
Build number: 2019.4.0.39420, Model compatibility version: 2, Database version: 58, PACM file version: 7.


'''Release Highlights''':
New features presentation: [https://files.qpr.com/releases/QPR_ProcessAnalyzer_2025_1.pdf QPR_ProcessAnalyzer_2025_1.pdf]
* Custom dashboards for QPR ProcessAnalyzer can be browsed and edited more easily, as there is a Dashboards menu item available.


'''Features for QPR ProcessAnalyzer:'''
===New features===
* 307419: Change the database connection type to use in-memory core (PA Core).
*B-08526: Variations and other lists can be visualized with colors, and "List separator" field is available for dimensions and columns.
* 307324: Drop support for SQL core as PA data source (Part 1: Export from EventLog).
*B-08530: Charts can have a [[QPR_ProcessAnalyzer_Chart#Visual_Settings|description text]] which are shown in a dialog when pressing the info button.
* 307619: Drop support for SQL core as PA data source (Part 2: Remove analysis 26, 27 and 28).
*B-08546: Added [[SQL_Expressions#LLMComplete|LlmComplete]] function to access Snowflake Cortex large language models.
* 307523: Refactor ModelInformation code in PA Core.
*B-08439: Added project settings [[QPR_ProcessAnalyzer_Project_Workspace#Project-level_Snowflake_Database_and_Schema|DatabaseNameInDataSource and SchemaNameInDataSource]] to define Snowflake database and schema.
* 307613: Quick & Easy memory usage optimizations: PA Core.
*B-08531: Projects can be created in expression language using [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateProject|CreateProject]] function.
* 307618: Prediction capability to expression language.
*B-08387: Added backend support for object-centric model [[Filtering_in_QPR_ProcessAnalyzer_Queries#Object-centric_filter_rules|filtering for object attributes]].


'''Fixed bugs in QPR ProcessAnalyzer UI:'''
===Fixed issues===
* 218909: Data grid based analysis jumping.
* D-14339: Week numbers showed incorrect year for last dates in the end of year.
* 218971: PAPO Variation analysis has both paths and counts at the same time.
*D-14323: Filtering with "Split data by filtering" dimension didn't work with exclude type of filter rules and when there were multiple filter rules.
* 218972: PAPO Duration analysis missing the grouped by dimension (default value is not set in analysis).
*D-14346: Fixed issue where manual activation using activation utility didn't work.
* 218969: Event attribute "Cost" doesn't work in Profiling Events analysis and in Expression language.
* D-14326: Fixed issue where extra columns in objects table broke object-centric model.
* 219006: Case id's (case names) are interpreted as numbers by PAPO.
*D-14306: Fixed issue when there were both TimeStamp and ToTimeStamp event data columns.
* 219027: Numerical attributes are shown as zero decimals in some analysis in data grid presentations.
* D-14332: Flowchart event type and flow queries are now simultaneous which will improve performance.
*D-14331: Flowchart lost selection when flowchart used linked variables with array values.
*D-14299: Table text filters didn't work in Snowflake (starts with, ends with, contains).
*D-14338: Model.Modify function generated model json configuration that frontend wasn't incompatible with.
*D-14342: Flow step and Zoom settings control have same size and layout is aligned.
*D-14316: Occurrence impact on case duration measure didn't work with certain in-memory models.
*D-14327: AI Assistant had console error when pressing send button without text.
*D-14341: AI Assistant overlapped with BPMN editor in fullscreen mode.
*D-14321: Added error message for AI Assistant when trying to use it without model selected.


'''Fixed bugs in QPR ProcessAnalyzer:'''
===Other improvements===
* 218938: Filter rules information is not showing names for odbc loaded models and calculated case/event attributes.
* B-08391: Datatable access has been optimized improving performance for object-centric models.
* 218945: PA UI Profiling and Event type analysis with selections costs are lost.
*B-08529: Added support for array type in stringified value format.
* 218976: Inconsistency in pre-processing CaseEvents results.
*B-08527: Improved SAP connector error handling and removed assumption for fixed dll file names.
* 219012: Pre-loaded models give null reference exception.
*B-08552: Migrated rest of SQL queries into Entity Framework as preparation for storing configuration data to Snowflake hybrid tables.
* 219008: Key is not in dictionary is thrown when selecting benchmark case attribute.
*B-08544: Frontend components have been updated.
* 219034: Model calculation context for expression data source is not initialized correctly.
*B-08561: Updated translations for release 2025.1.
* 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) ==  
== Old Releases==
Build number: 2019.3.0.38860, Model compatibility version: 2, Database version: 58, PACM file version: 7.
See older releases in [[QPR ProcessAnalyzer Release Archive]]


'''Release Highlights''':
__NOTOC__
* 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.
* 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.
* 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.
 
'''Features for QPR ProcessAnalyzer UI:'''
* 307507: Disable rectangular selection in flowchart.
 
'''Features for QPR ProcessAnalyzer:'''
* 307545: KPI: Clustering analysis and related utility functions.
* 307512: Expression language: Description attribute to Model.
* 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:'''
* 218863: Model manager not updated after changing Filter Id.
* 218874: Sorting and filtering icons overlap in datagrid.
* 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:'''
* 218908: Wrong Client data in operation log.
* 218928: Expression filter doesn't work with integers.
* 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) ==
Build number: 2019.2.0.38539, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights''':
* Support for [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Excel_Client| Microsoft Office 2019]] for QPR ProcessAnalyzer Excel Client.
 
'''Features for QPR ProcessAnalyzer:'''
* 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:'''
* 218838: KPI analysis: Event Occurrence Time isn't calculated properly, e.g. Period=Month fails.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218880: PAPO: odbc case and event attributes are not shown in dropdown menu.
* 218877: Support material - Project admins are not able to create new users.
* 218898: Importing XES file with xmlns -definition fails.
* 218893: Model status shows incorrectly "offline" when Model event log is in memory and Model information not.
* 218917: BaseContext.EvaluateChildExpression with given root object iterates the root object if it is an array.
 
== Additional release for QPR ProcessAnalyzer 2019.1 (release date 2019-01-23) ==
Build number: 2019.1.0.38400, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Features for QPR ProcessAnalyzer:'''
 
* 307357: PA model management: Analysis requests canceling. All operations have new parameters QueryIdentifier and CancelEarlierQueriesWithIdentifier.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 218806: Variation filter doesn't filter correctly.
* 218802: It should not be able to load deleted models into memory.
* 218866: Case Analysis shows "0" for textual Case Attribute (SelectedActivityCounts=0 column count and data not match).
* 218862: Case Analysis returns incorrect Start and End times when start or end transition is selected.
* 218847: Variation Analysis Include Only Cases Filter Fails when using Event Counts and filter.
* 218765: Event Occurrence Time calculation for KPI analysis (Server side).


== QPR ProcessAnalyzer 2019.1 (release date 2019-01-03) ==
[[Category: QPR ProcessAnalyzer]]
Build number: 2019.1.0.38310, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights''':
* 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.
* 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.
 
'''Fixed bugs for QPR ProcessAnalyzer UI:'''
* 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:'''
* 218755: If user selects Influence Analysis for Case Attributes into analysis window, it freezes the analysis window completely.
* 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) ==
Build number: 2018.8.0.38236, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights''':
* 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.
* 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.
* 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:'''
* 307398: More chart types to KPI analysis, such as line chart, bar chart and donut chart.
* 307473: PAPO tables exporting to Excel, Word and PDF
 
'''Features for QPR ProcessAnalyzer:'''
* 307417: Duration Influence Analysis in In-Memory.
* 307458: Performance improvement in reusing event logs.
* 307456: Expression language plugin mechanism.
* 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)]].
 
'''Fixed bugs in QPR ProcessAnalyzer UI:'''
* 218711: PAPO duration analysis is failing.
* 218663: PAPO - KPI Analysis - Number of decimals effects column height.
* 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:'''
* 218727: Null values don't work in GroupBy/GroupByValue functions.
* 218708: Filtering with duration value 0 does not work in duration analysis.
* 218770: Case analysis with variation Id -> Exception: The given key was not present in the dictionary.
* 218771: Conformance: Parallel gateways having multiple branches with only one node aren't analyzed correctly.
 
== QPR ProcessAnalyzer 2018.7 (release date 2018-10-10) ==
Build number: 2018.7.0.38036, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Features for QPR ProcessAnalyzer:'''
* 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:'''
* 218673: Null values in PA expression language should appear as nulls in datasets.
* 218693: Performance for PAPO's data grids has been optimized.
 
'''Fixed bugs in QPR ProcessAnalyzer:'''
* 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).
* 218643: InMemory: Open model after pacm file import fails to "Object reference not set to an instance of an object.".
* 218652: Access denied. Unexpected ModelEventLog dropping object with from cache.
* 218648: Import empty model with filter crash (evevenlog.Content is null).
* 218685: XES import runs out of memory when importing BPIC2018 -model.
* 218690: Expressions returning boolean values should be returned to QPR UI as booleans.
* 218687: Average and Sum functions should return null for zero length arrays instead of zero.
* 218705: InMemoryCore: TotalCost in event analysis has incorrect values.
* 218704: Mismatch in case counts in Variation Analysis when event type filter has been applied.
* 218709: FileType parameter not select correct stream compression mode in ImportFromStream.
* 218698: The given key was not present in the dictionary - Variation Analysis error.
* 218710: PAPO case analysis is currently failing.
 
== QPR ProcessAnalyzer 2018.6 (release date 2018-08-29) ==
Build number: 2018.6.0.37869, Model compatibility version: 2, Database version: 58, PACM file version: 7.
 
'''Release Highlights'''
* 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:'''
* 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 09:49, 5 November 2025

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

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

See roadmap for next release features and fixes

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

New features presentation: QPR_ProcessAnalyzer_2025_6.pdf

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

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

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

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

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

New features

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

Fixed issues

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

Other improvements

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

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

New features presentation: QPR_ProcessAnalyzer_2025_5.pdf

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

New features

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

Fixed issues

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

Other improvements

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

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

New features presentation: QPR_ProcessAnalyzer_2025_4.pdf

New features

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

Fixed issues

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

Other improvements

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

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

New features

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

Fixed issues

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

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

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

Fixed Issues

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

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

New features presentation: QPR_ProcessAnalyzer_2025_3.pdf

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

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

New features

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

Fixed issues

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

Other improvements

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

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

Fixed issues

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

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

New features presentation: QPR_ProcessAnalyzer_2025_2.pdf

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

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

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

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

New features

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

Fixed issues

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

Other improvements

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

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

New features presentation: QPR_ProcessAnalyzer_2025_1.pdf

New features

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

Fixed issues

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

Other improvements

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

Old Releases

See older releases in QPR ProcessAnalyzer Release Archive

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