Diogo Paiva
 IS OtC Reporting Coordinator
Miriam Luttrin

 

 

General Description

The Sales Performance section of the Analytics dashboard is where you will go to check your sales "actuals", or historical sales data. This section covers 2 historical years of data as well as year to date data for current sales.
This section is divided into several parts:

Each of these sections offers differing KPIs that provide insight into your actuals for your business.

 

 

Sources


Core query

PF1: BW_QRY_ZCONACT_0001
BW_QRY_ZZVES1_001

WP1:

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)

Refresh frequency
Daily for BI4. For BW SD Cube: Daily. For BW P&L: Monthly for Previous Month
Filters
All Intra Enterprise sales are excluded except for Silica, Novecare, and PePol GBUs.