Please see the SAP Analytics Approach document, section 'Documentation' for more information about the context of this document.
| Status | Approved |
|---|---|
| Functional Specification Owner | BILLING-ext, Anoop |
| Stakeholders | Guillaume Decarsin, Ruben Beeck |
| Jira Request ID | ERP-1231 - Getting issue details... STATUS |
| Jira Development (Build) ID | ERP-2712 - Getting issue details... STATUS |
| Lean IX App Link | |
| Business Process Reference (L4) | 11.11.01.02. Create & Distribute Custom Reports |
High-Level Specification
| Parameter | Value |
|---|---|
| Application System (Delivery Tool) | SuccessFactors – Story Report Module: Compensation |
Functional Overview
Why the report is needed
Syensqo needs an executive report to allow senior leadership to compare key statistics before and after the Merit cycle, supporting informed decision‑making on compensation outcomes.
Business requirements addressed
- Compare compensation metrics before vs after the Merit cycle
- Monitor budget allocation and spend
- Analyze merit distribution across multiple dimensions (GBU, country, rating, gender, talent pool)
Business questions answered
- How did budget spend evolve before and after the Merit cycle?
- How did compa‑ratios change as a result of the Merit campaign?
- How is budget distributed by performance rating, talent pool, and gender?
- Are there observable gender parity gaps before and after the campaign?
Business value
The report provides leadership with a consolidated, data‑driven view of Merit calibration outcomes, supporting governance, equity analysis, and alignment with pay‑for‑performance principles.
Scope
In Scope
- Budget spend by country
- Average compa‑ratio before and after the compensation campaign
- Spend per GBU and country
- Spend with and without lump sum
- Salary distribution per performance rating per region, including category, level, and gender
- For GBUs specifically:
- % budget spend by rating
- Budget spend by talent pool (e.g. future leader, emerging leader)
- Gender parity and gaps by gender
- Evolution of compa‑ratio within a grade (e.g. S15) before and after the campaign, by gender
Out of Scope
- Compensation cycles outside the current Merit campaign
Solution Overview
Content ownership: BILLING-ext, Anoop
Input from: Guillaume Decarsin, Ruben Beeck
Security: Standard SuccessFactors Role‑Based Permissions (RBP) apply. Access is restricted by global vs entity scope (GBS, Total Rewards, SBP).
Story Page 1 – Merit Calibration (Executive Summary)
Page Objective
Provide an executive‑level overview of Merit calibration outcomes, combining KPIs, charts, and detailed tables to compare metrics before and after the Merit cycle.
Page Filters
| Report Field Name | Mandatory / Optional | Prompt Type | Default / Restrictions |
|---|---|---|---|
| Legal Entity | Optional | Multi‑select | All |
| Business Unit | Optional | Multi‑select | All |
| Country | Optional | Multi‑select | All |
| Manager | Optional | Multi‑select | All |
| Gender | Optional | Multi‑select | All |
| Performance Rating | Optional | Multi‑select | All |
| Talent Pool | Optional | Multi‑select | All |
Page Level Input Controls
None explicitly specified.
Calculations
The report includes the following calculated metrics:
- Total Budget
- Total Spent
- Total number of employees
- Average compa‑ratio (before and after campaign – subject to data availability)
- Budget spend distribution by various dimensions
Layout
- Page filters pinned at the top
- Syensqo logo top‑left
- Summary KPIs
- Charts
- Tables (final layout to be confirmed based on performance constraints)
Dashboards / Charts
Summary KPIs (Numerical):
- Total Budget
- Total Spent
- Total number of employees
Charts:
- Budget Spent by Country – Bar chart
- Average Compa‑Ratio Before vs After Campaign – Numerical indicators
- Spend per GBU / Country – Bar chart
- Spend with vs without Lump Sum – Numerical indicators
- Salary distribution per performance rating per region, including category, level, and gender – Bar chart
GBU‑specific charts:
- % Budget Spend by Rating – Pie chart
- Budget Spend by Talent Pool – Bar chart
- Gender Parity (gaps per gender) – Bar chart
Tables / Lists
Table 1 – Details per Department
| Field |
|---|
| Department |
| Legal Entity |
| Country |
| Budget |
| Total Spent |
| Average Base Salary |
Table 2 – Employee‑Level Details
| Field |
|---|
| Employee First and Last Name |
| Employee Email Address |
| Employee ID |
| Employee Username |
| Manager Details |
| GBU / Legal Entity |
| Department |
| Country |
| Base Salary |
| Compa‑Ratio |
| Total Spend |
Story Filters (Global)
| Report Field Name | Mandatory / Optional | Default |
|---|---|---|
| Employee Status | Mandatory | Active employees only |
Data Models
| Data Model | Description | Jira Development ID |
|---|---|---|
| Compensation Merit Data Model | Compensation and Merit campaign data | ERP‑2712 |
Business Roles
| Role |
|---|
40-GBS People Services Specialist |
40-Total Rewards Specialist |
20-Strategic Business Partner(CS-HR SBP/SBA) |
Design Rationale
No existing report in the reporting catalog provides a consolidated executive view comparing Merit outcomes before and after the campaign. A custom SuccessFactors Story Report is therefore required.
Assumptions
- Only active employees are included
- Merit campaign data is available and complete
- Historical compa‑ratio and salary data availability will be validated during build
Dependencies
- Availability and quality of Compensation module data
- Confirmation of historical data fields (before vs after values)
- Final RBP scope validation
Special Requirements
- Executive‑level readability and performance
- Ability to compare before vs after Merit cycle metrics
- Clear visibility on gender parity and equity indicators
Frequency of Analysis / Report Run
| Frequency |
|---|
| Annually |
Testing Considerations / Dependencies
- Validate budget and spend values
- Validate before vs after comparison logic
- Validate performance rating and talent pool breakdowns
- Validate access by role and scope
Test Conditions and Expected Results
| ID | Condition | Expected Result |
|---|---|---|
| TC01 | Open report without filters | Executive summary displayed for all active employees |
| TC02 | Filter by country | KPIs, charts, and tables update correctly |
| TC03 | Review before vs after metrics | Comparative values displayed correctly |
| TC04 | Review gender parity | Gaps and distributions displayed correctly |
Other Requirements
None identified.