Technical Architecture

Data Flow

1. BW(Workforce + Payroll) →  Xtract → Talend → GCP → Qlik
2. Pulse(gsheet) → Talend → GCP → Qlik

Data Source

Prerequisites:

  BW 

• Remote Access should be enabled for the interface query
• Access to the two interface queries should be assigned to the role: ZH_PA_INGESTION and technical user: RFC_TAL_WBP

  Pulse

• It's integrated into one gsheet(tab:Pulse) as above and should be shared with
  • sa-talend@prj-data-dm-hr-dev.iam.gserviceaccount.com
  • sa-talend@prj-data-dm-hr-test.iam.gserviceaccount.com
  • sa-talend@prj-data-dm-hr-ppd.iam.gserviceaccount.com
  • sa-talend@prj-data-dm-hr-prod.iam.gserviceaccount.com
• Short text for [Management Level]
• Text for [Cadre, Non Cadre]

Restrictions on BW queries:

• User Name = SACBW_HRD
• HR Roles    = WORLDWIDE
• PO2 Flag    = #; E;TSAE

Please see here for details.

Xtract

Please see here for details.

Talend

GCP

STG Tables:

• STG.STG_BWH_0000_0000_F001_F_M_qry_cphrpahdm_0005
• STG.STG_BWH_0000_0000_F001_F_M_qry_cphrpy002_0001
• STG.STG_FIL_0000_0000_F003_F_A_pulse_to_hr_peopleinsight

ODS Tables:

• ODS.ODS_BWH_0000_F001_F_M_qry_cphrpahdm_0005
• ODS.ODS_BWH_0000_F001_F_M_qry_cphrpy002_0001
• ODS.ODS_FIL_0000_0000_F003_F_A_pulse_to_hr_peopleinsight

DM Tables:

• DM.FACT_hr_peopleinsight_workforce
• DM.FACT_hr_peopleinsight_payroll
• DM.FACT_hr_peopleinsight_pulse

Stored Procedure:

• DM.PROC_PAYROLL_ODS_TO_DM
• DM.PROC_WORKFORCE_ODS_TO_DM
• DM.PROC_PULSE_ODS_TO_DM

Views:

• DS_prj_data_ppl_insgt_dashb.V_FACT_hr_peopleinsight_workforce
• DS_prj_data_ppl_insgt_dashb.V_FACT_hr_peopleinsight_pulse
• DS_prj_data_ppl_insgt_dashb.V_FACT_hr_peopleinsight_payroll

• DataOcean_hr.V_FACT_hr_peopleinsight_pulse
• DataOcean_hr.V_FACT_hr_peopleinsight_payroll
• DataOcean_hr.V_FACT_hr_peopleinsight_workforce

The DataOcean views should be created in GCP project: prj-data-ppl-insgt-dashb-<<env>>; the others to be created in GCP project:prj-data-dm-hr-<<env>>

DA&AI - Domain Mapping - HR

DA&AI  - HR - People Insight Dashboard

QlikSense

QlikSense technical documentation

Data Quality Controls

Data comes from SAP system. To compare data between BW and sources systems, check propagation layers.

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticality, workarounds and resolution plan.>

Roadmap

<List past & future evolutions for the application (including links to MED/FSD/TSD)>