Page History

Operating segments are not available in BW queries. For ExCom and corporate reporting purpose, we add the Operating Segment based on the GBUs :

Materials : Specialty Polymers (SP), Composite Materials (CM)

Chemicals : Soda Ash and Derivatives (SD), Peroxides (PE), Silica (SI), Coatis (CT)

Solutions : Aroma Performance (PA), Novecare (CS), Special Chem (CH), Technology Solutions (TS)

Market and Segment displayed in the dashboard is taken from the hierarchy :

Market / Segment / Application / End-Use

The End-Use is defined by each GBU based on (GBU x Activity x ShipTo x Product) in GBR repository system. Each End-use use  is attached to a specific Market Application/Segment/ Application Market hierarchy, managed by Excellence Center.by Corporate Strategy.

In order to re-write the historical data/Order book Snapshots stored in QlikSense, we re-map the whole history based on the GBR Master Data on a daily basis. 

This is done by taking the mix; GBU x Activity x ShipTo x Product, and remap the historical data with the current definition of Market/Segment etc.

Specific case for SpP :

SpP define the End-uses within ICARE CRM system. A one shot updated update of GBR based on ICARE data has been was performed early may 2020. This one-shot mapping provide provides a market to 93% of PF1 Sales (in revenue) for SpP. WP1 sales are not yet mapped. As of today (late June 20), we're currently working with Excellence Center to include SpP in the GBR Maintenance process for End-Uses. Still in progress by mid-july 2020.

Specific case for Composite Materials :

The dimension dimensions AERO Pregram and AERO Market can provide are used to map into the corporate market dimension used by other GBUs (through a manual mapping). This won't give the lower levels such as Segment.

There are current efforts to apply the same logic in QlikSense (as not possible in Global Sales) . Not yet implementedas already done in the P&L, by using BW Master data query, to re-map Ship-to x Material x Main Specification x % on Program → to a Segment and Market. This will allows the market and segments to be populated when Composite Materials have fully deployed SAP.