Data flow
The data flow is based on the LSA method. The data visualization is done on the MultiProviders MVSDSO56 (Global Sales: Historical data (SO+PO)) and MVSDSO57 (Global Sales: Historical data JUMP (PO+SO)).
Global Sales data layers:
- Propagation Layer
- Business Layer
- Reporting Layer
- Virtual Layer
The draw below present the data flow of the MultiProvider MVSDSO56 (MP: Global PO (Global Sales)):
Click on the draw to enlarge.
The draw below present the data flow of the MultiProvider MVSDSO57 (Global Sales: Historical data JUMP (PO+SO)):
Click on the draw to enlarge.
Propagation layer
The propagation layer is same than for Historical data sales order and Historical data transfers orders
Business layer
List of InfoProviders used in the business layer:
| DSO tech. name | DSO description | source DSO tech. name | source DSO description |
|---|---|---|---|
| DBSDSO9O | Global sales: Delivery (PO+SO) (Rhodia) | DBSDSO54 | SO Global: Deliveries (Rhodia) |
| DBSDSO69 | PO Global: Transfers orders delivery (Rhodia) | ||
| DBSDSO9N | Global sales: Delivery (PO+SO) (Solvay) | DBSDSO14 | SO Global: Deliveries (Solvay) |
| DBSDSO29 | PO Global: Transfers orders delivery (Solvay) | ||
| DBSDSO9Q | Global sales: Invoice (PO+SO) (Rhodia) | DBSDSO46 | SO Global: Invoices (Rhodia) |
| DBSDSO67 | PO: Transfers orders Invoices (Rhodia) | ||
| DBSDSO9P | Global sales: Invoice (PO+SO) (Solvay) | DBSDSO06 | SO Global: Invoices (Solvay) |
| DBSDSO27 | PO: Transfers orders Invoices (Solvay) | ||
| DBSDSO9M | Global sales: Order line (PO+SO) (Rhodia) | DBSDSO51 | SO Global: Sales Document Item Data (Rhodia) |
| DBSDSO70 | PO: Order line Transfers orders (Rhodia) | ||
| DBSDSO9L | Global sales: Order line (PO+SO) (Solvay) | DBSDSO11 | SO Global: Sales Document Item Data (Solvay) |
| DBSDSO30 | PO: Order line Transfers orders (Solvay) |
Reporting layer
List of infoproviders used in the reporting layer:
CUBE tech. name | CUBE description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
| CRSDSO58 | Global Sales: Delivery (PO+SO) (Rhodia) | DBSDSO9O | Global sales: Delivery (PO+SO) (Rhodia) |
| CRSDSO56 | Global Sales: Delivery (PO+SO) (Solvay) | DBSDSO9N | Global sales: Delivery (PO+SO) (Solvay) |
| CRSDSO60 | Global Sales: Invoice aggregated (PO+SO) (Rhodia) | DBSDSO9Q | Global sales: Invoice (PO+SO) (Rhodia) |
| CRSDSO59 | Global Sales: Invoice aggregated (PO+SO) (Solvay) | DBSDSO9P | Global sales: Invoice (PO+SO) (Solvay) |
| CRSDSO55 | Global Sales: Order line (PO+SO) (Rhodia) | DBSDSO9M | Global sales: Order line (PO+SO) (Rhodia) |
| CRSDSO49 | Global Sales: Order line (PO+SO) (Solvay) | DBSDSO9L | Global sales: Order line (PO+SO) (Solvay) |
| CRSDTR03 | TR Rep: Shipment Costs (Rhodia) | DBSDTR03 | TR Bus: Shipment Costs (Rhodia) |
| CRSDTR23 | TR Rep: Shipment Costs (Solvay) | DBSDTR23 | TR Bus: Shipment Costs (Solvay) |
Virtual layer
List of InfoProviders used in the virtual layer:
MP tech. name | MP description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
MVSDSO56 | Global Sales: Historical data (SO+PO) | CRSDSO58 CRSDSO56 CRSDSO60 CRSDSO59 CRSDSO55 CRSDSO49 CRSDTR03 CRSDTR23 | Global Sales: Delivery (PO+SO) (Rhodia) Global Sales: Delivery (PO+SO) (Solvay) Global Sales: Invoice aggregated (PO+SO) (Rhodia) Global Sales: Invoice aggregated (PO+SO) (Solvay) Global Sales: Order line (PO+SO) (Rhodia) Global Sales: Order line (PO+SO) (Solvay) TR Rep: Shipment Costs (Rhodia) TR Rep: Shipment Costs (Solvay) |
| MVSDSO57 | Global Sales: Historical data JUMP (PO+SO) | DBSDSO9O DBSDSO9N DBSDSO9Q DBSDSO9P DBSDSO9M DBSDSO9L | Global sales: Delivery (PO+SO) (Rhodia) Global sales: Delivery (PO+SO) (Solvay) Global sales: Invoice (PO+SO) (Rhodia) Global sales: Invoice (PO+SO) (Solvay) Global sales: Order line (PO+SO) (Rhodia) Global sales: Order line (PO+SO) (Solvay) |
Data update
The update is done every working days
Process chain
The processes chains used are the same as for the Historical data Sales orders and Historical data Transfers orders.
Reporting
Core queries
The core queries are based on the MultiProviders MVSDSO56 and MVSDSO57.
Workbook | Query | ||
|---|---|---|---|
| Historical Data : Deliveries SO/PO (Detailed) | BW_WBK_MVSDSO57_0002 | BW - Deliveries details SO&PO (core query) | BW_QRY_MVSDSO57_0002 |
| Historical Data: Invoices Document Flow by creation date (SO+PO) | BW_WBK_MVSDSO57_0005 | BW - Invoices document flow details SO&PO (core query) | BW_QRY_MVSDSO57_0005 |
| Historical Data: Invoices SO/PO (Detailed) | BW_WBK_MVSDSO57_0001 | BW - Invoices details SO&PO (core query) | BW_QRY_MVSDSO57_0001 |
| Historical Data: Orders SO/PO (Detailed) | BW_WBK_MVSDSO57_0003 | BW - Orders details SO&PO (core query) | BW_QRY_MVSDSO57_0003 |
| Historical Data: Invoices vs Transport. Costs (SO/PO) | BW_WBK_MVSDSO56_0007 | Historical Data: Invoices vs Transp.Costs SO/PO (core query) | BW_QRY_MVSDSO56_0007 |
| Historical Data: Sales & Purchase deliveries | BW_WBK_MVSDSO56_0001 | Historical Data: Deliveries SO/PO (core query) | BW_QRY_MVSDSO56_0001 |
| Historical Data: Sales & Purchase invoices | BW_WBK_MVSDSO56_0003 | Historical Data: Invoices SO/PO (core query) | BW_QRY_MVSDSO56_0003 |
| Historical Data: Sales & Purchase orders | BW_WBK_MVSDSO56_0003 | Historical Data: Orders SO/PO (core query) | BW_QRY_MVSDSO56_0002 |
| Historical Data: Sales & Purchase overview | BW_WBK_MVSDSO56_0004 | Historical Data: Sales & Purchase Overview (core query) | BW_QR |