Versions Compared

Old Version 4

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user Rachdi, Donia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Image RemovedImage Added


Info
iconfalse
titleProcess OwnerBusiness Application Owners
Solvay: Guillaume Gandemer
Syensqo: Carl Swart 
Jose-Ignacio Patino


Info
D&PS Expert
iconfalse
titleData Product Owner
Donia Rachdi



General Description

The Customer Engagement Analysis dashboard provides an overview of Solvay's complete Order Book with comparison capabilities that permits allows users to look at previous states of the Order Book.
The dashboard also gives a macro overview of Solvay's Opportunity Pipe.
Order Book
Opportunities
Scope:
  • All GBUs including Specialty Polymers and Composite Materials
  • Sales Orders only (External customers). No PO.
  • Exclusion of Peroxide JV.
Currencies and Exchange Rate:
  • EUR (CAR4 ) for Pending Orders 
  • EUR (CAR3) for Invoiced (P&L)
  • EUR (already converted by the GBU) for Composite Materials
  • Snapshots are stored directly in EUR, with the rate at the time we take the snapshot. If the rate is revised (monthly revision for instance), it will have no impact on the snapshot.

Sources for the dashboard include:

  • BW Global Sales queries (MVSDSO)
  • BW P&L query (MVCOPA)
    • Manual flat file for Composite Materials (non-SAP scope)
    Data Refresh Frequency:
    • Daily for all GBUs in BW including the CM scope in SAP
    • Weekly (on mondays) for CM Scope not yet in SAP
    Useful links on General Information and Sources:
    • To be Completed

    CEA - Order Book

    Orderbook anomaly detection tool - Celonis



    Info
    iconfalse
    titleTarget Users
    • ExCom members
    • Excellence Center
    • GBU Leadership Team


    Info
    iconfalse
    titleAuthorization & Rights
    All GBUs or by GBU.

    Definitions

    Definitions

    (Definitions related to Orderbook, see EC Order management Playbook)

    Invoiced Y-1 = Invoiced from P&L Query (or flat file)

    Invoiced = Invoiced from P&L Query (or flat file)

    Pending = Confirmed + Shipped not Billed from Global Sale Query (or flat file)

    Not Confirmend = No confirmed from Global Sales Query (or flat file)

    Excom and GBU LT members can access ALL GBUs' data.

    Others should only have access to their GBU.

    Validation:

    All ECO: Guillaume Gandemer

    All SCO: Carl Swart

    Data Sources / Mappings

    QVSD_BW_QRY_MVSDSO41_SD004 (Snapshot to be invoiced).