Skip to Content
Product Information
Author's profile photo Harun Behroz

SAP Data Warehouse Cloud Sample Content


Welcome to the SAP Data Warehouse Cloud Sample Content blog post. Find all relevant information about our newly released SAP Sample Content for Finance, Human Resources and Sales in SAP Data Warehouse Cloud in this blog post.


Covered in this blog post

For questions about the topic join the conversation in our SAP Community.

You can also check our SAP Community topic page for SAP Data Warehouse Cloud here.

Sample content overview

The SAP Sample Content for Finance, Human Resources and Sales uses the Best Run Bikes sample data package to help you explore and learn your way around in SAP Data Warehouse Cloud. It is a great way as a first and fast starting point into data modelling in SAP Data Warehouse Cloud. The sample content supports the onboarding of new users through demonstrating product features by following a clear structure and answering a business question. This content package will be continuously updated, so make sure to check for the newest version.

The first SAP Data Warehouse Cloud sample content package is „SAP Sample Content for Finance, Human Resources and Sales“. As you can see by the title, the LoBs Finance, Human Resources and Sales are covered.

The Step-by-Step guide in this blog post explains how to import and setup the content.

Find a detailed description of each individual LoB in the following blog post:

Please make use of the in-app help and available enablement materials on Learning Journey: SAP Data Warehouse Cloud in case you need further assistance beyond this document.

Highlights

BestRun is a mid-sized (1,100 employees) bike manufacturing company with office locations throughout the world. They use SAP Concur, SAP Fieldglass, SAP C/4HANA, SAP S/4HANA, and SAP SuccessFactors to run their business. BestRun wasn’t always best run. Preparing a board meeting for BestRun took many analysts several weeks working through unexpected requirement changes and complicated data alignment across multiple systems. The outcome was most of the times a set of static slides and cumbersome spreadsheets that were outdated as soon as they were produced. No one ever had 100% confidence in the numbers- that’s a hard place to be when you have a goal to be the market leader.

In the digital economy, this old board meeting experience cannot adapt to BestRun’s fast-growing business and its strategic goals. It became more difficult or nearly impossible for board members to make decisions quickly and drive changes such as their innovative new electric bikes without a powerful analytics solution.

If there was a unified system that fetches and calculates data in real time from the entire intelligent enterprise systems and provides a single aggregated view of the company, this would greatly facilitate the decision-making process and improve the overall profitability of the company.
BestRun Bikes now runs best with their SAP Data Warehouse Cloud and SAP Analytics Cloud system, which pulls information across all lines of business and operations to provide a complete 360° view of a company’s critical business metrics all in one place. During the board meeting, the executives are realizing the company is not hitting their top-line profit goals for the year. Forecasted costs are over budget. Even though the sales forecast number is slightly exceeding the goal but there is still room for more growth.

With SAP Analytics Cloud they’re able to discover cost saving and revenue growth opportunities and adjust their forecast plans using predictive, planning, and BI capabilities, to meet and exceed their profit goals. As a result, the executives were able to identify underpaid employees using outlier analysis to reduce turnover ratio and HR expenses; identify top influencers driving revenue lost; identify the gaps between plans and actuals for sales revenue to see areas to focus on improving; and finally uncover insights to improve profitability.

  • X+O story – This package showcases how companies could bring operational data from LoB systems together with experience data to create powerful insights and optimize their businesses.
  • Agile BI – Agile analytics enables the end users without tech background to easily manage data error, build models & hierarchies, and switch between model & story.
  • Data Warehouse Cloud – Use SAP Data Warehouse Cloud to achieve end-to-end LoB scenarios.

Why SAP?

This package shows how a BestRun business user can quickly and easily combine and analyze data coming from different sources in SAP Data Warehouse Cloud and SAP Analytics Cloud.

BestRun is looking for a cloud-based data warehouse and analytics solution that provides a consistent user experience for business users. Business users want to be able to swiftly combine data from different sources into structures that they can use to quickly generate and distribute end-user reporting.

SAP Data Warehouse Cloud and SAP Analytics Cloud provide this technology, allowing for one unified user experience for fast, flexible, end-to-end, and collaborative enterprise data warehousing. Even business users can simply combine heterogeneous data sources with this solution to answer their specific questions.

