Energy Forecast prices are collected in a BW-IP workbook and then integrated in Manufacturing VC query to calculate the Energy cost for projected months.
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
Provide some history of the application : When was it created ? What was the initial project ? Who was the original requestor ? If possible provide link to the project information
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_M79 | Forward Looking ICM - Energy - Menu | Role Menu |
| ZBI_RCS_CO_A07 | Forward Looking ICM - Energy | Authorization objects |
List of authorization variables mandatory for the application.
| Authorization variables | Object |
|---|---|
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA |
| V_C_PLANT_0012 | C_PLANT |
| V_CPFCTR1_2_0006 | CPFCTR1_2 |
Link to dataflow overview diagram:
https://app.diagrams.net/#G1RLCMm5yN06FOmvBvRN5HOSCk1xwCFtvl
There are 2 workbooks concerning Energy Forecast:
The first one ("FL - Energy Forecast") is common for Novecare and SpP and is used to save Energy unit price typed by the users. This is done at plant/activitiy level (activity is ELEC, GAS, STEAM, etc)
Energy unit price is stored in DSO ABCOPC10.
For Novecare, we get the latest Actual price (month M) from the BOM, for each plant/activity, to use as proposed price for future (M+12) months. Then the user can change the prices and save.
For SpP, there is no proposed price because we don't have this level of detail in the BOM in PF1 (by activity type). So we load from the BOM only the plants, then the activities are "artificially" created in BW from the list of commodities in master data C_ENERGY, and the user can input the price.
For SpP, there is a specific process covered by the second workbook ("FL - Energy Forecast - SPP Usage Factor) where the users save the usage factor by plant/H4/product hierarchy.
Actually this is where the process starts for SpP.
Calculation View : CV_FMCO_SP_FORE_UF
Filters:
1- All Material with product Hierarchy : ("0PROD_HIER" != '')
2- "CPFCTR1_2" = 'SP'
3- "C_ENERGY" = 'ELEC' or "C_ENERGY" = 'GAS' or "C_ENERGY" = 'STEAM' or "C_ENERGY" = 'OTHER'
After data is loaded in ABCOPC15, then it's used in CV below to calculate the Energy Cost (quantity * price)
Calculation View : CV_FMCO_SP_FORE_UF2
In CV_FMCO_MAN_COST_RCS, for each plant/activity from the BOM, we get the forecast price from ABCOPC10 for the subsequent months.
If no forecast is found, Actual data is extrapolated for the future months (same logic as Raw Material Forecast)
Link to project folder:
Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...
Detail of process chain, list + link between or special event done for the loading
Detail of frequency : monthly; weekly or else
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 |
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.
List recurring procedures
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