Within the time frame of 2022 QRC4, several new calculation view features have been released in SAP HANA Cloud that can be used with SAP Business Application Studio. Some of these features are highlighted below. You can find examples that illustrate the individual features here. An overview of features of other releases can be found here.

Filter Mapping

With filter mapping it is possible to define a mapping between columns of two join partners so that when a filter is applied to one column the same filter is also applied on the other column:

filter mapping definition

By applying filters on both sides of the join performance can be improved and it becomes easier to ensure that both join partners provide a consistent data set, e.g., both partners filter on a certain country. For more details about the performance aspect see the Developer Performance Guide. Examples for both aspects, the performance and consistency aspect can be found here. For details how to define the filter mapping, have a look at the Modeling Guide.

Retain Query Snapshots

Per default snapshot data is deleted from snapshot tables during re-deployment of the respective calculation view. You can now explicitly choose to keep existing data in snapshot tables by selecting the flag “Keep Snapshot During Re-deployment”:

keep snapshots during re-deployment

Keeping snapshot data can be useful when testing/working with a fixed set of data or if snapshot data should be stored cumulatively. See the Modeling Guide for more details.

Undo/Redo buttons with list of selected events

With the new Undo/Redo buttons it is now easier to undo and redo actions:

In addition, a drop-down menu is offered that lists selected events to simplify navigation to a certain point in time:

Using Undo and Redo can help to preserve easily work at a fine granularity in addition to more coarse-grained Git commits. More details can be found in the Modeling Guide.