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.
cancel
Showing results for 
Search instead for 
Did you mean: 
jan_zwickel
Product and Topic Expert
Product and Topic Expert
729
Within the time frame of 2021 QRC4 several new calculation view features have been released in SAP Business Application Studio. Some of them are highlighted below.

You can find examples that illustrate the individual features here. An overview of features of other releases can be found here.

Mask columns based on session user


Masking of columns can be done based on the user who is calling the calculation view which contains the mask definition or based on the session user which is running the SQL query.
In a stacked scenario, the calling user will be the owner of the including calculation view while the session user will be the user who runs the SQL query.
To switch between the different modes, use the view-global setting Mask Mode:


session user masking


With the new option to mask based on the session user, masking in stacked scenarios becomes significantly easier.

Preview data with different database user


It is now possible to preview data of calculation views from SAP Business Application Studio using different database users from the list of connections that is maintained in Database Explorer.


data preview with different user


 

This makes testing of different authorizations, e.g., analytic privileges, and session settings, such as client values more convenient.

 

Map input parameters of calculation views to parameters of SQL views


Input parameters can now also be mapped to parameters of SQL views.

 


map input parameter to SQL view parameter


 

This allows passing filter values into SQL views and thus offering more control of how filters are applied.

 

Use Window Functions


Use Window Functions to analyze data based on data partitions. For example, compare a value to a value of some days before for each product:

 


Define lag value based on input parameter


 


value shifted by 2 records


 

Window function nodes provide the flexibility to analyze data that fall inside a certain window using various functions.

 

Filter Elements


Filter elements such as calculated columns or input parameters and thus find elements that are related to a certain topic more easily:

 


before filtering


 


after filtering


 

Use Value Help for roles in Add Data Source dialog


When creating a .hdbgrants file during the Add Data Source dialog (see how to do this e.g., here) roles can be granted. Value help is now available to display:

  • all roles that can be seen by the user defined in the granting service:



value help all visible roles


 

 

  • all roles that are explicitly granted with admin option to the user of the granting service (in the view EFFECTIVE_ROLES, the column IS_GRANTABLE is TRUE):



value help assigned roles


 

This simplifies granting of roles during the Add Data Source dialog.