View Source

Premier Pilotage Sales

Contacts

BFC BU	RCS GBU	RCS Enterprises	Other queries	Broadcasts
Core Queries	all	all	Laurence De Zeeuw ~~Sandra Silveira~~ Diogo Paiva	Laurence De Zeeuw ~~Sandra Silveira~~ Diogo Paiva
SPECIAL-CHEM other	ZSECT00075	ENTRP00003 - ENTRP00162 ENTRP00185 - ENTRP00186 ENTRP00187 - ENTRP00188
NOVECARE	ZSECT00011	ENTRP00020	~~Justin Chafey~~
COATIS	ZSECT00064	ENTRP00061 - ENTRP00156
FIBRAS	ZSECT00063	ENTRP00075 - ENTRP00080
SOLVAY ENERGY SERVICES	ZSECT00007	ENTRP00153
AROMA PERFORMANCE	ZSECT00066	ENTRP00108	Marie Pereira	Marie Pereira
PEROXIDES	ZSECT00072	ENTRP00172 - ENTRP00191
PEPOL - ENGINEERING PLASTICS	ZSECT00077	ENTRP00030
PEPOL - ENGINEERING PLASTICS	ZSECT00077	query SAFIR SALES PLAN PRE-SOIP EPWWPPESAFIR R002 COMMODITY	Valerie Stoeckel	Valerie Stoeckel
PEPOL - ENGINEERING PLASTICS	ZSECT00077	queries "NEW PRODUCT…"	Martine Mauco	--
PEPOL - ENGINEERING PLASTICS	ZSECT00077	query KA REPORT	--	Sylviane Larboulette
PEPOL - POLYAMIDE & INTERMED (in KGW)	ZSECT00077	ENTRP00031
PEPOL - other	ZSECT00077	ENTRP00103 - ENTRP00168
SODA ASH	ZSECT00073	ENTRP00173
SILICA	ZSECT00067	ENTRP00002	Audrey Laurent	Audrey Laurent
SEPCIALITY POLYMER	ZSECT00071	ENTRP00170
ACETOW	ZSECT00019	ENTRP00151 - ENTRP00158 ENTRP00159 - ENTRP00160 ENTRP00161
TECHNOLOGY SOLUTIONS	ZSECT00078	ENTRP00190

Overview

The PPS - Premier Pilotage Sales application deals with sales data extracted from SAP SD module (Rhodia Legacy only) at a detailed level including sales orders, deliveries, shipments and invoices.

TECHNO - BI TEAM > PPS > image2016-5-31 14:23:36.png

Database Diagram

Main Fact Tables

TECHNO - BI TEAM > PPS > image2016-5-23 9:3:31.png

Main Master Data

TECHNO - BI TEAM > PPS > image2016-5-23 9:40:46.png

Universe Documentation

PP_F1_E (UNV) - Premier Pilotage Sales frozen universe in UNV version

The UNV version of PPS universe has been kept for compatibility reasons in order to support non-migrated WebI reports from BOXI in personal folders.

TECHNO - BI TEAM > PPS > image2016-6-7 15:48:42.png

Link to documentation of UNV version of PP_F1_E universe (PDF)

PP_F1_E (UNX) - Premier Pilotage Sales in UNX version

The UNX version of PPS universe is being updated regularly.

Data Foundation (PDF)

TECHNO - BI TEAM > PPS > image2016-5-31 14:35:23.png

Business Layer (PDF)

TECHNO - BI TEAM > PPS > image2016-5-31 14:34:19.png

Main BI4 Core Reports

BI4 core folder: 1 - PPS/PPE Corporate Reports

TECHNO - BI TEAM > PPS > image2016-6-7 15:9:15.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:16:15.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:18:21.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:19:29.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:22:5.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:22:56.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:24:18.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:29:45.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:28:51.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:28:2.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:30:42.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:31:35.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:33:3.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:33:41.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:34:59.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:35:59.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:36:33.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:37:11.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:38:3.png

TECHNO - BI TEAM > PPS > image2016-6-7 15:38:51.png

PPS functional documentation

Link for general PPS documentation

Useful links

Link to UpToDate documentation of universes (from 360 eyes)

Link to Knowledge Transfer to CGI documents for PPS universe