using sas solutions on top of the sap hr module at · pdf fileusing sas solutions on top of...
TRANSCRIPT
![Page 1: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/1.jpg)
Using SAS solutionson top of the SAP HR
module atElectrabel
Frank Deconinck - ElectrabelSophie De Baets - Solid Partners
![Page 2: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/2.jpg)
Agenda• Electrabel presentation • Human Resources organisation • The project : - origin - objectives• Data source analysis : SAP HR• The data model • Business benefits• Conclusion
• Question time
![Page 3: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/3.jpg)
Overview of Electrabel
![Page 4: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/4.jpg)
Our core business•• we we generategenerate electricity, electricity,
•• we build, manage and service we build, manage and service networksnetworks used for the used for thetransmission of electricity and the distribution of transmission of electricity and the distribution of electricity and natural gas,electricity and natural gas,
•• we we sellsell electricity, natural gas and derived energy electricity, natural gas and derived energy products and services that meet customer needs,products and services that meet customer needs,
•• in Belgium and in Europe.in Belgium and in Europe.
•• To support this core business we also develop otherTo support this core business we also develop othermajor activities: cable TV, distribution of water andmajor activities: cable TV, distribution of water andsteam,steam, cogeneration cogeneration (combined heat and power)... (combined heat and power)...
![Page 5: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/5.jpg)
Electrabel's market share per activity
88% 88% electricity generationelectricity generation
84% 84% electricity supplyelectricity supply
80% 80% electricity distributionelectricity distribution
89% 89% natural gas distributionnatural gas distribution
53% 53% cable TVcable TV
10% 10% drinking water distributiondrinking water distribution
![Page 6: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/6.jpg)
Human Resources Organisation
![Page 7: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/7.jpg)
Organisational Structure
ProductionPlannificationTransport
Corporate
DistributionFlanders
...
Electrabel
DistributionCentral
DistributionWallonia
Local PersonnelAdministrations
![Page 8: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/8.jpg)
Organisational StructureCorporateElectrabel
BU1 BU2 BU3 BU4 BU5
PA1 PA2 PAn...
Finance &Administration
Strategy
HR & IT
“Studies and control Personnel Administration”
Marketing
![Page 9: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/9.jpg)
The project
![Page 10: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/10.jpg)
Project Overview• Origin of the project
- Operational system PCICS replaced by SAP-HRNeed for an integrated Data Structure
- No Reporting & Analysis environments available in SAP-HR for “Studies & controls Personnel Administration”
Need for a separate reporting & analysis environment
-Continuity in the service cannot be guaranteedNeed for a quick and efficient solution
![Page 11: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/11.jpg)
Project Overview• Objectives
- Build a new Data StructureWhich integrate previous system (PCICS-history)& SAP HR data (current data)Incremental approach
- Create reporting and analysis environment
- Control programs on operational data
- Flexible solution for the future
![Page 12: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/12.jpg)
Operational System Reporting Environment
PCICS
SUSPENS
SAP HR
SAS DataMart
Abap Query
Report tree
Analyse and
query environment
Simulationcosts
Effectives
SAP BW
Social indicators
![Page 13: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/13.jpg)
Open up your SAP HR data ...
![Page 14: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/14.jpg)
well structured but fragmented data
lots of fields are irrelevant
a lot of data that contains no information
integrated but designed for a
specific program
COMPLEXITY
Master Data -Transparent
tables
Master Data -Transparent
tables
Time Evaluation-
Cluster Table
Time Evaluation-
Cluster Table
Payroll Accounting-
Cluster Table
Payroll Accounting-
Cluster Table
The data source : SAPHR
![Page 15: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/15.jpg)
...
Salary Classification
Insuran-ces
Suspensiontype
Formatgender
Wagetypes
Wagetype
group
Organi-sationalformats
Formatgroup
Wagetypes
Wagetypes
groups
Formatlevel
Formatlanguage
Unusedtable
Unusedtable
Unusedtable
Unusedtable
Unusedtable
Unusedtable
PersonalDetails Address
Absences Contracttable
Organ.Hierarchy
Payrollparams
Organisat-ional
assignmts
Job-position
Wagetype
format
WorkSchedule
Formatposition
Unusedtable
Unusedtable
Unusedtable
Unusedtable
Data source Complexity :Master Data
![Page 16: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/16.jpg)
Data source complexity :Cluster Tables
DBMS Table
• Access sequence per employee
• Different Types of information
Logical groupSAP Tables
Abap
PayrollResults
Abap
ClusterDirectory
Abap
Wage type Text Amount------------ ---------------- ---------050I Base salary 70.000060I Productivity 10.000
Prime9CR1 Nbr luncheon 21
Vouchers1LSM Nbr of hours 7,75
Illness < 1mth
….
0100 Gross salary 95.000...0200 Social Ins. 30.000
Employer...0300 Employee taxes 25.000…0400 Net salary 55.000
Abap
![Page 17: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/17.jpg)
The data source : SAP HRMaster Data -Transparent
tables
Master Data -Transparent
tables
Payroll Data-
Cluster Table
Payroll Data-
Cluster Table
Time Data-
Cluster Table
Time Data-
Cluster Table
SAS/Access to SAP R/3
Business Benefits :
- Easy Access to all data
- Powerful and Platform independent solution
- Data model explorer
![Page 18: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/18.jpg)
The data source : SAP HRoverview
Importance to find the right tablesthrought the 30 000 tables present in SAP
Importance to detect only valuabledata from huge tables
Importance to have easy access to all table
�������������
������
Understanding of the SAP HR module
![Page 19: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/19.jpg)
The Data Mart
![Page 20: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/20.jpg)
Construction of Data Mart Personnel
- Effectives- Time data- Payroll
Common characteristics = dimensions
- Employee attributes (name, age, contract type …)- Organizational hierarchies (Company>personnel area>subarea…)- Time hierarchy : Year > quarter > month - Accounting dimension : wage types > g/l accounts
- Cost/time grouping dimensions : Grouping of ONSS wage types ...
3 area’s of analysis = Facts
![Page 21: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/21.jpg)
Facts :
TimeCostsHeadcount
Employee Dimension
OrganisationalDimension
Cie>business Units>business area
Name, age,contract typevalidity dates Dimension
Cost Center
Cie>cost centers
AccountingDimension
Link wg-types-G/L accounts
Cost-timegrouping
Dimension
Time
- Base Salary,ONSS, premiums...- illness, overtime...
year > quarter >months
IDID ID
ID
IDID
![Page 22: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/22.jpg)
Analysis of effectives
Salary Analysis
Absences & overtime analysis
Exploitation
![Page 23: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/23.jpg)
Exploitation
• Forecasting and follow-up of personnel costs• concistency controls on SAP and SAP BW data• controls on the results of the operational system (SAP)• controls on the proper usage of the operational system • Official reporting (annual accounts, …)• Decision making support
![Page 24: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/24.jpg)
Other exploitation possibilities
![Page 25: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/25.jpg)
Business Benefits
- Reduced to the valuable data
- Clear and easy to use data structure
- Keep historical track of data
- Control on operational data
![Page 26: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/26.jpg)
Overall conclusion• Easy access to the data available in SAP HR• Clear and easy to use data structure• Control programs on operational data
Continuity of the service has been guaranteed
• Importance of :
- SAP HR knowledge- expertise and collaboration with SAS/ Solid Partners
Strategic solution
![Page 27: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/27.jpg)
More Info• Web site : www.SolidPartners.com
• Contacts :Electrabel :- [email protected]
Solid Partners :– [email protected]– [email protected]
![Page 28: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/28.jpg)
Questions
![Page 29: Using SAS solutions on top of the SAP HR module at · PDF fileUsing SAS solutions on top of the SAP HR module at Electrabel Frank Deconinck - Electrabel ... Abap Cluster Directory](https://reader034.vdocuments.us/reader034/viewer/2022051406/5ab820807f8b9ad5338c7865/html5/thumbnails/29.jpg)