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

Calculation View Features of QRC4 2021

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.

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%20user%20masking

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%20preview%20with%20different%20user

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%20to%20SQL%20view%20parameter

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%20lag%20value%20based%20on%20input%20parameter

Define lag value based on input parameter

 

value%20shifted%20by%202%20records

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%20filtering

before filtering

 

after%20filtering

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%20help%20all%20visible%20roles

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%20help%20assigned%20roles

value help assigned roles

 

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.