Skip to Content
Product Information
Author's profile photo Jan Zwickel

Calculation View Features of 2022 QRC3

Within the time frame of 2022 QRC3, 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.

 

Greedy Join Pruning

Greedy join pruning is an expert performance technique that allows pruning to occur independent of join type or cardinality settings. Greedy join pruning can speed up queries considerably when a query involves multiple joins. However, in contrast to join pruning it can have an impact on the results. Therefore, make sure to familiarize yourself with the technique, e.g., in the Developer Performance Guide

 

greedy%20pruning%20options

greedy pruning options

 

Greedy join pruning improves performance by join pruning optimization techniques that can be leveraged by expert calculation view modelers.

The graphical support of greedy join pruning is planned to become available with the SAP Business Application Studio release in October 2022.

 

Lineage/Impact Analysis Across HDI containers

Until now starting a lineage or impact analysis only listed objects within the same HDI container. It is now possible to track the dependency that includes objects that are outside of the current HDI container.

This will provide more detailed insights into data processing and dependencies of calculation view models

 

 

 

Intermediate Data Preview

It is now possible to separate the authorizations to run an intermediate data preview from the authorizations that are required to deploy into a container. With this it becomes easier to debug in e.g., productive containers while preventing the modification of productive objects.

Debugging can now happen with help of a user-provided service based on a database user with the authorizations to run a data preview but without privileges to change objects in the container. See blog for more details

 

start%20intermediate%20data%20preview

start intermediate data preview

 

Using the intermediate data preview also for debugging productive HDI containers can speed-up the time for issue resolution.

 

System-Versioned and Application-Time Tables

When using system-versioned or application-time tables in calculation views, temporal timestamps can now be defined based on constants or input parameters to evaluate data in tables as of a certain timestamp or period. The timestamps can be selected for each individual data source using constants, expressions, or input parameters.

This simplifies time-traveling analytics with focus on data as of a certain time point or period.

 

example%20of%20Temporal%20Source%20setting

example of Temporal Source setting

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Frank de Gang
      Frank de Gang

      Hi Jan,

      Will these improvements also be implemented in the WEBIDE??

      Especially the one concerning system-versioned and application time tables is something we have been asking for many years.

      Regards,

      Frank

       

      Author's profile photo Jan Zwickel
      Jan Zwickel
      Blog Post Author

      Thanks Frank for your feedback!

      At the moment it is not planned to offer temporal tables in Web IDE. However, given your feedback we will re-evaluate potential options to make this feature available on premise as well.

      Best,

      Jan

      Author's profile photo Jan Zwickel
      Jan Zwickel
      Blog Post Author

      Hi Frank,

      we have now released the support of system-versioned and application period time tables by calculation views also in Web IDE with SPS07.

      Best,

      Jan