General presentation
Objective of the application
The goal of the application is to extract data from BW WBP to Anaplan.
This solution is based on flat files automated generation.
Anaplan documentation is available on the following wiki page : https://wiki.solvay.com/x/cwBvKg
Tool Leader + IT leader of the application: Guillaume.THEVENET@solvay.com
Usage information
N/A
History
N/A
Master Data extraction
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
Original User requirements are available in the following document: BW requirements - Basic master data and Exchange rates for Anaplan F2G models
Flat files are generated using '.txt' extension and comma separator ','.
All extracted description is done using english language EN.
All generated files are stored in AL11 folder /exploit/BW/Anaplan_outbound:
These are generated by OpenHubs located in InfoArea IA_FMCO_CO_CT_VIRTUAL:
Generated file's names and location are set up using logical file (Transaction FILE):
In order to generate header lines in flat files, an ABAP specific solution has been implemented in all extraction data flow.
Concerning this solution, the dedicated documentation is available : OpenHub for APD CSV File interface.docx
1) Region (Com); Country (Com)
Name of the flat file: Region_country.txt
Heading columns:
Country code | Country description | Zone code | Zone description |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT10 | Controlling - F2G Anaplan- Region Country |
| Source: | Query BW_QRY_CPCOCT01_0010 | COSTA - F2G Anaplan - Region Country |
Specific rules:
- Source query has the same filters as the query BW_QRY_CPCOCT01_0002 COSTA - Cost Transparency - Origin view
- Fiscal Period: from January year n-1 (last year) to December year N (current year)
- Exclusion of Country key = Unassigned # and Geographie/Zone = Unassigned #
2) Site
Name of the flat file: Site.txt
Heading columns:
Geography / Geographic site CODE from C_SITE | Geography / Geographic site Description |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT02 | Controlling - F2G Anaplan - SITE |
| Source: | TEXTS C_SITE | Geography / Geographic site (Texts) |
Specific rules:
- Exclusion of the record if Site Long Text contains the character '#'
3) Function
Name of the flat file: Function.txt
Heading columns:
4 Sub-function code | 4 Sub-function description |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT03 | Controlling - F2G Anaplan - FUNCTION |
| Source: | TEXTS C_FUNCT_4 | 4 Sub-function (Texts) |
4) BU
Name of the flat file: BU_BFC_Group_of_activities.txt
Heading columns:
/BIC/C_FACUBU code | /BIC/C_FACUBU description |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT04 | Controlling - F2G Anaplan - BU |
| Source: | TEXTS C_FACUBU | Current Business Unit (Texts) |
5) Currency List
Name of the flat file: Currency_list.txt
Heading columns:
Local Currency | Description local currency |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT05 | Controlling - F2G - Currency list |
| Source: | Query BW_QRY_DAFICE01_0010 | BW - F2G Anaplan - Currency list |
6) Legal Entity
Name of the flat file: Legal_entity.txt
Heading columns:
Company Code - PRS Company code | Description of company code |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT06 | Controlling - F2G Anaplan - Legal Entity |
| Source: | TEXTS C_COMPPRS | PRS Company code (Texts) |
7) BSA
Name of the flat file: Bsa.txt
Heading columns:
BSA code | BSA description |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT07 | Controlling - F2G - BSA |
| Source: | BW_QRY_CPCOCT01_0011 | COSTA - F2G Anaplan - BSA |
8) Exchange rates
Name of the flat file: CAR5_exchange_rates.txt
Heading columns:
Unique ID | Currency Type | Currency | Year | Month | Conversion Rate |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT08 | Controlling - F2G - Exchanges rates |
| Source: | BW_QRY_DAFICE01_0011 | BW - F2G Anaplan - Exchange rates |
9) GBU code and description
Name of the flat file: GBU_description.txt
Heading columns:
GBU code | GBU Description |
Flat file content example:
Dataflow:
| OpenHub name: | OH_COCT09 | Controlling - F2G Anaplan - GBU |
| Source: | BW_QRY_CPCOCT01_0012 | COSTA - F2G Anaplan - GBU |
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |