Versions Compared

Old Version 5

changes.mady.by.user Ismail AMMOR

Saved on

compared with

New Version Current

changes.mady.by.user GIRAUD-ext, Mickael

Saved on

Key

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

(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

QV - Forecast Accuracy for Global Supply Chain Dashboard - All except CM (Aero) 

Please update the new doc there and no longer here.

(warning)    (warning)     (warning)     (warning)



Info

The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description

BW - DP - Forecast Accuracy (QV query)

Technical NameQV_BW_QRY_MVDYN11_0005

Application

DP - Demand Planning

Info-provider

MVDYN11

Usage type

Used for QV application

Expected users


Table of Contents
maxLevel3

Workbook/Query General Description

This query is a copy of initial BW initial BW - DP - Forecast Accuracy (Core query) -  BWBW_QRY_MVDYN11_0005

It was first created for QV application (Global Supply Chain Dashboard), now it is used for Tableau


To access QV : qlikview.solvay.com => Applications Global Supply Chain Dashboard will be accessible up to 2023 July 31th

To access QV : qlikviewTableau : https://tableau.solvay.com2 Applications : Novecare Supply Chain + => Global Supply Chain Dashboard

Image Removed

here 

Documentation for GSC Dashboard => wiki / Training deck highlighting the changes here / Video recording of one of training sessions there

Image Added

See document for updates, tab "Summary Export/Refresh time"

Embedded Google Drive File
docid1EABK8bhuYtho0SvqweVQoXJpKg9nuCHP1you6H4GM70
Image Removed

General parameters

Global properties

TabScreenshotComment
Display
Image Modified
 

Rows/Columns
Image Modified
To shadow columns without data
Value Display
Image Modified
 

Planning
Image Modified
 
Extended
Image Modified
 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

CALMONT2

Calendar Month/Year (Interval, Mandatory)

0CALMONTHInterval/Mandatory/ManualEntryYes 

V_CPFCTR1_2_0008

Global Business Unit (Selection Option, Optional, Auth)

CPFCTR1_2SelectionOption/Optional/Authorization/ManualEntryNo 

V_C_MATNR2_0001

Material (Selection option)

C_MATNR2SelectionOption/Optional/ManualEntryNo 

CPROD01

Commercial Product (Select option, Optional)

C_MATNR2__C_PRODSelectionOption/Optional/ManualEntryNo 

VPROD_HIER

Product Hierarchy (Selection option, optional)

C_MATNR2__0PROD_HIERSelectionOption/Optional/ManualEntryNo 

V_CUSTID_0002

Ship-to (Selection option)

C_SHIPIDSelectionOption/Optional/ManualEntryNo

Replace C_CUSTOMR in V1

0DISCHAN

Distribution channel

0DISTR_CHANSelectionOption/Optional/ManualEntryNo 

V_C_GBR6_0001

GBR Customer Group (Select Option, Optional)

C_GBR13__C_GBR6SelectionOption/Optional/ManualEntryNo

Ship-to info

V_0COUNTRY_0003

Ship-to Country (Selection option, Optional)

C_SHTCTRY

SelectionOption/Optional/ManualEntry

No

C_CUSTOMR__0COUNTRY in V1

V_C_GRCUST_0001

Industrial Group (Selection option, Optional)

C_SOLDID__C_GRCUSTSelectionOption/Optional/ManualEntryNo

Sold-to info 


V_C_SAL_GRP

Sales Group (Selection option, Optional)

C_DYN_017__C_SAL_GRP

SelectionOption/Optional/ManualEntryNo

Sales Group = Sales Rep

only for RCS

V_C_GZONE

Geo Zone (Selection option, Optional)

C_SHTCTRY__C_GZONESelectionOption/Optional/ManualEntryNo 

C_MATNR2__C_MAT_GRP_0001

Material Group (Selection Option, Optional)

C_MATNR2__C_MAT_GRPSelectionOption/Optional/ManualEntryNo

Previous V1 => IO not compound

C_MATNR2__0MATL_GROUP

DCF / Material group

Bex variable 0S_MATGR

V_C_PLANT_0010

Plant (Selection Option, Optional)

C_DYN_018__C_MPPLANTSelectionOption/Optional/ManualEntryNo 

V_C_ZONE_0005

BFC Geo/Zone (Selection option)

C_SHTCTRY__C_ZONESelectionOption/Optional/ManualEntryNo 

 



Variable Sequence

Image Modified

Filters

ObjectFilter ValueExplanation
Concerned Period (C_FLGMTH)

M

M-2

M-3

M-4

M-5

M-6

M correspond to period M, and snapshot, end of previous month

NB: Value M-1 does not exists. The values of previous month are stored on value M 


Provider (0INFOPROV)

<> DYN - Reporting (CRDYN11)

<> APO - Global (Dynamic) (CRAPO002)

<> DYN - Reporting PAX Historic (CRDYN14)

<> DYN - Reporting PV/PX/PV since 2019 (CRDYN15)

Cubes exclusion CRDYN11/14/15 and CRAPO002 added 12/02/2019

)

