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: 
kpsauer
Product and Topic Expert
Product and Topic Expert
Today July 14th, 2021 we will hold our quarterly update session to show you the great features we have delivered to SAP Data Warehouse Cloud during the second quarter of 2021.

The session on starts at 5 pm CEST and covers the following topics

  • General product updates

  • New connections & advanced data integration features

  • Geo Enrichment and other updates in the modelling

  • Input parameters and text associations

  • Data Maintenance and the new repository Explorer


Join us for the session live or watch the recording afterwards.


In addition to the features covered in the webinar session, there are lots of other valuable features and updates we want to bring to your attention.

General Information


The SAP Data Warehouse Cloud Community has been extended by two subpages:

Spaces


Prevent accidental space deletion


Description

Space deletion removes the space and all it's content from the system. Thus, it is a serious activity. So far, a simple yes/no question had to answered before space deletion and unintended deletion. Now a safety question forces you to explicitly confirm the deletion of a space.
Value

The new feature prevents users from unintended deletion of spaces.

Check out how it works



Data Source & Ingestion


Edit connection with real-time replication status "active" or "paused"


Description

When editing the connection details, there is a check if SDI real time replication is activated or paused. In those states you can only edit fields, which do not interfere with an active or paused connection.

Value

As an administrator I would like to know which fields are editable when the connection has SDI active real time replication or when the connection is paused. Fields that are not editable should be disabled. The goal is to avoid an error situation as some fields are not editable via the SDI replication when real time replication is active or even when the connection is paused.

Check out how it works



Enhance SAP HANA connectivity to use SDA for HANA Cloud federation or snapshot replication


Description


Enable a drop down in the SAP HANA connection type to choose between a cloud or on-premises system. This drop down is only changeable when creating a connection (as long as no virtual tables on that remote source exist). For SAP HANA cloud systems an automatic switch is applied to use SDA instead of SDI. It also disables the Cloud Connector section and the DP Agent drop down.

Value


Simplifies the connection to SAP HANA Cloud without using a middleware component like the DP Agent or the Cloud Connector.

Check out how it works



Enable filtering by features and categories in connection list


Description


This new smaller feature allows to filter the connection list in a space by Features, Categories and Sources.

Value


This helps with spaces containing a large number of connections and helps to keep them organized. The filtering is also aligned with the dialog when creating a new connection, which already has a similar function.

Check out how it works



Refine start time handling at the scheduling dialog


Description


The refinement decouples the recurrence interval from the actual start date and timing each occurrence is executed. This way the definition of the start time and date depends on the chosen frequency. The weekly recurrence now allows to include and exclude certain days of the week.

Value


The change provides a more intuitive user interaction and includes a preview of future runs to show exactly when the next execution will take place.

Check out how it works



Data driven and filter-based delta for Data Flows


Description


Now we introduce the option to filter data while loading from the source. This allows a generic filter-based delta and provides a max value variable for delta filtering.

Value


This option allows far less data that needs to be transferred and therefore enables faster Data Flow execution.

Check out how it works




 

Data Modeling


Modelling associations in the table editor


Description


Enable the modelling of associations directly on Tables without the need to create a wrapper View. This is supported for the remote table editor and the local table editor.

Value


Improve the efficiency when modelling simple tables by already associating relevant objects.

Check out how it works



Quick add feature for fact source attributes in single fact models


Description


This offers a direct selection of fact attributes in the quick add function and avoids specifying the source for attributes, as for single fact tables there is anyway only one origin possible.

Value


Easier and faster selection of fact source attributes in a consumption model saves time and reduces effort in a single fact model.

Check out how it works



Data preview enhancements


Description


The data preview panel can now filter or sort on all the data. The preview results are limited to the first 1,000 lines, but the filtering and sorting is applied to the full data set.

Value


This feature increases the usability and the value of data preview.

Check out how it works





Security & Governance


Show data lineage and impact analysis for Data Access Controls n


Description


Provide transparency on usage of individual Data Access Controls even in complex, stacked scenarios. It adds the possibility to navigate within diagram to see all views affected by a given Data Access Control.

Value


Increased transparency in complex scenarios to see which artifacts are affected by a Data Access Control. Better understand the data exposed to a user and which authorizations (DACs) influence the data to be seen.

Check out how it works



Connect SAP HANA Cloud Cockpit


Description


You can now connect with your database analysis user to SAP HANA Cockpit to perform advanced analysis and monitoring. The cockpit allows the monitoring of CPU, memory, storage use in the HANA Cloud instance. You can also perform analysis using trace and diagnostic files, executed SQL statements, sessions, alerts.

Value


The SAP HANA Cloud Cockpit offers:

  • Ability to perform advanced monitoring and analysis tasks on database level

  • Ability to monitor the health state of the HANA Cloud instance


Check out how it works



For more information on SAP HANA Cockpit, go to the SAP HANA Cockpit product page.

Business Content


The Business Content update for Q2 2021 has the following packages:

  • SAP Ariba: Spend Analysis new

  • SAP Supply Chain Management – Life Sciences Dashboard new

  • Financial analytics dashboard for SAP Analytics Cloud updated

  • Retail: POS (Point of Sale) Analysis updated


 

SAP Ariba - Spend Analysis


Description


The SAP Ariba Spend Analysis package for SAP Data Warehouse Cloud and SAP Analytics Cloud provides a visualization extension of SAP Ariba Spend Analysis data. This package is aimed towards sourcing managers, category managers, and procurement business analysts to inform decision making within procurement spending.

Value


Provides a general overview of the company's current spend. It displays how the spend is distributed among different factors and trends for a period of 8 quarters. The assessment also highlights compliance areas that need to be managed differently.

Check out how it works



SAP Supply Chain Management: Life Sciences Dashboard


Description


The Life Sciences industry is currently at the center of everyone's attention. In a pandemic context it is more critical than ever that the supply chain supporting the industry works in an efficient way, guaranteeing maximum quality of supply to minimize risks, while at the same time keeping costs low.

This initial release of the content provides broad Supply Chain Management models as well as an inbound quality model, to support the Supply Chain for Life Sciences Scenario. The data models are catered for further exploration and drilldowns into relevant dimensions and measures.

More Information


Find further information to get started with SAP Data Warehouse Cloud and check out the Best Practices on the Community for SAP Data Warehouse Cloud

Learn about the upcoming events and webinars for SAP Data Warehouse Cloud.

Sign up for the newsletter and get your 30-day trial tenant.