Versions Compared

Key

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


Sales Performance Commercial Roadmap


Info
iconfalse
titleReporting CoordinatorOwner
SBS CRM team
Sandra Silveira
 IS OtC Reporting Coordinator


Info
iconfalse
titleD&PS Expert
EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong
Miriam Luttrin




General Description

**Currently only available for Special Chem GBU.
Commercial Roadmap allows users to compare their GBU's Commercial Roadmap (sales commitments for current year and the next 4 years) from Salesforce vs actuals
easily
current and previous years. Compare using 3 indicators: Revenues, Volumes, or Average Sales Price:

 

 

The current year is used as Special Chem's budget in the other sections of this tool. This data is updated in May each year.
Example: Between January and May each year, we are using the data from the previous year's roadmap. After May, the data is then using current year's roadmap. Y (current year) will be used as the budget.


Sources

Additional Info

Salesforce.com
Currently only available for Special Chem GBU
Refresh frequency
Updated in May each year


Sources

Actuals:

Commercial Roadmap
Core query

PF1: BW_QRY_ZCONACT_0001
BW_QRY_ZZVES1_001

WP1:

Image Removed
Salesforce
QV query
QV_SALES RESULTS_CWWPPE_R002 [BI4 - Rhodia data]

BW_QRY_ZCONACT_0001 (Previous Months)

QVSBS_BW_QRY_ZZVES1_001 (Current Month)

QVCRM_BW_QRY_ZZVWS6_0001 [Flux (Special Chem) data]

QV_MONTERREY (manual file) [Monterrey (Special Chem data]

QVSBS_BW_QRY_C_COMPCDE_0001 (Consolidated Entity Flag)

Salesforce
Refresh frequency
Daily
Daily

Specific Dimensions

  • Ship To
  • Sold To
  • Product

Scope

  • Actuals Sales vs Commercial Roadmap


 
Note: The latest version of the commercial roadmap is always displayed!