Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert
Within the time frame of 2023 QRC1, 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.

Some of the features require also a new release of SAP Business Application Studio released beginning of April 2023.

User-Defined Functions in Calculated Columns and Filter Expressions

User-Defined functions can now be used in expressions of filters and calculated columns to e.g.,

  •  pre-process values of input parameters

  •  reuse logic in different calculation views

You can select User-Defined Functions similarly to how you select delivered functions. In the expression editor, the list of User-Defined Functions is structured into two sections: functions in the same project and synonyms that point to User-Defined Functions:

user-defined functions in expressions


Aggregation Attributes

Define for a measure which attributes to include in a query when assembling the query. Information about the expected attributes is stored in the BIMC metadata and can be retrieved from e.g., view BIMC_EXCEPTION_AGGREGATION_ATTRIBUTES_VIEW. It is up to the client tools to evaluate these metadata and to create queries that include these attributes.


The respective attributes can be defined for calculated measures when working on the definition of calculated measures or in the Columns tab of the Semantics node for all type of measures.

define Aggregation Attributes in calculated measures dialog

define Aggregation Attributes in Columns tab of Semantics


Change Sequence of columns in Mapping tab

The sequence in which output columns appear in the Mapping tab can now be individually adjusted by downward and upward buttons:

change sequence of columns in Mapping tab

To move multiple columns at once click on the individual columns while using keyboard key CTRL. Depending on the selected columns the Up or Down buttons can become inactive.

For an overview of options to change the sequence of elements, see changing the sequence of elements  and changing the sequence of data sources in nodes.


Data Preview Enhancement of Table Display

Data Preview mode "Table Display" can now be used without specifying values on the Value axis:

analyze data in Table Display without selecting a measure


Direction of Filter Mapping

It is now possible to define in which direction filters are mapped.

When defining the filter mapping, choose between mapping

  • in both directions

  • only from left to right

  • only from right to left

select direction of filter mapping