How to Capture Employee Movements and Changes in SAP NetWeaver BW

  • by Isha Gupta, SAP BI Consultant, Accenture
  • Vipul Goyal, SAP Analytics Senior Consultant, Accenture
  • March 15, 2012
Learn about a custom solution in SAP NetWeaver BW that helps developers and technical analysts track employee movements and changes within SAP ERP Human Capital Management, including how to use DataStore objects to capture this information. The employee movements provide HR end users with visibility to transfers that take place within the organization (e.g., between departments or relocations to different countries). These departments or countries can have different systems or software to house employee data, but a custom method enables analysis on all employee movements in SAP NetWeaver BW.
Key Concept
change log table keeps the history of changes that have happened to the semantic key of a DataStore object. By using a change log table, previous characteristics of employees can be compared with current characteristics to track employee movements.

There is no standard SAP ERP Central Component (SAP ECC) report or SAP NetWeaver BW business content available to capture employee movements, so we developed a complete custom solution that you can implement across SAP NetWeaver BW projects.

We have carried out a similar solution for five clients. Scenarios for which the solution is useful are as follows:

  • To allow HR managers to see how many people moved from one job or address to another, based on personnel area, organization unit, location, department, or any other dimension the business runs
  • To check the number of expatriates and inpatriates, for which some movements are not captured by SAP ERP Human Capital Management actions.
  • To see an employee change matrix, which shows employee changes based on various parameters that a company requires.

Let’s look at what objects are required for our solution and how the data flows from each object.

Isha Gupta

Isha Gupta is an SAP BI consultant in Accenture within its India Delivery Center. She is a subject matter expert with almost five years of experience in BI data model design, development, and reporting. She is a certified solution consultant in SAP NetWeaver 2004 Business Intelligence. She is proficient in various SAP BusinessObjects tools. Isha also has been involved in various SAP BI capability development activities within Accenture, including management of IDC SAP BI reusable assets, thought leadership, planning, and executing various client demos.

See more by this author

Vipul Goyal

Vipul Goyal is a Senior SAP Analytics Consultant for Accenture, mainly focused on SAP analytics technologies like SAP HANA, BW, and BusinessObjects. He has SAP implementation experience in the retail, construction, oil and gas, and telecommunications industries. Vipul is certified in SAP HANA and SAP BW and has led many successful SAP analytics implementations for a variety of clients.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.