Skip to Content
Product Information
Author's profile photo Anil Lad

SAP Data Warehouse Cloud – Business Content

SAP Data Warehouse Cloud includes business accelerators to shorten the time to implement. The solution features a growing portfolio of pre-built data models, semantic views of SAP ERP application data, and transformation logic leveraging SAP’s business expertise and ecosystem partners’ knowledge to help you accelerate implementation and integration.

Figure 1: Business Content for multiple sources

Source :  SAP Data Warehouse Cloud. Content Rollout – Release Q3 2021 (2021.16) Public

The Business content is available from the Content Network in SAP Data Warehouse cloud home screen. A Content package may be free-of charge, priced or may also be available as a trial. Any commercial aspect of a package is also documented at the package level

Figure 2: Content Network

SAP Content packages include:

  • Consumer Products: Revenue Growth Management (Based on SAP Data Warehouse Cloud live connection)
  • SAP Ariba: Enterprise Analytics for Procurement (Based on a SAP Data Warehouse Cloud live connection)
  • SAP Ariba: Spend Analysis (Based on an SAP Data Warehouse Cloud (DWC) connection to SAP Ariba Analysis)
  • Automotive – Responsive Supply Network, Sales and Inventory (Based on SAP Data Warehouse Cloud live connection)
  • Finance for SAP S/4HANA Cloud (Based on live data access to SAP Data Warehouse Cloud)
  • Outcome-Based Business Insights (Based on Solution Portfolio Management with Planning on BTP platform and SAP S/4HANA OnPremise – Finance)
  • Financial Analytics Dashboard for SAP Analytics Cloud (Based on live data access from SAP Analytics Cloud to SAP S/4HANA Cloud for financial KPIs and Live data access from SAP Analytics Cloud to SAP Data Warehouse Cloud for cross-application KPIs)
  • Point-of-Sale Analysis for Retail (Based on SAP Data Warehouse Cloud live connection)
  • SAP Supply Chain Management: Life Sciences Dashboard (Based on SAP Data Warehouse Cloud live connection)
  • Utilities – Meter to Cash (Based on SAP Data Warehouse Cloud live connection)

 

Example 1 – Consumer Products: Revenue Growth Management

Figure 3: Revenue Growth architecture

Source : SAP_Data_Warehouse_Cloud_Content.pdf

The models are grouped into three main areas:

  • Sales Orders
  • Material Sales
  • Promotions Sales

Inbound Layer

The view Sales Order (RL) (SAP_CP_RL_SalesOrder) is used to access the data referring to Customer Sales Orders, based on different entities, mainly ship-to and sold-to customers, division, and sales organization.

Figure 4: Sales Order view

Source : SAP_Data_Warehouse_Cloud_Content.pdf

The view Material Sales (RL) (SAP_CP_RL_MaterialSales) collects the transactional information of sales, focusing on the dimensions of material and related dimensions.

Figure 5: Material Sales view

Source : SAP_Data_Warehouse_Cloud_Content.pdf

The RGO UseCase (RL) (SAP_CP_RL_RGOUseCase) view allows to join the complete sales view information with the promotion data.

Figure 6: Promotions Sales view

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Harmonization Layer

This view contains all the sales information: Sales RGO (RL) (SAP_CP_RL_SalesRGO):

It allows access to the combination of sales data and all available dimensions in order to obtain information from all possible dimensions.

Figure 7: Sales Information view

Source : SAP_Data_Warehouse_Cloud_Content.pdf

 

SAP Analytics Cloud Dashboard

The Overview page shows net values, cost and promotion plan material sales volume at a glance

Figure 8: Revenue Growth Overview page

Source : SAP_Data_Warehouse_Cloud_Content.pdf

You can gain further insights into the sales orders and drill down sales order values and costs by ship-to party, sales organization, business area and other dimensions. Analyze order values and cost over billing date

Figure 9: Revenue Growth drill down page

Source : SAP_Data_Warehouse_Cloud_Content.pdf

 

Example 2 – SAP Ariba: Spend analysis

Figure 10: SAP Ariba analysis architecture

Source : SAP_Data_Warehouse_Cloud_Content.pdf

The Reporting Layer (RL) views are created based on tables in Inbound Later (IL) and views in Harmonization Layer (HL).

Spend analysis view

The view SAP Ariba: Spend Analysis (RL) (SAP_PROC_SA_RL_SPEND_ANALYSIS) is built to access the data referring to Invoice Fact Table, based on different entities, primarily Source System, Part, Company, UNSPSC, Supplier, Contract, Account.

Figure 11: Spend analysis view

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Part Optimization view

The view SAP Ariba: Part Optimizations (RL) (SAP_PROC_SA_RL_PART_OPTIMIZATI) is built to access the data referring to Invoice Fact Table, based on different entities, primarily Source System, Part, Company, UNSPSC, Supplier, Contract, Account etc. In addition, this view provides calculations related to Supplier Optimization Cost, Purchase Price Variance and Purchase Price Alignment.

Figure 12: Part optimization view

Source : SAP_Data_Warehouse_Cloud_Content.pdf

The views in Reporting Layer are used to build SAP Analytic Cloud Stories using a live connection to SAP Data Warehouse Cloud.

Spend Analysis General Overview

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.

Figure 13: Spend Analysis overview

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Spend Analysis Spend Assessment

Highlights important spend categories having the highest number of suppliers or having unique source supplier. This story should also help identify compliance issues and where there are opportunities to consolidate low spend suppliers.

Figure 14: Spend Analysis Spend Assessment

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Spend Analysis Price Optimizations

Highlights saving opportunities where the organization is purchasing the same parts from different suppliers, from the same supplier at different prices or different company site purchased at different prices.

Figure 15: Spend Analysis Price Optimizations

Source : SAP_Data_Warehouse_Cloud_Content.pdf

 

Example 3 – Utilities Meter to Cash scenario

Figure 16: Utilities Meter to Cash architecture

Source : SAP_Data_Warehouse_Cloud_Content.pdf

This live model is based on 74 SAP Data Warehouse Cloud views organized in 4 main areas:

  • Master Data
  • Energy Data Management (Metering)
  • Financial
  • Maintenance

Figure 17: Utilities Meter to Cash Inbound layer views

Harmonized View on Meter Reading Data (SAP_UTL_HL_MeterReadings)

In this model, all meter reading data for the register of a device is shown, together with the meter reading reason that is defined for all meter reading documents for an installation.

Figure 18: Meter Readings data

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Harmonized View on Maintenance Items (SAP_UTIL_HL_CDS_IMAINTITEMDATA)

A maintenance item describes which preventive maintenance tasks should take place regularly for a technical object or a group of technical objects.

Figure 19: Maintenance items

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Harmonized view on Billing Orders (SAP_UTL_IL_Billing_Orders)

After the creation of a Meter Reading Order (MRO) and the upload of the Meter readings, a billing order is created.

                                                         Figure 20: Billing Orders

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Harmonized view on Payments (SAP_UTL_IL_Payments)

In the billing cycle, after the MRO and the billing order have been created, invoicing and payments take place

Figure 21: Payments

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Harmonized view on Business Partner Items (SAP_UTL_HL_BPItem)

Business Partner Item Harmonized view present the Account Receivable Data, the amount of money for goods delivered or services used but not yet paid for by customers.

Figure 22: Business Partner items

Source : SAP_Data_Warehouse_Cloud_Content.pdf

SAP Analytics Cloud Dashboard

This SAP Analytics Cloud Content provides overviews and details pages for five sections, Meter Reading, Maintenance, Billing Orders, Payments and Account Receivables. The user has access to a consequent panel of filters to play with the data as per their wish.

Figure 23: Utilities dashboard

Source : SAP_Data_Warehouse_Cloud_Content.pdf

Gain further insights into, for example, Payments and drill down by Business Partner,etc

Figure 24: Utilities Payments overview

Source : SAP_Data_Warehouse_Cloud_Content.pdf

 

Note: The SAP Analytic Cloud content is delivered as a separate package in the SAP Analytic Cloud Content Network.

 

Partner Content packages:

 

How to Import Business Content?

  1. Select Content Package
  • Navigate to the Content Network.

Figure 25: SAP Business Content

  1. Check Prerequisites
  • Check the prerequisites of the content package.

Figure 26: Prerequisites for a package

  • Create space(s) and assign members.
  • Establish valid connections to required source systems.
  1. Import Options
  • Choose your overwrite preference for the import.

Figure 27: Import options

  • Select individual or all objects from the content package.
  • Import the chosen objects into SAP or partner content space.
  1. Use the content models
  • Use in new data models to integrate different data sources, associate master data views or combine with other data sets, and
  • Import the SAP Analytics Cloud content to consume the Stories based on the analytical view or create a new story.

Conclusion

As shown in the 3 content examples above, the combination of detailed models in SAP Data Warehouse Cloud and SAP Analytics Cloud dashboards can help you accelerate the on-boarding process and the implementation timelines. Also, the standard content can be adapted to better fit your business requirements if required.

Find more information about the Business Content the SAP Data Warehouse Cloud Community.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.