Product Information
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)
- 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:
- Adverity – Marketing Data Integration for SAP Data Warehouse Cloud
- AG: Customer Service Insights on SAP Data Warehouse Cloud
- CubeServ – Procurement Cockpit for SAP Data Warehouse Cloud
- datazeit – E-Commerce Insights in SAP Data Warehouse Cloud
- IBsolution: Sales Dashboard for SAP Data Warehouse Cloud
- ISR – Analytics for Effective Inventory Optimization
- Inspired Intellect – Optimizing Order Fulfillment Using Machine Learning
- KPC – HR Cockpit – Automatic Attendance Analysis
- mibcon NDC – Product CostSimulation
- PwC Sales Insight – One place, all your sales data
- Reply: MOSAIC – Margin-optimized Sales Intelligence
- Rizing – Lyra Integrated Capacity Planning (ICP) on DWC
- s-peers – Financial Reporting for SAP Business One
- Westernacher – EWM Insights on Data Warehouse Cloud
How to Import Business Content?
- Select Content Package
- Navigate to the Content Network.
Figure 25: SAP Business Content
- Choose Business Content from SAP or partners.
- Follow SAP Data Warehouse Cloud content documentation
- 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.
- 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.
- 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.