Versions Compared

Old Version 3

changes.mady.by.user Marboeuf-ext, Maxime

Saved on

compared with

New Version Current

changes.mady.by.user MARBOEUF-ext, Maxime

Saved on

Key

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

PCF Application relies on 2 workbooks published on Tableau Cloud, and available to a selection of Syensqo’s Users as per security requirements specified prior.


This document aims at navigating the data source panel as well as knowing how to reach underlying data from the source. But also, outline all computed elements on each dashboard currently available on all Tableau servers projects:

PCF - Product Carbon Footprint

PCF - Carbon Footprint - UAT

PCF - Product Carbon Footprint - DEV


  1. Data connection

             a. Service Account

While dashboards can have a User as project or workbook owner. Connection and extraction of data from Google big query will always be used from a dedicated Service account. Credentials need to be requested to and granted by CloudOps team.

These credentials will allow connection and data extraction from each GCP projects and are available on Google Drive. 


               b. Data Source Panel

Tableau workbook will only extract data from Google Big Query following the same model for all dashboards and each data source as seen below:



         2. PCF - Product Carbon Footprint Advanced Workbook


    1. Product List dashboard



Image RemovedImage Added


                   bb. Product List Calculated fields


Please refer to the document:

 

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1Lgq619jpQLLT0R1TPbKRC4rPFMHCeX6Abijo2jKfjCs1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=sharingdrive_link&ouid=110708705167722191522&rtpof=true&sd=true


              

                    c. Biogenic dashboard



Image RemovedImage Added


                   dd. Biogenic Calculated Biogenic Calculated fields

DatasourceTypeNameRemote_NameFormulaFieldsDM_AferCo2dimension[Get Data][Calculation_232357629698338818]"Get Data" DM_AferCo2dimension[Show/Hide][Calculation_2756906693307473920][Parameters].[Show/Hide] [Show/Hide]DM_AferCo2dimension[Reset Button][Calculation_303500426508730368]'Reset All Filters' DM_AferCo2measure[Counter +1][Calculation_3313523471385870337][Parameters].[Counter] + 1 [Counter]DM_AferCo2measure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true


                  e. Breakdown dashboard


Image Added

Image Added





                  f. Breakdown Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true


   

DM_AferCo2dimension[Fiscal Year ][Calculation_369576648555298819]DATE(DATEPARSE ( "MMMM-yyyy", str([Month]+'-'+[Year]) ))  [Month], [Year]DM_AferCo2dimension[Month][Calculation_369576648803409928]DATENAME('month',  date('2020-' + iif(int(RIGHT([Fiscal_Year_Period],2)) < 10, '0','') + str(RIGHT([Fiscal_Year_Period],2)) + '-01')) [Fiscal_Year_Period]DM_AferCo2dimension[Year][Calculation_369576648804302857]LEFT([Fiscal_Year_Period],4) [Fiscal_Year_Period]DM_AferCo2dimension[ConcatFields][Calculation_790944717444796416][Product_Equipment_Name]+[Prod_Conso_Indic]+[Vector_Name]+[Std_Qty] [Prod_Conso_Indic], [Vector_Name], [Product_Equipment_Name], [Std_Qty]

                 e. Breakdown dashboardg. PCF validation status overview


Image AddedImage Removed

                 f. Biogenic   h. PCF Validation status Calculated fields

DatasourceTypeNameRemote_NameFormulaFieldsDM_PURE_Core_HD_SERF_Yearlydimension[Get PURE Data][Calculation_232357629656440832]"Get Data" DM_PURE_Core_HD_SERF_Yearlydimension[Reset button][Calculation_232357629682872321]"Reset All Filters" 


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true



                  I. Raw Materials


Image Added


DM_PURE_Core_HD_SERF_Yearlymeasure[Counter +1][Calculation_3313523471385870337][Parameters].[Counter] + 1 [Counter]DM_PURE_Core_HD_SERF_Yearlymeasure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]

                   gJ. PURCHASE Bom Balance


Image RemovedImage Added


                  h. PURCHASE Calculations

DatasourceTypeNameRemote_NameFormulaFieldsDM_Purchasingmeasure[Counter +1][Calculation_3313523471385870337][Parameters].[Counter] + 1 [Counter]DM_Purchasingmeasure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]

K. Bom Balance Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true


     

DM_Purchasingdimension[Get data][Calculation_967711005884104706]"Get data" 
  1. PCF Related Dashboards

           

 a.Product List

L. Emission Changes


Image Added


                 

         1.Dashboard

M. Emission Changes Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true

Image Removed





                           2N.Attributes Dependencies - Advanced workbook


Please, download and open this document for an interactive version: Advanced Network dependencies

Image AddedImage Removed




         

 b.Product Details

       O. PCF - Product Carbon Footprint Advanced Workbook data model

Image Added

Image Removed




           c 3. PCF - Validated Product BreakdownCarbon Footprint

Image Removed


                d.Biogenic a. Validated Product list dashboard



Image Added


                  b. Validated Product list Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true




                 1.Dashboard c. Biogenic Validated Product list dashboard



Image AddedImage Removed


                  d. Biogenic Product list Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true



                       2.Biogenic Dependencies

Image Removed

  

 e. Breakdown dashboard



Image Added



               

   f

f.

PCF &

Breakdown

CalculationsRefer to GSheet for Calc. details and definition

list Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/

1IUHaIPGbNZJaqlNV2hD86hc3O4kklcDhCw89t1Jeh90

1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=

sharing

drive_link&ouid=110708705167722191522&rtpof=true&sd=true


               

 g. PCF - Product Carbon Footprint Advanced Workbook

g. Contribution Dashboard


Image Added

Image Removed


               

         h.Parameters

 

DatasourceTypeNameRemote_NameFormulaFieldsParametermeasure[Volume / Total CO2][PCF/Weighted PCF (copy)_313563185235230725]"Total CO2" 

g. Contribution Changes list Calculated fields


Please refer to the document:

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1rV1Xu3Qi1V6lFIcAzz9Kn8BX9fPxL2CJ/edit?usp=drive_link&ouid=110708705167722191522&rtpof=true&sd=true


                 h.Attributes Dependencies - Advanced workbook


Please, download and open this document for an interactive version: 




                 i. PCF - Product Carbon Footprint validated Workbook data model


Image AddedImage Added




  

Parametermeasure[Whitespace][Parameter 1 1]0.663831915957979 Parametermeasure[Show/Hide][Parameter 1]"Energy" Parametermeasure[Counter][Parameter 2]144.0 Parametermeasure[MatName/SiteName][Parameter 6]"MatName"