General presentation
The application loads data about asset accounting from ECC (just Rhodia RCS) into BW.
It is done daily using delta process via process chain schedule.
List of contacts
- Sandrine Micollet (SBS Information Services) : Reporting Coordinator
- Guillaume Thevenet (SBS Information Services) : BW Coordinator
Objective of the application
Tool Leader + IT leader of the application:
Usage information
History
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M33 | User Reporting FIAA | role menu |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| ZBI_FIAA | Accounting Asset |
| ZBI_FIAA_K | Accounting Asset key users |
| Z_FIAA | Accounting Asset (obsolete) |
| Z_FIAA_K | Accounting Asset key users (obsolete) |
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Process chain
- PC_FIAA - FI - Asset Accounting
DSOs
- DSOCOEPD - CO Object: Line Item Settlement With Status
- DSO6COEP - CO Object: Line Item Settlement With Status - Solvay
- DSO_FAA2 - FIAA: Annual Values
- DSO_FAA3 - FIAA: Period Values
- DSO_FAA1 - FIAA: Transactions
Cubes
- CUB_FAA4 - FIAA : Period Value
- CUB_FAA2 - FIAA: Annual Value
- CUB_FAA1 - FIAA: Cumulated Movements
- CUB_FAA3 - FIAA: Transactions
Multi Providers
- MPR_FAA3 - Annual Values and Transactions
- MPR_FAA1 - FIAA: DSO Annual Values and Transactions
- MPR_FAA2 - FIAA: DSO Period Values and Transactions
- MPR_FAA4 - FIAA: Period Values and Transactions
Main Master Data
- 0ASSET - Asset Sub-number
- C_ASSET - Asset Sub-number
- C_ASSET2 - Asset Sub-number
- C_AT_AFAB - Depreciation Area Real or Derived
- C_AT_AFA2 - Depreciation Area Real or Derived (not compound)
Main Extractors
- 0FI_AA_11 - FI-AA: Transactions
- 0FI_AA_12 - FI-AA: Posted Depreciation
0ASSET_AFAB_ATTR - Depreciation Area Real or Derived
Data Flow
Loading frequency
The loading is done daily using the process chain below: PC_FIAA.
Average performance
Daily process chain loaded in 50 minutes average with around 15K records inserted from delta mode process
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 50 to 80 minutes |
| ~ Average nb of rows loaded per load | 100K to 1200K records (all providers) |
| ~ Total nb of rows loaded (if full) | DSO_FAA1 (58.000K) since 2011 DSO_FAA2 (19.000K) since 2011 DSO_FAA3 (19.000K) since 2011 |
| ~ Average Runtime for 10k lines | 30 minutes |
Record Keeping
The data is kept since 2011.
Reporting
Queries End User Documentation
Asset Queries - key figure definition
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution