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)   

Collect all data related to Energy from the site. Data related to energy quantity, not converted in CO2 Emission. Data sources are SAP (WP1/PF1) , including IMEP data, Cost center postings and SKF postings. We also have some manual entry for site that are not in SAP. 

Contains SAP data + Manual entries


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)Energy data converted into CO2 Emission. BW_WBK_ECO2_0002BW_QRY_CPECO202_0001
ECO2 - Historical data from external file incl. CO2 conv.  (Core Query) Historical data from external file, energy quantity converted in CO2. BW_WBK_ECO2_0003BW_QRY_CPECO202_0002
ECO2 - Manual entries before CO2 conv. (Core Query)    Capture energy data for site that are not in SAP. The expert can input data via the transaction ZECO2.  Contains only only manual entriesBW_WBK_ECO2_0004BW_QRY_CPECO201_0002    

ECO2 - DataSource for ABECO204 (Core Query)

Technical datasource from CPECO01 in order to fuel conversion process in CPECO202

No prompt

n.aBW_QRY_CPECO201_0000

ECO2 - QV interface before CO2 conv. (Core Query)

For QV update with amounts and quantities in origin UoM

Authorization scope (lightbulb)

Fiscal Year Period

Site 

(lightbulb) PO2 flag : ECO/SCO

n.aQV_BW_QRY_CPECO201_0001

ECO2 - QV interface after CO2 conv. (Core Query)

For QV update with converted quantities in CO2 quantities. 

Authorization scope (lightbulb)

Fiscal Year Period

Plant

Site 

(lightbulb) PO2 flag : ECO/SCO

n.aQV_BW_QRY_CPECO202_0001

4.0 Functional Specification

4.1 General Data/Calculations 



4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainSustainability
ApplicationBW CERISE Queries
Provider

CPECO201 - Before CO2

CPECO202 - After CO2

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 split : Authorization group 

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

2 daily refresh : 2pm CET and 2 am CET