You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Sales Performance Commercial Roadmap

Reporting Coordinator

Sandra Silveira
 IS OtC Reporting Coordinator

D&PS Expert

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

 

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels