General presentation

List of contacts

• Charlotte ROLLIER : Finance Reporting Leader
• Guillaume Thevenet  (SBS Information Services) : BW Coordinator

Objective of the application

Background:

The inter-company service charges and cost allocation process for Solvay’s Corporate and Business Services (CBS) is time consuming, manually maintained, lacks appropriate technology enablement and is controlled across multiple functions.

We need a process to automate the data loading process to remove the drawback of manual process.

Objective

The objective of application is to allow users loading data from excel files with validation of content. 

Tool Leader + IT leader of the application: 

Usage information

Around 4 users worldwide.

History

The project was started in May/2016 and was in go-live in June/2016. It was requested by CBS project manager Nathalie Delahousse and approved bt Sandrine Micollet,

Link about the specifications :

CBS Database - support for inter-company invoicing

Roles & Access

Roles and access

Toe Be Confirmed

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

Authorization objects

List of autorisation objects mandatory for the application.

Dataflow overview

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Exemple of dataflow overview :

Template Application name DataFlow

Functional and Technical rules on Workbench + Reporting

We can create authorization object to restrict access to users for Transaction code ZBW_PAPM.

We can also restrict access at granular level for all users, example  at company code or controlling are etc..

For driver data available for PaPM, we can display data available in BW in the screen.
We control the content of the file to be sure that there is no error (missing field or incorrect values).

Once data is loaded:

• The file is saved as csv in /exploit/BW/PaPM in BW server
• The previously loaded data in BW staging is deleted
• The info-packages are executed to load the new flat file previewed and checked by user in respective PSAs.
• The process chains are executed
  • By schedule (hourly with abap condition looking time in global filter).
  • Manage “delta queue” is several loadings at the same time
• Three other process chains to load from PSA to BW Info provider
  • For all 3 driver data
  • Loads data in respective ADSOs
  • Process chain runs twice a day (managed in Global filter master data)

An ABAP program was developed to help user loading flat file for all three driver data required for PaPM application.

We have created a specific transaction  :  ZBW_PAPM to run the ABAP program

The program technical name is              :  ZBW_CBS_INT_COMP_INV  

The program title/description is             :  Load CBS PaPM Data - 3 Drivers and Transactional source

With this transaction, user can load excel file for

• • CBS-PAPM-Driver1-Amount.

  • CBS-PAPM-Driver2-Head Count

  • CBS-PAPM-Driver3-Cadre and All

The transaction is available in SOLIA portal. For information, it's better to use IE and not Chrome

Rules & Explanations

Below there is a list of entries in global filter used to support the program to do several activities, like: check authorizations, upload flat file, check company code, run process chain, etc.

There is an ABAP condition ZBW_UPDATE_GLB_FILTER used to define the hours that the process should be executed based on global filter rule PAPM_STIME,  twice a day @11 Hours and 15 Hours.

Lay-out of files

CBS-PAPM-Driver 1-Amount

Flat file driver 01 structure :  Advanced DSO APCOPA01

CBS-PAPM-Driver 2- HeadCount

Flat file driver 02 structure :  Advanced DSO APCOPA02

CBS-PAPM-Driver 3-Cadre and All

Flat file driver 03 structure :  Advanced DSO APCOPA03

Dependencies with other applications

Data loadings

Info providers and objects loaded

Data Load process Steps and Process Chains

Step 1: Initializing/Deleting Data from previous loads through application(PCs trigerred thro' event trigger)

1.  PC_CBS_PAPM_001A  -  PC CBS PaPM - Driver 1 Amount Del PSA              - Event Trigerred  -  PC_CBS_PAPM_001A
2.  PC_CBS_PAPM_002A  -  PC CBS PaPM - Driver 2 Head Count Del PSA       - Event Trigerred   -  PC_CBS_PAPM_002A
3.  PC_CBS_PAPM_003A  -  PC CBS PaPM - Driver 3 Cadre Del PSA                 - Event Trigerred   -  PC_CBS_PAPM_003A

Step 2: Flat File loading for New Driver KPIs and data-flows

Step 3 : Load data to aDSOs through main process chain

The main process chain to load all three driver data on a daily basis from PSA to ADSO is as below

1. PC_CBS_PAPM - CBS: Global PC PaPM PC_CBS_PAPM Change 

Local Process chains to load all three driver data through the application to PSA and Events

1. PC_CBS_PAPM_001  -  PC CBS PaPM - Driver 1 Amount    
2. PC_CBS_PAPM_002  -  PC CBS PaPM - Driver 2 Head Count 
3. PC_CBS_PAPM_003  -  PC CBS PaPM - Driver 3 Cadre

Loading frequency

       1. Data Loading to PSA by user : 

           Adhoc when users use the application

      2. Data Loading to PSA for reporting:

           Twice daily at 11 hours and 15 hours

Process Chain Details

1. PC_CBS_PAPM_001A  -  PC CBS PaPM - Driver 1 Amount Del PSA              - Event Trigerred  -  PC_CBS_PAPM_001A

2. PC_CBS_PAPM_002A  -  PC CBS PaPM - Driver 2 Head Count Del PSA       - Event Trigerred   -  PC_CBS_PAPM_002A

3.PC_CBS_PAPM_003A  -  PC CBS PaPM - Driver 3 Cadre Del PSA                 - Event Trigerred   -  PC_CBS_PAPM_003A

4. PC_CBS_PAPM_001  -  PC CBS PaPM - Driver 1 Amount    - run in main Process chain

5. PC_CBS_PAPM_002  -  PC CBS PaPM - Driver 2 Head Count  -  run in main Process chain

6. PC_CBS_PAPM_003  -  PC CBS PaPM - Driver 3 Cadre - run in main Process chain

Main Chain

Data-loading Layers

Transformations

1.DTS_FF_PAPM_002 PC_FILE -> ADSO APCBSI01

2. DTS_FF_PAPM_003 PC_FILE -> ADSO APCBSI02

3. DTS_FF_PAPM_004 PC_FILE -> ADSO APCBSI03

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

BW_QRY_CPCBSI01_0001 PAPM BW Transactional data with version

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution