Within the time frame of 2024 Q2, several new calculation view features have been released in SAP Business Application Studio when connected to SAP HANA Cloud database QRC2. Some of these features are highlighted below.
Duplicate Window Function Definition
To create multiple window functions that differ only in small details the functionality "Duplicate" can be applied to a window function:
For example, if several window functions should be defined that only differ in one parameter value, this value can be modified after duplicating.
Where Used option for result columns of window functions
The Where Used option provides insights into where the result column of a window function is used within the current calculation view
Copy Calculated Columns to other nodes of the same calculation view
In addition to the option to duplicate calculated columns within nodes, calculated columns can now also be copied to other nodes within the same calculation view. Multiple calculated columns can be copied at the same time:
Copying elements might lead to inconsistent definitions if not all required objects are available at the target node. After pasting the copied elements inconsistent definitions can be detected by manually validating the expressions.
Return all values after ranking
With the new option All Values for Target Value of Rank nodes, all records are returned after ranking and no upper limit definition is required anymore. This provides a means to sort values based on a generated rank column:
Further processing steps can change the sequence of records that is returned by the ranking node. Analogous to SQL, result sets of intermediate nodes do not have an inherent order. The sorting should therefore be defined in the requesting query based on the generated rank column or the result set sort option should be used.
More detailed Outline
The icons of the Outline now include information about the join type of a node.
By clicking on the respective outline node the respective node in the details area is brought into focus so that additional details about the join can be read from there.
Generated Documents with join and expression details
The generated documents now include information about expression definitions as well as more detailed information about the involved joins:
Enhanced Validate Syntax option
The option "Validate Syntax" is now also available for non equi join expressions and allows to validate expressions that include user-defined function:
Secure Calculation View by Structured Filters
Structured filters are an alternative option to structured privileges (.hdbanalyticprivilege) for securing calculation views. The main difference between structured privileges and structured filters is that structured filters are automatically effective for all database users; no assignment of the structured filter to database users is required.
A given view can only be secured by one type of privilege check. You can secure a calculation view
in the Semantics node under View Properties using the option Structured Filter for field Aplpy Privileges:
Keyboard shortcut for metadata refresh
Metadata such as columns of underlying data sources are read when opening a calculation view. Using the metadata refresh option allows to update the metadata of underlying data sources, e.g., if columns have been added to the underlying data sources after opening the calculation view. The metadata refresh can now also be triggered by a keyboard shortcut which is per default CTRL+SHIFT+k.
An alternative keyboard shortcut can be configured under "Settings":
Add Data Source dialog offers last selected data source types
In the Add Data Source dialog a filter for different Data Source Types is used:
The last selected data source types are stored within the developer workspace and reused the next time the Add Data Source dialog is opened in a context that uses the same default data source types. For example, starting the Add Data Source dialog in the context of adding a data source to a node offers different data source types compared to when starting the Add Data Source dialog in the context of selecting a value help view.
No comments:
Post a Comment