1.0 Overview


Cerise (Co2 Energy Report Improvement Software Efficiency) has been launched end of 2019 and implemented in 2020/2021; the aim of the project is to provide Solvay with: 

    •  A robust and simple reporting solution, giving a detailed view of energy consumption/expenses and CO2 emissions
    • An automated solution to manage ETS (European Trading Scheme) exposition for all sites concerned in Europe (~30 registers), giving a projection of EUA (EU Allowances) balance for 10 years, to be able to decide the right time to hedge EUAs on the market


Key user profiles: 



Target Users: 


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
ECO2 - Database before CO2 conv. (Core Query)   


Authorization scope (lightbulb)

Fiscal Year Period

Plant

Site 

(lightbulb) PO2 flag : ECO/SCO



BW_WBK_ECO2_0001BW_QRY_CPECO201_0001    
ECO2 - SAP database after CO2 conv. (Core Query)
BW_WBK_ECO2_0002BW_QRY_CPECO202_0001
ECO2 - Historical data from external file incl. CO2 conv.  (Core Query) 

BW_WBK_ECO2_0003BW_QRY_CPECO202_0002
ECO2 - Manual entries before CO2 conv. (Core Query)    

BW_WBK_ECO2_0004BW_QRY_CPECO201_0002    

4.0 Functional Specification

4.1 General Data/Calculations 



4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainSustainability
ApplicationBW CERISE Queries
ProviderCPECO202
Existing Documentation

Cerise Project presentation

4.2.2. KPI's/Calculations/Indicators 

Indicators available: 

Indicatores/KPI's

Definition

Calculation/Extraction of data




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