General description 
This allows the users to slice and dice the dataset, similar to the likes of a pivot table in MS Excel.


Definitions and calculations
Dimensions: 
  • GBU
  • Departure Zone 
  • Plant
  • Subpackage
  • Vendor
  • Cost Category 
  • Costs description (PF1 = ShipCost Item category, WP1 = condition type)
Calculations: 
  • Total Transport costs (YTD) (1)
  • Total Transport costs (Y-1 YTD) (2)
  • Delta = (1) - (2)
  • %  = Delta  / 100
  • Nb of Shipments  (YTD) (3)
  • Nb of Shipments  (Y-1 YTD)(4)
  • Delta = (3) - (4)
  • % = Delta / 100
Color coding: 
  • Red = increase 
  • Green = drop 


Sources


Querries

Scope 

PROD_QV_BW_QRY_CPCOCT02_0001  QV_BW_QRY_CPCOCT07_0001
Permanent/set analysis:
- filter : BFC Account R12910




  • GBU Supply Chain 
  • Procurement organisation
  • SBS PSL
  • SBS Data Log
  • Transformation Center for Diagnostics



All the accesses must be validated by the Process Owner. 
No access restrictions on the perimeter.
Please request access to the dasboard using this form:
Access form