# August 2025

> We simplified data transformations for the SAP Purchase-to-Pay app template by removing redundant dependencies on the Event log and streamlining Common Table Expressions across SQL files. This allows you to define tags and due dates more easily.

## August 20, 2025

### Improvements

#### SAP Purchase-to-Pay app template

We simplified data transformations for the SAP Purchase-to-Pay app template by removing redundant dependencies on the Event log and streamlining Common Table Expressions across SQL files. This allows you to define tags and due dates more easily.

#### CData Sync extractions

We updated the hours format in replication queries that use the `FORMAT` function, changing **hh** to **HH**. For example, `FORMAT([Created], 'yyyy-MM-dd hh:mm:ss')` has been updated to `FORMAT([Created], 'yyyy-MM-dd HH:mm:ss')`.

If applicable, update your queries and rerun the extraction to ensure your data reflects the correct hours in 24-hour format.

:::note
This applies to [Loading data using CData Sync](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/loading-data-using-cdata-sync) and [Loading data using direct connection](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/loading-data-using-direct-connection).
:::

### Support for CData Sync 25.2.9351

We now support **CData Sync 25.2.9351** for [Loading data using CData Sync](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/loading-data-using-cdata-sync). Read more about the updates in the official [CData Sync documentation](https://cdn.cdata.com/help/ASM/sync/2025-03.html).

## August 5, 2025

### Addendum: Added September 2, 2025

#### Logic configuration editor

The following operators are available for aggregate expressions:

* `DISTINCT COUNT`
* `PERCENTAGE`
* `ANY is TRUE`
* `ALL are TRUE`

Check out [Expressions](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/expressions) for more information.

### Improvements

#### Data transformations

* When opening the **Data Transformations** editor, a preview of the input data is now immediately available. You no longer need to run all transformations to see the initial preview.
* Dbt transformations now run only the models that have changed, making the **Apply to dashboards** action faster.

### Other

If you have changed a process name, a message **Data model changed** may pop up when opening the app without performing a new ingestion. This happens because process table names are now automatically derived from the data model. After you close the message, the name of the process table is updated to match the new process name.
