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

Use the google presentation below as a template. This google presentation must be saved in the Reporting GDrive folder under the corresponding application. Then post the link to the document here.

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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_17-14-23.png$

These are generated by OpenHubs located in InfoArea IA_FMCO_CO_CT_VIRTUAL:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_17-16-16.png$

Generated file's names and location are set up using logical file (Transaction FILE):

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_17-18-43.png$

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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-6-11.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-44-50.png$

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
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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-6-38.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-45-13.png$

OpenHub name:	OH_COCT02	Controlling - F2G Anaplan - SITE
Source:	TEXTS C_SITE	Geography / Geographic site (Texts)

Specific rules:

Exclusion of the record if Site Description 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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-7-34.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-45-37.png$

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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-9-44.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-46-4.png$

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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-10-11.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-46-18.png$

OpenHub name:	OH_COCT05	Controlling - F2G - Currency list
Source:	Query BW_QRY_DAFICE01_0010	BW - F2G Anaplan - Currency list

Specific rules:

Exchange rate type = CAR5
Period: from January year N-1 (last year) to December year N (current year)

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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-10-19.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-46-30.png$

OpenHub name:	OH_COCT06	Controlling - F2G Anaplan - Legal Entity
Source:	TEXTS C_COMPPRS	PRS Company code (Texts)

Specific rules:

Exclusion of the record if Company code description contains the string '*D*'

7) BSA

Name of the flat file: Bsa.txt

Heading columns:

BSA code

BSA description

Flat file content example:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-11-44.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-46-51.png$

OpenHub name:	OH_COCT07	Controlling - F2G - BSA
Source:	BW_QRY_CPCOCT01_0011	COSTA - F2G Anaplan - BSA

Specific rules:

Source query has the same filters as the query BW_QRY_CPCOCT01_0002 COSTA - Cost Transparency - Origin view
Period: from January year N-1 (last year) to December year N (current year)
Exchange rate type = CAR5
Zero suppression activated on Actual origin Key Figure

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:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-12-5.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-47-13.png$

OpenHub name:	OH_COCT08	Controlling - F2G - Exchanges rates
Source:	BW_QRY_DAFICE01_0011	BW - F2G Anaplan - Exchange rates

Specific rules:

Period: from January year N-1 (last year) to December year N+1 (next year)
Exchange rate type = CAR5
Conversion rate = Currency Exchange rate X Ratio for the From Currency / Ratio for the To Currency
Decimal separator for conversion rate is point '.'
An Unique ID is generated for each record by concatenation of : Convertion Type + To Currency + Year + Month (i.e.: CAR5EUR202112)
Conversion rate EUR to EUR (equals to 1) is added in routine for years N-1 to N+1

9) GBU code and description

Name of the flat file: GBU_description.txt

Heading columns:

GBU code

GBU Description

Flat file content example:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-16_18-12-17.png$

Dataflow:

$TECHNO - BI TEAM > BW RTR - Anaplan data export from BW /!\ Obsolete /!\ > image2021-12-17_10-48-24.png$

OpenHub name:	OH_COCT09	Controlling - F2G Anaplan - GBU
Source:	BW_QRY_CPCOCT01_0012	COSTA - F2G Anaplan - GBU

Specific rules:

Source query has the same filters as the query BW_QRY_CPCOCT01_0002 COSTA - Cost Transparency - Origin view
Period: from January year N-1 (last year) to December year N+1 (next year)
Filter on: Flag - Anaplan Perimeter = #

Dependencies with other applications

Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...

Data loadings

Info providers and objects loaded

Detail of process chain, list + link between or special event done for the loading

Loading frequency

Detail of frequency : monthly; weekly or else

Average performance

if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application

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

Record Keeping

Give details if any historisation is done, example: keep only data greater than beginning of Y-3

Reporting

Queries End User Documentation

Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.

Main queries

List the most important and complex queries only with a link to the documentation

Main functionalities

Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts

Broadcast

Indicate if there are broadcasts and give some details on the broadcast settings.

Maintenance

Known bugs

Give the list and explanation on the known, not-solved, bugs.

Recurring procedure

List recurring procedures

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016