Log Analytics

General Description

Sheet Title	Transport Contract Compliance Overview	Transport Contract Compliance Details	Opportunity Assessment
KPIs	Transport costs Accrual accuracy	Costs distribution Details	Total costs Completion Total Costs Variation Completion costs Vendor Costs Payload Analysis Unit Cost per distance Freight Payment Info Airfreight Service Level

General Dimensions
GBU Costs description Cost category Package Sub Package BFC Group of activities Completion Year Month Delivery Line Departure Point Departure Country Departure Zone Destination Country Material Packaging Material Ship to Shipment Number Shipping Type Vendor Plant Flow standard

Period of Analysis

There are 2 timelines in Log analytics dashboard:

Posting date (main)
Shipment Completion

Scope: From YTD Y-1 to YTD Y in the dashboard

Default selection:

YTD Y-1 vs YTD Y (posting date)
Ability to filter on Completion date in “Opportunity assessment” page

Refresh frequency:

Currencies
EUR
Currency rate : CAR3 ( monthly average rate ) Each set of cost data is associated to a Month and a Year and has a currency, the rate is to be applied depending on the month and currency of the data, regardless of the time selection active in the dashboard (ie: the rates are applied in the script and costs are displayed “as is” in the dashboard)

Target Users

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

Page tree

Log Analytics

Sébastien Willemse

KPIs

Transport costs

Accrual accuracy

Costs distribution Details

Total costs

Completion Total Costs

Variation Completion costs

Vendor Costs

Payload Analysis

Unit Cost per distance

Freight Payment Info

Airfreight Service Level

GBU

Costs description

Cost category

Package

Sub Package

BFC Group of activities

Completion Year Month

Delivery Line

Departure Point

Departure Country

Departure Zone

Destination Country

Material

Packaging Material

Ship to

Shipment Number

Shipping Type

Vendor

Plant

Flow standard

There are 2 timelines in Log analytics dashboard:

Posting date (main)

Shipment Completion

Scope: From YTD Y-1 to YTD Y in the dashboard

Default selection:

YTD Y-1 vs YTD Y (posting date)

Ability to filter on Completion date in “Opportunity assessment” page

Refresh frequency:

EUR

Currency rate : CAR3 ( monthly average rate )

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