General presentation

The application loads data of the transportation shipments, deliveries and shipment costs from ECC (Solvay and Rhodia) into BW.

It is done daily using delta process via process chain schedule.

TIERS means Transport Integrated and Enhanced Reporting Solution

List of contacts

• Jean Baptiste Cercueil  (SBS logistics Excellence) : Business Application Owner
• Sandra Silveira (SBS Information Services) : Reporting Coordinator
• Guillaume Thevenet  (SBS Information Services) : BW Coordinator
• Nestor Araujo  (SBS Information Services) : BW Technical Developer

Objective of the application

• One unique reporting solution for the group
• Rationalization of the “live” solutions and reduction of evolutions requested
• Maintainable and sustainable solution.
• Enabler for productivity actions on Shipment costs
• Drillable solution - allowing possibility to detect & analyse problems by showing the link from aggregated figures down to document in SAP.
• Few “core” queries/workbooks design for application (=> Use BW analysis functionalities and not just as extractor).
• One common & consolidated reporting space.

Reasons

• Revamped reporting BW solution based on RCS (WBP-TR002) but built on old historical architecture (no project on this application for years) - mainly designed for cost reporting.

• Only aggregated monthly data available on PF1.

• Specific solution (cross legacies) built for CO2 footprint with activation of some standard extractors on PQ1.

• More than 250 existing queries in SAP => almost impossible to maintain on an efficient way, most of then not or almost not documented.

• Some previous experiences of common transversal reporting tools : WISE (working cap.) and SPRINT (Purchasing and Procurement).

• “Drillable” solution - allowing possibility to detect & analyse problems by showing the link from aggregated figures down to document in SAP.

• Few “core” queries/workbooks design for application (=> Use BW analysis functionalities and not just as extractor).

History

The Transportation Costs analysis was developed in 2007 to attend the Rhodia users of Logistic processes. The solution had usage several DSO’s and just one cube with many detailed information. The number of tickets about inconsistentes of data and bad performance some of triggers to develop a new application, in this case much more robust and covering also the Solvay data and its users.

The TIERS project was started in the begin of 2015, using a remodeling by layers Layered Scalable Architecture (LSA), in our case: propagation, business, reporting and virtual layers. The current transportation datasources from Rhodia were reused with low change and all datasources from Solvay were activated with low enhancements. Some additional master data were created to avoid duplication of data in different providers, like shipment document, shipment cost item and delivery item.

The development of project was request by the logistic areas and Jean Baptiste concentrated all the requests and generated the functional specification.

The project was started in April/2015 and it was deployed in December/2015 with all users trainned.

Usage information

Around 300 users, worldwide with daily update 

Statistics by infoproviders

PS: The providers marked in blue are important to be monitored, the other ones are referent to the old TR solution that should be desactivated soon.

Statistics by queries

General Rules

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

List of application role + menu role  and explanation if we have several applications role with specials rules.

NB: The role menu ZR_RCS_ALL_MENU "Role composite with all role Menu and perimeters" gives access to all role menu. When asking for a new role menu, do not forget it is added to that one.

NB: ZBI_RCS_TR_A02 & ZR_RCS_TR_A02 are obsolete

Authorization objects

List of autorisation objects mandatory for the application.

See also file maintained by Authorization team : 

• BW Catalog of Roles: Authorization catalog
• BW Authorization:      BW Authorizations