Business Situation:

  • A business user at BestRun wants to have a quick analysis on his LoB data together with other data or adding additionally dimensions.
  • Parts of the data are saved in a flat file.
  • Others are available in a local table.
  • He is intended to deliver a pleasant reporting quickly without the need to ask IT for support.

Business Challenges:

  • Combinations of data often needs complex data modeling, which was often impossible without IT support.
  • The business user wants to answer precise questions, like “How did BestRun’s sales order values develop in September 2020 in comparison to 2019?”

SAP Data Warehouse Cloud and SAP Analytics Cloud will help solving the above challenges and deliver the following benefits to user.

Business Benefits:

  • Using SAP Data Warehouse Cloud and SAP Analytics Cloud enable a common evaluation of both data scopes by the business user himself.
  • With a simple and quick start with SAP Data Warehouse Cloud the user can answer his question immediately.

Technical Benefits:

  • It is easy for the business user himself to combine the existing data from the different sources.
  • Without needing IT, he works in his Space and combines the data he needs in a SAP Data Warehouse Cloud Data Model…
  • … and also creates a pleasant Analytics Story combining both data scopes.

Step-by-step guide

Follow these steps to create the reports with SAP Data Warehouse Cloud and SAP Analytics Cloud using the Best Run Bikes data model:

  1. Prepare data sources in SAP Data Warehouse Cloud
  2. Create models using this data in SAP Data Warehouse Cloud
  3. Create SAP Analytics Cloud story using the models

Spaces

To work with SAP Data Warehouse Cloud, a Space is needed as a pre-requisite. Find more information on Spaces here.

To create a new space, navigate to Space Management and create a new space.

Please consult the help documentation if you require further assistance or use the in-app product help using “F1” anytime or use the following navigation path to access the help:

Execute the following steps before importing this content package. In case this or other packages might have been imported prior to this import, some or all object that are created in this step might already exist. Please check and add missing objects.

  1. Create the Space with Space ID SAP_CONTENT and Space Name SAP & Partner Content (if it does not exist) and assign the user that will import the content to this Space.
  2. After the Space is created as described in step 1, the content package can be imported into your SAP Data Warehouse Cloud tenant.

Prepare the data model

After the Space has been created, import the content package into your system. The SAP Data Warehouse Cloud content package includes the data model: it consists of tables, views and associations are modeled.

After you have imported the content into your system, deploy the content using the three ER models SAP_SC_FI_ERM (FI ER Model), SAP_SC_HR_ERM (HR ER Model) and SAP_SC_SALES_ERM (Sales ER Model).

The sample data has to be uploaded to SAP Data Warehouse Cloud using the File upload.

Please find the SAP Data Warehouse Cloud CSV files on https://github.com/SAP-samples/data-warehouse-cloud-content-beta.

Upload data into the tables

The CSV files are stored in a packed ZIP. Unpack this ZIP to your local device.

In the next step the sample data for the local tables needs to be uploaded. Navigate to the Data Builder.

We will use the Sales content to illustrate how to upload the sample data into the tables.

Find the SalesOrderItems table in the Data Builder and open it by clicking on the table name.

Click on the Upload Data from CSV File icon in the upper toolbar to import a file.

Select the CSV-file SalesOrderItems.csv from the location where you have stored the sample files. The columns should be mapped automatically.

Click Import to import the data.

You can also preview the content of the table. The preview pane will appear on the bottom part of the page displaying the data.

Now you’re good to go! Repeat the above steps for the remaining tables for each of the LoBs.

Summary

The SAP Sample Content for Finance, Human Resources and Sales is a great way to get started in SAP Data Warehouse Cloud data modelling. It helps you to easily understand the features of SAP Data Warehouse Cloud by following a simple approach. You can quickly onboard yourself by importing the content package to your Space in SAP Data Warehouse Cloud. The underlying ER-model helps to understand and easily deploy the different entities included in this content package. In a final step you upload the sample data into the tables to prepare your model for data consumption.

As illustrated, this sample content enables users to speed up the onboarding process and I hope you have a good start on your data modelling journey in SAP Data Warehouse Cloud. Feel free to share your thoughts and feedback in the comment section.

Make sure to follow the tag to stay updated about SAP Data Warehouse Cloud.

For questions about the topic join the conversation in our SAP Community.

You can also check our SAP Community topic page for SAP Data Warehouse Cloud here.

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ronald Konijnenburg
      Ronald Konijnenburg

      Tx!! One additional step. Dont' forget to generate the time dimensions before the import. Else it will fail.