EDUCAÇÃO E TECNOLOGIA

Have a look at more interesting features delivered in Q2 2021 with in SAP Data Warehouse Cloud

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.