Premier Pilotage Sales

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.

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

Useful links

Link to UpToDate documentation of universes (from 360 eyes)

Link to Knowledge Transfer to CGI documents for PPS universe