Sales Performance Commercial Roadmap

Sandra Silveira
 IS OtC Reporting Coordinator
Miriam Luttrin

General Description

Commercial Roadmap allows users to compare their GBU's Commercial Roadmap from Salesforce vs actuals easily. Compare using 3 indicators: Revenues, Volumes, or Average Sales Price:


 

 

Sources

Actuals:

Commercial Roadmap
Core query

PF1: BW_QRY_ZCONACT_0001
BW_QRY_ZZVES1_001

WP1:

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