GBU Sales & Marketing / Finance
Miriam Luttrin
KPISource SystemBI SystemCommentCore QueryQlikview Query
Order BookWP1BI4 PPSAll GBUs using WP1 except NovecareORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 [in Qlikview Folder]
Order BookWP1BI4 PPSOnly Novecare (to deal with extrapolation)ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001QV_NOVECARE_ORDER_BOOK_WW_NOVPPS_PPE_R001
Order BookPF1BW SD (OBAS) BW_QRY_MVSDSO01_SD004
BW_QRY_MVSDSO07_001		QVSD_BW_QRY_MVSDSO01_SD004 (Sales Orders)
QVSD_BW_QRY_MVSDSO07_001 (PO Orders for "invoiced" current month)
SalesWP1 & PF1BW P&L COPAExcept Chemlogic and PepolBW_QRY_MVCOPA01_0004QVSBS_BW_QRY_MVCOPA01_0004
SalesNon-SAPBI4 PPEFor Pepol, Chemlogic and BangpooSALES TREND & MANAGEMENT REPORT with CONTRIB-MARGIN (period) CWWPPE_R001QV_SALES RESULTS_CWWPPE_R002
SalesManual xlsXLSNon-ERP Company: Solvay & CPC Barium Strontium Monterrey
GBU Special Chem		  
Budget & BFRSAFIRSAFIRAvailable to GBUs that load budget and BFR QV_OBJECTIVES_CWWSAFIR_001
Overdue & DSOPRS (WP1 & PF1)BW FIAROverdue & DSOBW_QRY_MVFIAR01_0001QVSBS_BW_QRY_MVFIAR01_0001
Overdue & DSOPRS (WP1 & PF1)BW FIARAged OverdueBW_QRY_MVFIAR01_0006QVSBS_BW_QRY_MVFIAR01_0006
Sold & Pending OrdersWP1BO PPSAll Open Orders (no time limitation) QV_LIST_OF_OPEN_ORDERS_CWWPPS
Sold & Pending OrdersWP1BO PPSAll Invoiced Orders during the current monthLIST OF INVOICES_CWWPPS_R001QV_LIST OF INVOICES_CWWPPS_R001
CCRWP1BO PPSOrder Lines QV Complaint CRM by GBU CWWPPS 001
CCRPF1BW SD (OBAS)Order LinesBW_QRY_DBSDSO14_0001QVSD_BW_QRY_DBSDSO14_0001

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Sales
  • Marketing
  • Controlling
  • Supply Chain
  • Quality

All the accesses must be validated by:

GBU CRM Champions

or

Immediate Supervisor for Novecare GBU.

Margin data MUST be validated by CRM Champions/Finance Directors

Click here for the Access form to get access to Analytics.

Access Rights and Dashboard Entry Points - Click here for descriptions.