<> DYN - Reporting PV/PX/PV since 2019 (CRDYN15)

Cubes exclusion CRDYN11/14/15 and CRAPO002 added 12/02/2019
Active DFU (Yes/No)

Image Added

Flag not available for APO, so value "#" for APO records

Exclusion of non active DFU (<> N), to keep value 'Y' for DynaSys and '#' for APO

Filter added 14/10/2020

Key figures

No decimal for all Key Figures, as in Dynasys.

Key Figure M-2 to M-6 are currently not shown in the query => wait for old photo loading to validate Key Figures

  
 
DescriptiontypeRestricted or Calculated KeyFigureCalculation ruleConversionComments

GH / Gross History

Display

Image Modified 


QCT_MATNR5

(March 17 Release)

 


FF / Final Forecast M1Display 
Image Modified

QCT_MATNR5

(March 17 Release)

 
STF / Sales Team Forecast M1Hidden 

Image Modified

QCT_MATNR5

(July 17 Release)

 
STATF / Statistical Forecast M1Hidden 

Image Modified

QCT_MATNR5

(July 17 Release)

 


Demand Review ForecastHidden 

Image Modified

QCT_MATNR5

(May 18 Release)

It is shifted forecast (S_KF2). Apply only for special chem
ABS Bias FF M1Hidden 
Image Modified

QCT_MATNR5

(March 17 Release)

 


ABS Bias STF M1Hidden 

Image Modified

QCT_MATNR5

(July 17 Release)

 
ABS Bias STATF M1Hidden 

Image Modified

QCT_MATNR5

(July 17 Release)

 


ABS Bias DRF M1Hidden 

Image Modified

NoIt is shifted forecast (S_KF2). Apply only for special chem
FA FF M1Display 

Image Modified

No

Previous formula (before March 2017 release)

Image Modified 


Previous formula (before february 2017 release)

Image Modified

FA STF M1

Hidden

 


Image Modified

No 
FA STATF M1Hidden 

Image Modified

No 
FA DRF M1Hidden 

Image Modified

NoIt is shifted forecast (S_KF2). Apply only for special chem
Bias FF M1Hidden 

Image Modified

Image Modified

No 
Bias STF M1Hidden 

Image Modified

No 
Bias STATF M1Hidden 

Image Modified

No 
Bias DRF M1Hidden 

Image Modified

NoIt is shifted forecast (S_KF2). Apply only for special chem
FA aggr. FF M1Display 

Image Modified

No

Previous formula (before March 2017 release)

Image Modified


Previous formula (before February 2017 release)

Image Modified

FA aggr. STF M1Hidden 

Image Modified

  

FA aggr. STATF M1Hidden 

Image Modified

  



FA aggr. DRF M1Hidden 

Image Modified

NoIt is shifted forecast (S_KF2). Apply only for special chem
Relative Error FF M1Display 
Image Modified
No

Previous formula (before february 2017 release)

Same without NDIV0

Relative Error STF M1Hidden 

Image Modified

No 
Relative Error STATF M1Hidden 

Image Modified

No 
Relative Error DRF M1Hidden 

Image Modified

NoIt is shifted forecast (S_KF2). Apply only for special chem

FF / Final Forecast M2

STF / Sales Team Forecast M2

STATF / Statistical Forecast M2

Demand Review Forecast M2

ABS Bias FF M2

ABS Bias STF M2

ABS Bias STATF M2

ABS Bias DRF M2

FA FF M2

FA STF M2

FA STATF M2

FA DRF M2

Bias FF M2

Bias STF M2

Bias STATF M2

Bias DRF M2

FA aggr. FF M2

FA aggr. STF M2

FA aggr. STATF M2

Bias DRF M2

Relative Error FF M2

Relative Error SATF M2

Relative Error FF M2

Relative Error DRF M2

Hidden 
Same calculation than for M1 but limited to Concerned Period (C_FLGMTH) = 'M-2'

QCT_MATNR5

(March 17 Release)

 


And so one till M6   


QCT_MATNR5

(March 17 Release)

 


Key Figure 1

Description

Calculation rule detail

Text Replacement Variable

Currency Conversion

Exchange Rate Type : 

Currency : 

Time Reference : 

Unit Conversion

Unit : 

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0CALMONTHCalendar Year/MonthText
Rows0LOGSYSSource SystemNo display to avoid the display of the prefix for compound characteristics.
RowsC_MATNR2Material

Key + Text

RowsC_SHIPTIDShip-to

Key + Text

Previously, the Ship-to was C_SHIPTO, but description were not daily loaded.

Description Ship-to will change to SAP Ship-to soon

Rows0DISTR_CHANDistribution Channel

Key + Text

Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU.

FreeCPFCTR1_2BFC Global Business Unit

Key + Text

