Within the time frame of 2023 QRC2, 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.
leverage user-defined functions also in
to simplify code reuse and increase development productivity
Time ranges can now also be defined for application-time period tables answering additional temporal table questions.
With QRC2 non-equi joins support also the option "Optimize Join Columns" which can be used to speed up queries and decrease resource consumption.
Data preview can be started directly in SQL Editor mode for faster preview experiences
Whether the data preview should start in the graphical Analysis mode or the Raw data mode can be chosen in the settings of SAP Business Application Studio:
When adding data sources, association information is offered so that associated objects can be easily selected.
When started from the context menu of join nodes information from associations is used to prefill join information if possible. If multiple objects are selected stacked join nodes are generated
User-Defined Functions
leverage user-defined functions also in
- restricted columns
- masking
- non-equi joins
to simplify code reuse and increase development productivity
user-defined function in masking expression
Application-Time Period Tables
Time ranges can now also be defined for application-time period tables answering additional temporal table questions.
time range for application-time period tables
Non-Equi Joins
With QRC2 non-equi joins support also the option "Optimize Join Columns" which can be used to speed up queries and decrease resource consumption.
Optimize Join Columns option
Data Preview
Data preview can be started directly in SQL Editor mode for faster preview experiences
start data preview in SQL Editor mode
Whether the data preview should start in the graphical Analysis mode or the Raw data mode can be chosen in the settings of SAP Business Application Studio:
choose data preview mode
Association information during data source selection
When adding data sources, association information is offered so that associated objects can be easily selected.
show association information
When started from the context menu of join nodes information from associations is used to prefill join information if possible. If multiple objects are selected stacked join nodes are generated
join associated objects
- SAP Managed Tags:
