1.0 Overview


SPM is instrumental at Solvay to take robust decisions by integrating sustainability in its business growth ambition. It will support the ambition to intensify the sustainable management of the group's portfolio.

Key user profiles: 



Target Users: 

  • In GBUs : Sales & Marketing Teams, SPM contact
  • Corporate : Sustainable Development, Strategy

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

27.11.2023

Emma Glasson

Initial draft










Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Others - Flat files

2.0 Business Process



3.0 Application Feature Overview


ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name
SPM Reporting

Auth Scope (lightbulb)

Calendar Year 

Calendar Month

GBU

Intra-GBU

BFC GBU

SPM BU

GBR Market 

GBR Segment

GBR Application 

GBR Corp end use 

Product Line 2

UoM for Qty conversion(star)


(star) mandatory field

(lightbulb) PO2 flag : ECO/SCO

n.a

BW_QRY_MVSDSP01_0001


Qlikview Query: 

QV_BW_QRY_MVSDSP01_0001

4.0 Functional Specification

4.1 General Data/Calculations 


Key words

Definitions

Challenges
Red part of the heat map. PACs for which there are either strong negative signals resulting from sustainability drivers in the marketplace, or serious operations vulnerability challenges. These are products where there may be a significant negative impact on revenue over time and where products may eventually disappear.
Solutions
Green part of the heat map. PACs with a better sustainability contribution to Solvay customers and value chain, combined with a favorable balance between value and environmental impact.
Neutral
Grey part of the SPM Heat Map. PACs which do not have outstanding sustainability performance, if any. Low operations vulnerability is not combined with favorable sustainability drivers in the marketplace. These are products that consumers need, but which do not contribute to environmental footprint reductions.
Not Evaluated
Product in application not evaluated with SPM.
Not Assigned
No link defined between commercial sales and SPM 
SPM PAC
or PAC
Production Application Combination. A PAC is a clear and identifiable "end use" market of a product, as close as possible to the final use of the product at the level of the end user or final consumer.
SPM Product
A SPM Product differs from SAP products in that it represents a family of commercial products with the same or very similar chemistry, manufacturing process, or "manufacturing footprint".
SPM Market Alignment
Market alignment of products in their application analyzes the market signals of sustainability benefits and roadblocks. It categorizes products on a give scale spectrum from "challenged" to "star potential". This spectrum analyzes whether one product in a given application is part of the sustainable development solution or part of the problem from a consumer and market perspective.
SPM OV Category
Operations Vulnerability is the ratio of monetized environmental footprints of products over their sales value. It is the monetized environmental manufacturing footprint per 1 EURO of revenue. The higher the ratio, the higher the risk for Solvay of losing business to more sustainable solutions. The lower the ratio, the higher the probability to displace a less environmentally friendly competing technology.
SPM
Sustainable Portfolio Management.

4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainSustainability
ApplicationBW SPM Queries
ProviderMVSDSP01
Existing Documentation


4.2.2. KPI's/Calculations/Indicators 

Indicators available: 

Indicatores/KPI's

Definition

Calculation/Extraction of data

Quantity P&L in KG



Conv. QtyQuantity in UoM selected
Act. sales P&L (EUR)

5.0 Non-functional Descriptions 

5.1 Usability

as per standards

5.2 Regulatory Compliance

GDPR compliant.

5.3 Security

  • Only authorised Users be able to access data.
  • PO2 compliance 

5.4 Performance

as per standards

5.5 Reliability  

as per standards

5.6 Scalability

Historical report, no small enhancements will be performed and no new access except for new joiners in HR domain.

5.7 Compatibility

as per standards

5.8 Availability

as per standards

5.9 Refresh of the Data

Refresh is scheduled daily at 05:00 (CET).