From DSO DBDYN02 to get the BU (C_DYN_010), then MasterData C_DYN_010 to get the GBU

FreeC_MATNR2__0PROD_HIERProd. HierarchyKey + Text
FreeC_MATNR2__C_PRODCommercial Product

Key + Text

Commercial Product is only available for RCS WP1. Do not exists for SOLVAY PF1.

FreeC_CUSTGP2Enterprise Customer Group

Key + Text

Will remain only for APO (new axis for Dyn)

FreeC_SHTCTRYShip-to CountryText
FreeC_SOLDIDSold-to

Key + Text

Previously, the Sold-to was C_SOLDTO, but description were not daily loaded.

FreeC_SOLDID__C_GRCUSTIndustrial Group

Text

V1 = C_CUSTOMR__C_GRCUST

For V2 it has been changed for C_CUSTID. The field KONZS is taken from PRS Customer. PRS seems not contains all customers (only payer?). If Customer Group (C_GRCUST) are missing, the masterdata will have to be upgraded to get missing ones.

FreeC_DYN_017__C_SAL_GRPSales GroupSales Group = Sales Rep = Only for RCS
FreeC_SHTCTRY__C_GZONEGeo ZoneNo description available
FreeC_DYN_005__C_TACTIC2Tactical MaterialDescription are available since 08/12/2016
FreeC_DYN_017__C_ZIPARTCSO

Customer Service Officer (CSO)

Only filled for RCS

FreeC_CUSTOMR__0REGIONShip-to Region 
FreeC_CUSTOMR__0CITYShip-to City 
FreeC_DYN_018__C_MPPLANTMain Shipping Plant 
FreeC_MATNR2__C_MAT_GRPMaterial Group 
FreeC_MATNR2__C_MATGR2Packaging Type

Previous name : Material Group 2 (Release March 2017)

For Solvay PF1 only

FreeC_MATNR2__C_DIVISNDivision 
FreeC_DYN_010BU 
FreeC_DYN_018__C_MSHCONDMain Shipping Cond.

Available since 07/02/2017

Shipping Condition of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)

FreeC_DYN_018__C_INCOTRMIncoterms

Available since 07/02/2017

Incoterms of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)


FreeC_DYN_018__C_DYN_016

Key Account

(Ship-to KA)

RCS notion

Text in MD C_GRCUST

Available since 14/03/2017

For DynaSys/Logility, now use Ship-to KA (GBR) (C_GBR15__C_SHIPKA)

FreeC_MATNR2__C_MAGRVPackaging Materials

Only for RCS

Available since 14/03/2017

FreeC_DYN_018__C_VEPARTAccount Manager

PF1 notion

Release April 2017

FreeC_DYN_018__C_VWPARTCCS Rep

PF1 notion

Release April 2017

Free

C_DYN_021__C_DYN_020

Planning Zone

DYN Only

Available since 18/11/2019

FreeC_GBR14__C_GBR1GBR: Application 
FreeC_GBR14__C_GBR2GBR: Market 
FreeC_GBR14__C_GBR3GBR: Segment 
FreeC_GBR14__C_GBR4GBR: Corporate End Use 
FreeC_DYN_021__C_DYN_022ABC Class (auto)DYN Only
FreeC_DYN_021__C_DYN_023ABC Class (manual)DYN Only
FreeC_MATNR2__C_LPRODLIP00Since Solstice
FreeC_MATNR2__C_LIP04LIP04Since Solstice
FreeC_MATNR2__C_FMPRDProduct Group (family)Since Solstice
FreeC_PGMI__C_GRPPGMIItem ClassSince Solstice
FreeC_GBUZONE__C_ZONEH1GBU zone (hierarchyKey and Text => Dyn Only
FreeC_GBUZONE__C_ZONEH2GBU zone (hier. 2)Key and Text =>Dyn >Dyn Only
Free0G_CWWE01IECRAAPO Only
FreeC_GBR18__C_GBR19GBR Material Group

Key and Text

Available since 31/10/2017

FreeC_GBR13__C_GBR9GBR Customer Sub Group

Key and Text

Available since 31/10/2017

FreeC_GBR13__C_GBR6GBR Customer Group

Key + Text

Available since 31/10/2017

Free C_GBR15__C_SHIPKAShip-to KA (GBR)

Key and Text

Available since 31/10/2017

Free C_SHTCTRY__C_ZONEBFC Geographie/Zone

Key and Text
Available since 31/10/2017

FreeC_DYN_018__C_INCOTRMIncoterms (Solvay)

Key
Available since 18/10/2018

FreeC_DYN_018__C_INCOTM2Incoterms 2 (Solvay)

Key
Available since 18/10/2018

FreeC_DYN_017__C_INCOTRMIncoterms (RCS)Key
Available since 18/10/2018
FreeC_DYN_017__C_INCOTM2Incoterms 2 (RCS)Key
Available since 18/10/2018


If you have 2 structures and special cells calculations, explain here. Cells

Conditions

 
Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement     






Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No