Versions Compared

Old Version 2

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:

Image RemovedImage RemovedImage Added



         2. PCF - Product Carbon Footprint Advanced Workbook


    1. Product List dashboard



Image RemovedImage Added


                   bb. Product List Calculated fields

DatasourceTypeNameRemote_NameFormulaFieldsDM_IMEPmeasure[Counter +1][Calculation_3313523471385870337][Parameters].[Counter] + 1 [Counter]DM_IMEPmeasure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]DM_IMEPdimension[Fiscal Year ][Calculation_369576648555298819]DATE(DATEPARSE ( "MMMM-yyyy", str([Month]+'-'+[Year]) ))  [Month], [Year]DM_IMEPdimension[Month][Calculation_369576648803409928]DATENAME('month',  date('2020-' + iif(int(RIGHT([Prod_Year],2)) < 10, '0','') + str(RIGHT([Prod_Year],2)) + '-01')) [Prod_Year]DM_IMEPdimension[Year][Calculation_369576648804302857]LEFT([Prod_Year],4) [Prod_Year]DM_IMEPdimension[fiscal test][Calculation_369576648806055950]DATETRUNC('month', [Fiscal Year ]) [Fiscal Year ]DM_IMEPmeasure[Quantity.calc][Calculation_724235158836436993]str(SUM([Actual_Qty])) [Actual_Qty]DM_IMEPdimension[Concat Attributes][Calculation_898468155956629505][Plant_Code]+[Company_Code]+[BFC_GBU]+[Material_Name]+[Material_Type] +[Origin_Name] [Origin_Name], [Material_Name], [BFC_GBU], [Plant_Code], [Material_Type], [Company_Code]DM_IMEPdimension[Get data][Calculation_967711005884104706]"Get data" DM_IMEPdimension[Counter Even/Odd (text)][Counter Even/Odd (copy)_3313523471392264195]IF [Parameters].[Counter]%2 = 0 THEN 'Even' ELSE 'Odd' END [Counter]DM_IMEPdimension[Material Code ]


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

[Material_Code - Split 1]RIGHT([Material_Code],7) [Material_Code]


                 

                    c. CERISEBiogenic dashboard



Image RemovedImage Added


                   d. CERISE Calculations

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]

d. Biogenic 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


                  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_AferCo2measure[Counter Even/Odd][Calculation_3313523471392104450][Parameters].[Counter]%2 [Counter]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. PURE

Image Removed

g. PCF validation status overview


Image Added

                   f. PURE Calculations

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" 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]

h. PCF Validation status 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



                  I. Raw Materials


Image Added


                   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

Image Removed

- Advanced workbook


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

Image Added




               

 b

 O.

Product Details

PCF - Product Carbon Footprint Advanced Workbook data model

Image AddedImage Removed




           c 3. Product BreakdownImage RemovedPCF - Validated Product Carbon Footprint


                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 Data ConnectionImage Removed

g. Contribution Dashboard


Image Added


               

         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"