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.
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:
With the new option to mask based on the session user, masking in stacked scenarios becomes significantly easier.
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.
This makes testing of different authorizations, e.g., analytic privileges, and session settings, such as client values more convenient.
Input parameters can now also be mapped to parameters of SQL views.
This allows passing filter values into SQL views and thus offering more control of how filters are applied.
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:
Window function nodes provide the flexibility to analyze data that fall inside a certain window using various functions.
Filter elements such as calculated columns or input parameters and thus find elements that are related to a certain topic more easily:
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:
This simplifies granting of roles during the Add Data Source dialog.
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.
- SAP Managed Tags:
