Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 4

changes.mady.by.user Xiang Yun Ong

Saved on

compared with

New Version Current

changes.mady.by.user David TONDA

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
titleChange to Special Chem

Due to the change of GBU from "Rare Earth" to "Special Chem", the dashboard is in progress of beeing updated. Some KPI's will now include all RCS Special Chem Data (RES + Fluo). Some will only keep RES for the moment.

 

Table of Contents
maxLevel3

Presentation

History

The Rare Earth Systems Key Account Dashboard (RES KA Dashboard) was built between December 2013 and

Rare Earth Key Account Dashboard Documentation

Table of Contents
maxLevel3

Presentation

History

The Rare Earth Systems Key Account Dashboard (RES KA Dashboard) was built between December 2013 and February 2014 on request of Francois BELET and with a sponsorship by Arnaud WISNIA.

...

The dashboard can be accessed via the Qlikview Access point and then selecting the “RES Key Account Dashboard”

http://qlikview.solvay.com/index.htm

Data update

The data in the dashboard is updated every Monday at 7h30 Paris Time

...

On most of the graphics, you will have an option to choose a dimension from the “Cyclic” selection:

Dimensions availability

+Note that not all dimensions work for all KPI.

Below is the table showing which KPI work with which filters:

Note that not all dimensions work for all KPI.

Below is the table showing which KPI work with which filters:

Zone See Note4Country XXIECRA XXLegal Entity XXXXXXSee Note1

Dimension/KPI OTIF-A OTIF-C LeadTime Respect LeadTime Flexibility Claims Inventory DOS Overdues Forecast
Accuracy*

  • O Changes*
  • O Confirm/Speed

Ship to KA X

X

X

X

X

  • See Note3
  • See Note3
  • ee Note6
Dimension/KPIOTIF-AOTIF-CLeadTime RespectLeadTime FlexibilityClaimsInventoryDOSOverduesForecast
Accuracy		PO ChangesPO Confirm/Speed
Ship to KAXXXXX* See Note3* See Note3*See Note6XXX
ZoneXXXXX  * See Note4 XX
CountryXXXXX  * See Note5 XX
IECRAXXXXX  X   
Legal EntityXXXXXX* See Note1X  X
Mat.Ent.GrpXXXXXXXX XX
Mat.Ent.Sub GrpXXXXXXXX XX
PlantXXXXXX* See Note2  XX
Prod PlantXXXXX* See Note3* See Note3X XX
ProductXXX
XXX
XXXXX
Ship toXX
XXX
 
 * See Note5 XX
Delivery TypeXXXX
 
 
 
 
 
 
 
Interco
 X

X

Mat.Ent.Grp X

X

X

X

X

X

X

X

X

X

Mat.Ent.Sub Grp X

X

X

X

X

X

X

X

X

X

Plant X

X

X

X

X

X

  • See Note2

X

X

Prod Plant X

X

X

X

X

  • See Note3
  • See Note3

X

X

X

Product X

X

X

X

X

X

X

X

X

X

X

Ship to X

X

X

X

X

  • See Note5

X

X

Delivery Type X

X

X

X

Interco

X

X

Motives

X

Status

X

Resolution Plant

X

Severity

X

GL Account Sub Type

X

Valuation Class

X

  X      
Motives    X      
Status    X      
Resolution Plant    X      
Severity    X      
GL Account Sub Type     X     
Valuation Class     X     

Example: if Example: if you filter on an “IECRA”, the Inventory report will not work properly. This is because the IECRA is a sale dimension and has no corresponding dimension in the inventory data.


Note 1: 

Careful when looking at the legal entity in the DOS as the DOS is calculated from Sales and Inventory and the legal entity notion is different between the 2 (Sales h1.= Invoicing entity, inventory = entity owning the inventory).

Note 2:
Careful when looking at the plant in the DOS as the DOS is calculated from Sales and Inventory and the plant notion is different between the 2 (Sales h1.dispatch  = plant, inventoryplant where the goods are stored, or plant of the transit).

...

Note 5:
In the case of the account receivables data, the Ship To and Country are not the Ship to, but the customer from the invoice (and country of that customer).

Note 6:

In the case of the account receivables data, the Ship to KA is actually the "Customer Group".

...

The Key Account (or KA) is the main dimension in this dashboard.

+What is it ?

  1. Key Account is a grouping of customers. As in SAP a customer (Ship to) is created for a location/address (Ex : BASF in Shanghai, BASF Paris), you can have many different customers in SAP for a single account. The objective of the Key Account grouping is to allow to show the KPIs for all the locations of a single account called "Key Account" (Ex : BASF Paris and BASF Shanghai are grouped under a unique BASF Key Account)

 

Section
Column
width50%

How is it defined ?

...

 

The Key Account is defined for each combination of "Material + Ship to". Potentially a Ship to could be linked to several Key Accounts for different materials.

Default selection 

By default when you open the dashboard only the "TOP 10" Key Accounts are selected.

The Top 10 is calculated based on

...

the total sales value in the past 2 years.

You can r

...

emove the default top 10 selection

...

 by removing the filter on the "Current Selections" screen.

You

...

can come back to only selecting the top

...

10 by clicking on "TOP 10 KA by Sales" button on the right side bar

...

Image Added

 

About the excluded Materials

...

Material Code

Material name

119868

DPR ZIRCONIUM NITRATE

119869

DPR THORIUM OXYDE

119870

DPR THORIUM SALTS

119871

