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

SAP Data Warehouse Cloud Sample Content for LoB Human Resources


This blog post is describing the human resources line of business data of the SAP Sample Content package in SAP Data Warehouse Cloud.


Blog posts overview

  1. SAP Data Warehouse Cloud Sample Content
  2. SAP Data Warehouse Cloud Sample Content for LoB Finance
  3. SAP Data Warehouse Cloud Sample Content for LoB Human Resources (this blog post)
  4. SAP Data Warehouse Cloud Sample Content for LoB Sales

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.

Covered in this blog post

The sample data of the LoB Human Resources includes headcount relevant data of the sample company BestRun Bikes. The headcount view includes associations to the following dimensions: Manager, Divisions, Job, Job Classification, Location, Departments, Time.

Architecture

The following diagram displays the table structure in SAP Data Warehouse Cloud of the LoB HR.

To get an overview of the data model, the entity-relationship diagram delivers helpful insight into the modelling of the data. In the following you can see the relationship among the different tables and views.

SAP Data Warehouse Cloud enables you to do ETL transformations within the tool. To demonstrate this capability, the LoB scenario for HR makes use of a simple example. As the source data is not yet in the right format, a Data Flow is used to join different employee related data add calculated columns to the result.

The Data Flow for the LoB HR joins the employee related data with the “Join” operator and includes a script in Python to calculate the entry and exit year of employees.

Python Script

# convert the Date to datetime
    data[‘DATE’] = pd.to_datetime(data[‘DATE’])
# add a column for Year
    data[‘HIREYEAR’] = data[‘DATE’].dt.year

# convert the Exit Date to datetime
    data[‘EXITDATE’] = pd.to_datetime(data[‘EXITDATE’])
# add a column for Year
    data[‘EXITYEAR’] = data[‘EXITYEAR’].dt.year

return data

Overview of all business objects and its types 

The following table lists all data objects of the HR sample data sorted by Business Name.

Business Name Technical Name Type
Data Flow for HR SAP_SC_HR_DF Data Flow
Department Texts SAP_SC_HR_T_DepartmentTexts Local Table (Dimension)
Departments SAP_SC_HR_T_Departments Local Table (Dimension)
Departments Dimension (View) SAP_SC_HR_V_Departments View (Dimension)
Departments Texts (SQL Text View) SAP_SC_HR_SQL_DepartmentsTexts View (Text)
Division Texts SAP_SC_HR_T_DivisionTexts Local Table (Dimension)
Divisions SAP_SC_HR_T_Divisions Local Table (Dimension)
Divisions Dimension (View) SAP_SC_HR_V_Divisions View (Dimension)
Divisions Texts (SQL Text View) SAP_SC_HR_SQL_DivisionsTexts View (Text)
Employee Headcount SAP_SC_HR_T_EmployeeHeadcount Local Table (Analytical Dataset)
Employee Performance SAP_SC_HR_T_EmpPerformance Local Table (Relational Dataset)
Employee Personal Data SAP_SC_HR_T_EmpPersonalData Local Table (Relational Dataset)
Employee Position SAP_SC_HR_T_EmployeePosition Local Table (Relational Dataset)
HR ER Model SAP_SC_HR_ERM E/R Model
HR Manager SAP_SC_HR_T_Manager Local Table (Dimension)
Headcount (Data Flow Table) SAP_SC_HR_DF_EmpHeadcount Local Table (Analytical Dataset)
Headcount (View) SAP_SC_HR_V_EmpHeadcount View (Analytical Dataset)
Job SAP_SC_HR_T_Job Local Table (Dimension)
Job Classificatioins Texts (Text View) SAP_SC_HR_V_JobClassTexts View (Text)
Job Classification SAP_SC_HR_T_JobClassification Local Table (Dimension)
Job Classification Dimension (View) SAP_SC_HR_V_JobClass View (Dimension)
Job Classification Texts SAP_SC_HR_T_JobClassTexts Local Table (Dimension)
Job Dimension (View) SAP_SC_HR_V_Job View (Dimension)
Job Texts SAP_SC_HR_T_JobTexts Local Table (Dimension)
Job Texts (Text View) SAP_SC_HR_V_JobTexts View (Text)
Location SAP_SC_HR_T_Location Local Table (Dimension)
Location Dimension (View) SAP_SC_HR_V_Location View (Dimension)
Location Hierarchy SAP_SC_HR_T_LocationHierarchy Local Table (Dimension)
Location Hierarchy (View) SAP_SC_HR_V_LocationHierarchy View (Hierarchy)
Location Texts SAP_SC_HR_T_LocationTexts Local Table (Dimension)
Location Texts (SQL Text View) SAP_SC_HR_SQL_LocationTexts View (Text)
Manager Dimension (SQL View) SAP_SC_HR_SQL_Manager View (Dimension)

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.

In this blog post you learned the detailed background information about the LoB HR data. This scenario consists of different tables and views, whereas the ER-model serves as central entry point to the data model. The simple Data Flow presents ETL functionalities within SAP Data Warehouse Cloud. Finally, all related entities used in this scenario are listed in the above table.

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

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