- SAP Managed Tags:
Welcome to the SAP Datasphere Sample Content blog post. Find all relevant information about our newly released SAP Sample Content for Finance, Human Resources and Sales in SAP Datasphere in this blog post.
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 Datasphere. It is a great way as a first and fast starting point into data modelling in SAP Datasphere. 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 Datasphere 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:
Highlights
UPDATE November 2023: A new Version of the Sample Content will be shipped where the new 'Analytic Model' is leveraged in all Scenarios as a basis for the SAC Story!
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 Datasphere 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.
- SAP Datasphere – Use SAP Datasphere 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 Datasphere 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 Datasphere 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 Datasphere and SAP Analytics Cloud will help solving the above challenges and deliver the following benefits to user.
Business Benefits:
- Using SAP Datasphere 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 Datasphere 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 Datasphere 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 Datasphere and SAP Analytics Cloud using the Best Run Bikes data model:
- Prepare data sources in SAP Datasphere
- Create models using this data in SAP Datasphere
- Create SAP Analytics Cloud story using the models
Spaces
To work with SAP Datasphere, 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.
- 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.
- After the Space is created as described in step 1, the content package can be imported into your SAP Datasphere tenant.
Prepare the data model
After the Space has been created, import the content package into your system. The SAP Datasphere 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 Datasphere using the File upload.
Please find the SAP Datasphere 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 Datasphere data modelling. It helps you to easily understand the features of SAP Datasphere by following a simple approach. You can quickly onboard yourself by importing the content package to your Space in SAP Datasphere. 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 Datasphere. Feel free to share your thoughts and feedback in the comment section.
For questions about the topic join the conversation in our SAP Community.
You can also check our SAP Community topic page for SAP Datasphere here.
1 Comment