DPR CERIUM CARBONATE

119872

DPR CE LA PR ND CARBONATE

119873

DPR OTHER RE COMPOUNDS WITH CERIUM

119874

DPR RE OXYDE OR SALTS WITHOUT CERIUM

119875

DPR OTHER COLORING MATERIAL

119876

DPR PHOSPHOR

119877

DPR FUELS ADDITIVES

119878

DPR PREPARATIONS CHEMICAL INDUS. OTHER

119879

DPR ALUMINIUM OXIDE - SA<350m2/g

125831

DPR POLISHING POWDERS

126145

DPR NON SUPPORTED CATALYSTS - OTHER

126392

DPR ALUMINUM OXIDE - SA>350

126394

DPR CE/LA CARBONATE

Dimensions definitions

DimensionDescriptionHow it's defined
Delivery TypeThe type of dispatch: Air, Road, Pickup...Defined in each delivery.
GL Account Sub TypeGeneral Ledger Account Sub type. Classification of the inventory in "On hand" (in site MM stock) or "In Transit" (FI inventory)Defined for each GL account.
IECRAThe market of the sale.This is defined for each Sales Order by the Distribution Channel and the Division
Legal EntityCompany of the invoice (overdues) or of the plant (Inventory) 
Mat.Ent.GrpMaterial Enterprise Group. Grouping of several productsDefined at GBU level by the data administrator for each material.
Mat.Ent.Sub GrpMaterial Enterprise Sub Group. Grouping of several productsDefined at GBU level by the data administrator for each material.
MotivesMotive of the claim (Packaging, delivery...)Defined in each claim
Plant
The delivery plant (plant shipping the goods)
*For inventory, it’s the plant where the goods are stored.		 
Prod PlantThe production plant of the material.This is defined by the data administrator tor for each “Material+Plant” key. Each material/plant can have only 1 production plant. Note that this means this is not the actual production plant but the one defined in the master data.
ProductGrouping of materials as Commercial Products 
Resolution PlantPlant that solved the claim. 
SeveritySeverity of the claim (Standard, Critical...)Defined in each claim
Ship toThe customer to who the goods were shipped. 
Ship to Country (or "Country")Country where the goods were shipped.It’s defined for each Ship To customer.
Ship to KAShip to Key Account. This is a grouping of several customers into a “Key Account” groupThe Key Account is defined for each “Material + Ship to” key and managed at group level by the data administrators.
Ship to zone (or "Ship to Location")Geographical zone of the Ship to Customer 
StatusCurrent status of the claim (Open or closed)"Open" unless claim status is "Closed" (all other smart status are grouped under Open)
Valuation ClassClassification of the inventory into Finished Goods or Traded Goods.Defined for each material in each plant.

Time dimensions

+The dashboard includes data for the previous and current years.

The period can be selected on the top via these 3 filters:

...

Below is the table showing for each KPI the meaning of the period (more details in the individual KPI details page):

Forecast
KPIDate for time dimension
OTIF-AOrder First ATP Good issue Date
OTIF-COrder last requested delivery date cust
LeadTime RespectPurchase order date
LeadTime FlexibilityDespatch actual good issue
ClaimsClaims Reception Date
InventoryEnd of month stock (Posting date)
DOSInventory month & Sales month (see detail calculation)
OverduesEnd of month balance (Posting date)
Forecast 
Accuracy		Order last requested good issue customer / forecast month
PO ChangesSales Order Item creation date

Flags

On the left menu, you can find 2 flags which can be de-activated:

...

Tab & KPI definitions

Information

The information tab provides several useful data on the dashboard:

Links
inks to the documentation (including this one) Image Modified 
For each KPI a short description & reasonImage Modified

List of evolutions/correctionsImage Modified

Date of last data update

...

Image Modified
List persons who have access to the dashboardImage Modified

KA Focus Tab

The KA focus tab aims at showing a global view of each major KPI in a single screen without detail.

...

The period is the last requested delivery date by the customer

See more details on OTIF-C

Objective of the KPI

Does Solvay respect the last agreed delivery dates and quantities?

...

The period is based on the Order first ATP good issue date by the customer.

See more details

Objective of the KPI

Does Solvay meet the first requested date good-issue date?

...

Definition:
The Lead Time Respect by Customer KPI shows the % of orders placed according to the agreed lead time. It is defined as the percentage of order items for which the actual lead time was smaller than the contractual lead time

+The Lead Time is defined as the number of days between purchase order reception date and the first requested good issue.

...

The Lead Time is defined as the + number of days between purchase order reception date and Despatch actual good issue date.

...

To reduce the inventory and increase the useful capacity.

See more details

Claims

Definition:
The claims KPI is defined as the number of claims received.

The period is based on the claim reception date.

  1. link to the RES SMART Complaints dashboard which is more detailed is provided:

See more details

Objective of the KPI

Reduction of claims numbers by continuous quality improvement.

...

Inventory is assigned to Key Accounts based on a special coefficient (calculated from the sales).

See more details

Objective of the KPI

Quality the impact of forecast accuracy/planning process.

...

Improve the cash and reduce the number of blocked orders.

See more details

PO Speed

Definition:
Shows the “PO confirmation speed” defined as the average number of days between the order reception date and the confirmation to the customer.

...

All files are found in this network folder:

*
\\FRPARQLAP01\RES KA - Target & Leadtime*

Access is provided by the Reporting Competence Center. To request it, please contact the IS Application Helpdeskcustomer support team.