The objective is to load in a BW flow flat files resulting from an extraction of the Stock Margin Elimination query at defined moments. We want to keep a picture at a time T of the data.
Specification link :
How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site
The decommissioning data flow structure (UPIS) was used for this project.
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
If there are any errors when checking the contents of each file, we will send an email with a quick description of the various inconsistencies. The file will be not loaded into BW and the old data will be kept if the file is already loaded, otherwise we will have no data for that month/gbu. The same email will be sent in the new loading phase (Day +1) if the file has not been corrected
In case the file for the month and GBU is already load in the ODS and the update date on AL11 is higher than this loading then we remove by selective deletion the old file.
| Global Filter Stream (Application) | "Global Filter Rule" | "Global Filter" | Global Filter Active | Global Filter Description | Global Filter Hight Value | Global Filter Low Value | Global Filter Option | Global Filter Sign |
| UPIS | FF_DATA | 1 | Y | Input filename for ZBW_FI_1CP_STOCKMARGIN program | INIT | EQ | I | |
| UPIS | FF_DATA | 2 | Y | EMAIL Recipient Receiver Name | To be define | EQ | I | |
| UPIS | FF_DATA | 3 | Y | Flat File Month (Empty = SY-DATUM-1) | EQ | I |
Flat files have to upload each month (Data of previous month) in BW AL11 via WebMethod application
In case the file of the month has to be corrected, the old file on the BW server has to be replaced by the corrected file. In BW Query, the old upload will be deleted and replaced by the new file content.
Example:
YYYYMM = YYYY Fiscal year (ex. 2022) MM = month (ex. 01)
XX = BFC GBU code (ex. CS) YYYY Fiscal year (ex. 2022) PP = month (ex. 01)
- The structure of the files will never be modified (same column, same order).
- No data column can be empty
- All information (GBU, BFC activity ...) must exist in the BW master data.
- The column 0CALMONTH must be equal to the month in flat file title
If any of the conditions below are not met, the file will not be uploaded to the BW data stream and an email will be sent with an error summary.
WebMethod application.
PC_COPA_PL_20 / UPIS: TD : Main Process Chain
PC_COPA_PL_19 / UPIS: Upload UPIS Data : Process Chain called by program in PC PC_COPA_PL_20
Daily
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
Give details if any historisation is done, example: keep only data greater than beginning of Y-3
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.
List the most important and complex queries only with a link to the documentation
Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts
Indicate if there are broadcasts and give some details on the broadcast settings.
Give the list and explanation on the known, not-solved, bugs.
It is possible to load files from previous months. To do this you just need to change the parameter UPIS/FF_DATA/003 in the Master Data C_GBLFILT.
For example if you want to load the file named "202201_SP_R15430_Stock_Margin_Elim.csv" you have to put the value "202201" in the Global Filter Low Value and run the process chain. All the flat file with name contain "202201" will be load.
In the case where a file in the past wants to be recovered or modified, it is necessary to apply the procedure above.
For each file uploaded (depending on the month), if the file has been modified on the AL11 directory (modification date) more recently than the last upload in the propagation ODS then
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