{"id":1137,"date":"2021-12-20T13:50:51","date_gmt":"2021-12-20T12:50:51","guid":{"rendered":"https:\/\/ad-astra.com.pl\/?p=1137"},"modified":"2021-12-21T14:35:07","modified_gmt":"2021-12-21T13:35:07","slug":"co-nowego-w-sap-data-warehouse-cloud-przeglad-aktualizacji-q1-q3-2021","status":"publish","type":"post","link":"https:\/\/ad-astra.com.pl\/en\/2021\/12\/20\/co-nowego-w-sap-data-warehouse-cloud-przeglad-aktualizacji-q1-q3-2021\/","title":{"rendered":"Whats new in SAP Data Warehouse Cloud? Overview for updates Q1-Q4"},"content":{"rendered":"

Q1<\/strong><\/strong><\/p>\n\n\n\n

Improvements for Data Provisioning Agents<\/strong><\/p>\n\n\n\n

Real-Time Replication can now be paused<\/strong> - every time you need to update or install a patch for SAP HANA SDI Data Provisioning agent, or when you need to apply any changes to its configuration, you can do so now without affecting all active replication processes. Just pause the process for connections using the agent, apply the changes, and restart replication.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Ability to filter connection types -<\/strong> To find the right connection type more easily, you can now apply filters in the first step of the connection creation wizard.<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

Change management<\/strong><\/p>\n\n\n\n

New functions have been added to Data Builder to improve the proces of implementing and reviewing changes made to objects. You can now-<\/p>\n\n\n\n

- get a better view of the status of objects (e.g. new columns like Status and Deployed On)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

- change the data source in Graphical View editor<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

- delete a column in a table or view, even if it is used by other objects<\/p>\n\n\n\n

- navigate Dependent objects<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

New Content Packages<\/strong><\/p>\n\n\n\n

Content packages help with and enhance the process of implementing reports on the DWC \/ SAC platform. The following packages have been added in recent updates:<\/p>\n\n\n\n

- Finance for S\/4HANA Cloud<\/p>\n\n\n\n

- Statistical Process Control Toolkit<\/p>\n\n\n\n

- Sales analysis for SAP Ariba<\/p>\n\n\n\n

- Telecommunications: Customer Value Management<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Q2<\/strong><\/strong><\/p>\n\n\n\n

\"What's new in SAP Data Warehouse Cloud?\"<\/strong><\/p>\n\n\n\n

To check what changes have been recently added to SAP DWC, you do not need to use help.sap.com anymore. Now you can view the news directly from the Data Warehouse Cloud - just click on the orange banner to learn about new features.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Repository Explorer<\/strong><\/p>\n\n\n\n

The repository explorer, a replacement for business catalog, allows you to view all SAP DWC objects that you have access to. It also allows you to quickly create new elements.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Improvements for the Data Builder and the Business Builder<\/strong><\/p>\n\n\n\n

New, more advanced data modeling functions have been added to the DWC, including<\/p>\n\n\n\n

- New data editor for local tables that allows you to edit tabe entries<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

- Ability to geo enrich the data<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

- Text associations, allowing for multi language support<\/p>\n\n\n\n

- External hierarchies<\/p>\n\n\n\n

- Input parameters (equivalent to variables from BW)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

- Ability to copy Data Entites properties while duplicating objects<\/p>\n\n\n\n

Partitioning<\/strong><\/p>\n\n\n\n

Now using Remote Table Monitor we can partition the columns and divide the data into smaller, more easily manageable parts. Thanks to this, we can avoid situations where replication processes fail due to insufficient memory.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Integration of SAP HANA monitoring views and cockpit<\/strong><\/p>\n\n\n\n

Now to monitor resource consumption such as database memory or CPU usage, you can share SAP HANA monitoring views with DWC spaces. To perform more advanced monitoring and analysis, you can also connect to the SAP HANA cockpit using the database user.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

New connection type: open connectors<\/strong><\/p>\n\n\n\n

This type of connection allows the use of SAP Open Connectors directly in the DWC space. With it, you can quickly connect to third-party cloud applications that are not supported by SAP Data Warehouse Cloud<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

System administration changes<\/strong><\/p>\n\n\n\n

Administrative tasks can now be performed directly in SAP DWC - settings that previously required putting the product into Analytics mode can now be found in the System side navigation for Data Warehouse Cloud.<\/p>\n\n\n\n

Q3<\/strong><\/strong><\/p>\n\n\n\n

New data access control functions<\/strong><\/p>\n\n\n\n

Now we can persist views with assigned data access controls - all settings are then copied to the view replica, so that users can see only the information for which they have permission.<\/p>\n\n\n\n

Import of authorizations defined in SAP BW \u2215 4HANA 2.0 to SAP Data Warehouse Cloud is also available, which enables protection of data retrieved from these systems at the row level.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

New connection type: Precog<\/strong><\/p>\n\n\n\n

With the new connection type, you can extend the standard options for SAP DWC connections to include the additional data sources that are available from Precog.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

New Content Packages<\/strong><\/p>\n\n\n\n

New sales data content packages have been added to Content Network.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Q4<\/strong><\/strong><\/p>\n\n\n\n

SAP BW Bridge<\/strong><\/p>\n\n\n\n

Thanks to SAP BW bridge, we can use the Business Warehouse functionality in the public cloud and import BW bridge data models to the Data Warehouse Cloud.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Intelligent Lookup<\/strong><\/p>\n\n\n\n

When combining data, there might be a situation where we lack an appropriate join partner: there may be no column in primary entity that uniquely identifies records in the second entity, or its data may be incomplete. In such situations, we can now take advantage of intelligent lookup.<\/p>\n\n\n\n

Intelligent Lookup can connect any two entities that have a semantic relationshi, even if one entity is unable to identify records in the other.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

New features in Data Flow<\/strong><\/p>\n\n\n\n

In the Data Flow, we can now import Excel files from a remote repository and configure them in the data flow.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

New features in Business Builder<\/strong><\/p>\n\n\n\n

Two new functions have been implemented in the Business Builder:<\/p>\n\n\n\n

- Business units can now handle the definitione of attributes with texts and language dependent texts.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

- For measures, you can now also use exception aggregation in addition to the standard aggregation types.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Improved management of large data volumes<\/strong><\/p>\n\n\n\n

To help manage large amounts of data, partitioning for remote tables has already been added this year. Now we can use the same functionality for views as well.<\/p>\n\n\n\n

To further optimize performance and reduce the amount of data, the ability to use a filter option has been added when loading data into a remote table.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

New connection type \u2013 Generic SFTP<\/strong><\/p>\n\n\n\n

We can now connect to SFTP file repositories in the local network and consume CSV, JSON files in data flows.<\/p>\n\n\n\n

\"\"<\/figure>","protected":false},"excerpt":{"rendered":"

Q1\nImprovements for Data Provisioning Agents\nReal-Time Replication can now be paused - every time you need to update or install a patch for SAP HANA SDI Data Provisioning agent, or when you need to apply any changes to its configuration, you can do so now ...<\/p>","protected":false},"author":2,"featured_media":1165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17,7,13],"tags":[35,50,43,94],"_links":{"self":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/1137"}],"collection":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/comments?post=1137"}],"version-history":[{"count":7,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/1137\/revisions"}],"predecessor-version":[{"id":1176,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/posts\/1137\/revisions\/1176"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media\/1165"}],"wp:attachment":[{"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/media?parent=1137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/categories?post=1137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ad-astra.com.pl\/en\/wp-json\/wp\/v2\/tags?post=1137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}