Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
heiko_schneider
Advisor
Advisor
0 Kudos



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






Blog posts overview



    1. SAP Datasphere Sample Content

 

    1. SAP Datasphere Sample Content for LoB Finance

 

    1. SAP Datasphere Sample Content for LoB Human Resources (this blog post)

 

    1. SAP Datasphere 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 Datasphere 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 Datasphere 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 Datasphere 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 NameTechnical NameType
Data Flow for HRSAP_SC_HR_DFData Flow
Department TextsSAP_SC_HR_T_DepartmentTextsLocal Table (Dimension)
DepartmentsSAP_SC_HR_T_DepartmentsLocal Table (Dimension)
Departments Dimension (View)SAP_SC_HR_V_DepartmentsView (Dimension)
Departments Texts (SQL Text View)SAP_SC_HR_SQL_DepartmentsTextsView (Text)
Division TextsSAP_SC_HR_T_DivisionTextsLocal Table (Dimension)
DivisionsSAP_SC_HR_T_DivisionsLocal Table (Dimension)
Divisions Dimension (View)SAP_SC_HR_V_DivisionsView (Dimension)
Divisions Texts (SQL Text View)SAP_SC_HR_SQL_DivisionsTextsView (Text)
Employee HeadcountSAP_SC_HR_T_EmployeeHeadcountLocal Table (Analytical Dataset)
Employee PerformanceSAP_SC_HR_T_EmpPerformanceLocal Table (Relational Dataset)
Employee Personal DataSAP_SC_HR_T_EmpPersonalDataLocal Table (Relational Dataset)
Employee PositionSAP_SC_HR_T_EmployeePositionLocal Table (Relational Dataset)
HR ER ModelSAP_SC_HR_ERME/R Model
HR ManagerSAP_SC_HR_T_ManagerLocal Table (Dimension)
Headcount (Data Flow Table)SAP_SC_HR_DF_EmpHeadcountLocal Table (Analytical Dataset)
Headcount (View)SAP_SC_HR_AM_EmpHeadcountAnalyticModel
JobSAP_SC_HR_T_JobLocal Table (Dimension)
Job Classificatioins Texts (Text View)SAP_SC_HR_V_JobClassTextsView (Text)
Job ClassificationSAP_SC_HR_T_JobClassificationLocal Table (Dimension)
Job Classification Dimension (View)SAP_SC_HR_V_JobClassView (Dimension)
Job Classification TextsSAP_SC_HR_T_JobClassTextsLocal Table (Dimension)
Job Dimension (View)SAP_SC_HR_V_JobView (Dimension)
Job TextsSAP_SC_HR_T_JobTextsLocal Table (Dimension)
Job Texts (Text View)SAP_SC_HR_V_JobTextsView (Text)
LocationSAP_SC_HR_T_LocationLocal Table (Dimension)
Location Dimension (View)SAP_SC_HR_V_LocationView (Dimension)
Location HierarchySAP_SC_HR_T_LocationHierarchyLocal Table (Dimension)
Location Hierarchy (View)SAP_SC_HR_V_LocationHierarchyView (Hierarchy)
Location TextsSAP_SC_HR_T_LocationTextsLocal Table (Dimension)
Location Texts (SQL Text View)SAP_SC_HR_SQL_LocationTextsView (Text)
Manager Dimension (SQL View)SAP_SC_HR_SQL_ManagerView (Dimension)

 

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.

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 Datasphere. 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 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