New Features in Version 2021.19

New or changed features are available in SAP Data Warehouse Cloud version 2021.19.

Administration

New or changed features are available for administration:
  • Monitoring Tasks, Logs and Schedules With Dedicated Monitoring Views

    Four monitoring views dedicated to SAP Data Warehouse Cloud are available in the DWC_GLOBAL schema to monitor tasks, logs and schedules within a space.

    For more information, see Working with SAP HANA Monitoring Views

  • Access Additional Monitoring Views

    Users assigned to the monitoring space can now access additional monitoring views: SAP HANA views from the _SYS_STATISTICS schema and monitoring views dedicated to SAP Data Warehouse Cloud from the DWC_GLOBAL schema.

    For more information, see Configure Monitoring.

  • Grant Write Access to Tables for Data Flows

    You can now grant write access to tables located in Open SQL schemas, HDI containers, and SQL User Group schema, and use them as targets in a data flow.

    For more information, see Allow the Space to Access the Open SQL Schema, Allow Your Space to Write to Your HDI Container, and Allow a Space to Write to the Database User Group Schema.

Data Integration

New or changed features are available for data integration:
  • CSN Export of Remote Tables from One Space to Another

    When you create a connection, the space name is no longer hardcoded as a prefix in the connection technical name. This change lets you export remote tables from one space to a CSN file and then import the file into another space that contains a connection with the same name.

    For more information, see Importing Objects from a CSN/JSON File.

  • Remote Query Monitor: Check the running statement to identify root cause issues

    From the Remote Query Monitor, administrators can now display the original SQL statement for a query that is currently running and track the root cause of the error. Using the Statement ID, they can additionally connect to the SAP HANA Cockpit and get deep dive information.

    For more information, see Monitoring Remote Queries.

  • Redesigned Dialog Box for Scheduling Data Integration Tasks

    The dialog box for scheduling data integration tasks has been redesigned and includes these features:
    • Schedule Data Integration Tasks by Entering Cron Expression

      You can now create a schedule by entering directly a cron expression in the scheduling dialog box, so that your tasks run multiple times a day or run on specific days and months. For more information, see Schedule a Data Integration Task (with Cron Expression).

    • Specify an Offset for Hourly Schedules

      When you define a simple schedule to run tasks hourly, you can now specify an offset of more than one hour. For example, a task will run every 2 hours starting from 1:30 AM (offset). For more information, see Schedule a Data Integration Task (Simple Schedule).

Data Modeling

New or changed features are available for the data layer:
  • Data Flow Upsert Option

    When using the Append mode in your data flows, you can now enable the new Update Records By Primary Key (UPSERT) option to instruct the flow to update, where appropriate, existing target table records.

    For more information, see Add or Create a Target Table in a Data Flow.

  • Add Open SQL Schema Objects or HDI Containers as Targets in Data Flow

    You can now add Open SQL schema objects or HDI containers to a data flow as sources or targets .

    For more information, see Creating a Data Flow.

Data Privacy and Protection

New or changed features are available for security:
  • Importing SAP BW∕4HANA Analysis Authorizations

    You can now import analysis authorizations defined in SAP BW∕4HANA v2.0 and higher systems into SAP Data Warehouse Cloud to provide row-level protection for data in remote tables imported from these systems. The Import Permissions wizard allows you to select tables to protect and will, for each selected table, create a view to calculate its permissions, a data access control to consume them, and a second protected view to wrap the remote table and apply the data access control.

    For more information, see Import SAP BW and SAP BW∕4HANA Analysis Authorizations.

General

The following general changes are available:
  • Simplified Space Handling

    Users who are members of only one space will no longer be asked to select that space before entering the Data Builder and other applications.

Space Management

New or changed features are available for space management:
  • Saving a Space and Deploying it as Two Distinct Actions

    Now, when you save a space, it is not automatically deployed to the database. You can then choose to deploy the space when you are ready.

    For more information, see Save and Deploy Your Space.

Related Information

To access the SAP Datasphere roadmap, visit the SAP Roadmap ExplorerInformation published on SAP site.