You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »


Process Owner

Jose-Ignacio Patino

D&PS Expert


General Description

Scope:

  • All GBUs including Specialty Polymers and Composite Materials
  • Sales Orders only - External Sales
  • No PO orders (WP1)
  • Exclusion of Peroxide JVs (0360 Nippon Solvay, 5985 Basip Silent Partner, 6034 Mtp Hpjv (Thailand), 6235 Saudi Hydrogen Per)
  • Exclusion of Soda Ash & Derivatives "Waste" by-products:


KPIs:

  • Total Order Book M (Invoiced + Pending + Not Confirmed (Y/N selection))
  • Invoiced M
  • Pending M (Confirmed + Shipped not billed)
  • Not Confirmed M, this can be swithed on or off with the Y/N selection)
  • M+1
  • M+2
  • M+3
  • Actual Sales EoM Y-1

Available in both M€ and volumes in Tonnes


Dimensions:

Dimensions Overview

Exceptions:

  • The first of each month of ther Order book is replaced by M-1 Actual Sales.
  • Data corrections may be applied to historical data by Commercial Excellence team.

Currencies and Exchange Rate:

  • Pending, M+1, M+2, M+3 : extracted in local currency and converted to EUR using CAR4 exchange rate, which are simulation future rates defined by corporate finance
  • Invoiced, Actual Sales M-1, Actual Sales EoM Y-1 : extracted in local currency and converted to EUR using CAR4 exchange rate, which is the monthly average rate applied to each month in question
  • Composite Materials Actual Sales and Order Book: displayed EUR which are already converted by the GBU

*Snapshots are stored 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:

  • Pending, Not Confirmed, M+1, M+2, M+3 : BW Global Sales query (QVSD_BW_QRY_MVSDSO41_SD004)
  • Invoiced, Actual Sales M-1, Actual Sales EoM Y-1 : BW P&L query (QVSBS_BW_QRY_MVCOPA01_0004)
  • Manual flat file for Composite Materials - QV server folder: \\WDCQSAP31\Composite Materials Manual Sales
    • Full Order Book
    • External Sales excl WP1
    • WP1 Actual Sales come from the P&L query.

Data Refresh Frequency:

  • Daily CET (morning, mid-day, evening). Snapshot are saved after last data refresh of the day.
  • For Composite Materials, the manual data files are posted Weekly (on mondays) for Order Book, and monthly for Actual Sales excluding WP1

Target Users

  • ExCom members
  • Excellence Center
  • GBU Leadership Team

Authorization & Rights

All GBUs or by GBU.

Data Snapshots

This dashboard introduce the concept of historised snapshot that we didn't have until now in the dashboards. The daily state of indicators is stored in QlikSense, with the strictly necessary dimensions useful for the dashboard.

Limitations on dimensions

The non-necessary dimensions are not stored in the snapshots for technical reasons. This means that if we need to add a dimension, or if we need to redefine a perimeter, we cannot retreat the history. In a few exception cases, the snapshot history can be retreated. The cases must be assessed by the technical team.


Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels